SQL Data Source=(local);Initial Catalog=TourWriter true f2ffb85a-760a-4768-ac93-751d00b64041 SupplierName System.String SupplierID System.Integer ItineraryID System.Integer ItineraryName System.String PurchaseItemStartDate System.DateTime PurchaseItemEndDate System.DateTime PurchaseItemStartTime System.DateTime PurchaseItemEndTime System.DateTime PaxCount System.Integer ServiceTypeName System.String PurchaseLineName System.String PurchaseItemName System.String ServiceName System.String ServiceID System.Integer CityName System.String AgentName System.String AgentContactDisplayName System.String VoucherLogoFile System.String DataPath System.String CustomSort System.Integer PurchaseItemID System.Integer PurchaseItemDetail ------------------------------------ SELECT * FROM ( SELECT VoucherLogoFile FROM Agent A WHERE A.IsDefaultAgent = 1 )AgentContact OUTER APPLY ( Select ItineraryID, ItineraryName,PaxCount ,PurchaseItemStartDate ,PurchaseItemEndDate ,Convert(DateTime,Convert(Time,PurchaseItemStartTime)) PurchaseItemStartTime ,Convert(DateTime,Convert(Time,PurchaseItemEndTime)) PurchaseItemEndTime ,ServiceTypeName, PurchaseLineName, PurchaseItemName, SupplierName,SupplierID, ServiceName, ServiceID, CityName, AgentName, AgentContactDisplayName ,VoucherLogoFile ,CustomSort ,PurchaseItemID FROM PurchaseItemDetail P OUTER APPLY ( Select PurchaseItemCode, XrateParentCode from PurchaseItem Where PurchaseItemID = P.PurchaseItemID ) tableXrateParentCode OUTER APPLY (Select TOP 1 CountryID from Country WHERE Country.CountryName=P.CountryName)c WHERE P.PurchaseItemStartDate >= @StartDate AND P.PurchaseItemStartDate < @EndDate AND (ServiceTypeID in @ServiceTypeIDList) AND (AgentID in @AgentIDList) AND (ItineraryStatusID IN @ItineraryStatusIDList) AND (RequestStatusID IN @RequestStatusIDList) AND (BranchID in @BranchIDList OR BranchID IS NULL) AND (DepartmentID in @DepartmentIDList OR DepartmentID IS NULL) AND (CountryID in @CountryIDList) AND XrateParentCode is Null )tableP Outer Apply ( SELECT ExternalFilesPath DataPath FROM AppSettings )DataPathTable ORDER BY PurchaseItemStartDate,CustomSort,Convert(DateTime,Convert(Time,PurchaseItemStartTime)) ----------------------------------- true 1.17825in 0.42175in 0.75in 1in 1.3in 2in 1.25in 2.75in 1.04331in true PAX Tracker =vbcrlf & Format(Parameters!StartDate.Value,"dd/MM/yy") & Format(Parameters!EndDate.Value," - dd/MM/yy") Black 1pt 2pt 2pt 2pt 2pt 4 true true Black 1pt 2pt 2pt 2pt 2pt 3.01113in 2.98887in 1.04331in true true 2pt 2pt 2pt 2pt External =IIF(Len(First(Fields!VoucherLogoFile.Value, "PurchaseItemDetail")) > 0, IIF(Instr(lcase(First(Fields!VoucherLogoFile.Value, "PurchaseItemDetail")), "https:") > 0, First(Fields!VoucherLogoFile.Value, "PurchaseItemDetail"), "file:///" & First(Fields!DataPath.Value , "PurchaseItemDetail") & First(Fields!VoucherLogoFile.Value, "PurchaseItemDetail")), "file:///" & "\Images\AgentLogo\TWTravelLogo.jpg") '"file:///" & Parameters!DefaultImagePath.Value & "\Images\AgentLogo\TWTravelLogo.jpg") FitProportional 3 0.23622in true true Black 1pt Yellow 2pt 2pt 2pt 2pt true true Black 1pt Yellow 2pt 2pt 2pt 2pt true true Black 1pt Yellow 2pt 2pt 2pt 2pt true true Black 1pt Yellow 2pt 2pt 2pt 2pt true true Black 1pt Yellow 2pt 2pt 2pt 2pt true true Black 1pt Yellow 2pt 2pt 2pt 2pt true true Black 1pt Yellow 2pt 2pt 2pt 2pt true true Black 1pt Yellow 2pt 2pt 2pt 2pt 0.23622in true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt true true Gainsboro 1pt Black 3pt 2pt 2pt 2pt 2pt 0.23622in true true ITINERARY NAME Textbox3 Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true ID Textbox75 Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true DATE Textbox5 Black 1pt 2pt 2pt 2pt 2pt true true TIME Textbox6 Black 1pt 2pt 2pt 2pt 2pt true true SERVICE TYPE Textbox10 Black 1pt 2pt 2pt 2pt 2pt true true SUPPLIER Textbox8 Black 2pt 2pt 2pt 2pt true true CITY Textbox13 Black 2pt 2pt 2pt 2pt true true SERVICE Textbox22 Black 2pt 2pt 2pt 2pt 0.06955in true Textbox31 Black 1pt Black 1pt 2pt 2pt 2pt 2pt true true Textbox76 Black 1pt Black 1pt 2pt 2pt 2pt 2pt true Textbox33 Black 1pt 2pt 2pt 2pt 2pt true Textbox34 Black 1pt 2pt 2pt 2pt 2pt true Textbox35 Black 1pt 2pt 2pt 2pt 2pt true Textbox47 Black 2pt 2pt 2pt 2pt true Textbox48 Black 2pt 2pt 2pt 2pt true Textbox49 Black 2pt 2pt 2pt 2pt 0.19685in true true Textbox2 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox77 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox39 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox40 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox41 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox80 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox81 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox82 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt 0.23622in true true Textbox36 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox78 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox37 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox38 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox42 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox43 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox45 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox46 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt 0.23622in true true Textbox106 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox79 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox107 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox108 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox109 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox110 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox111 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox116 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt 0.23622in true PurchaseItemDetail true =IIF(Rownumber("GroupItin")=1, Fields!ItineraryName.Value & IIF(Len(Fields!PaxCount.Value)>0,"(" & Fields!PaxCount.Value & " pax)","") ,"") =IIF(Rownumber("GroupItin")=1, IIF(Len(Fields!AgentName.Value )>0,vbcrlf ,"") & Fields!AgentName.Value & IIF(Len(Fields!AgentContactDisplayName.Value)>0,vbcrlf,"") & Fields!AgentContactDisplayName.Value,"") Textbox97 2pt 2pt 2pt true true true =IIF(Rownumber("GroupItin")=1,Fields!ItineraryID.Value,nothing) ItineraryID 2pt 2pt 2pt 0.75in 1in 1.3in 2.02643in 1.22357in 2.75in 0.23622in true true =Fields!PurchaseItemStartDate.Value PurchaseItemStartDate LightGrey 1pt 2pt 2pt true true =LCase(Format(Fields!PurchaseItemStartTime.Value,"h:mmt")) & IIF(Len(Fields!PurchaseItemEndTime.Value)>0, "-" & vbcrlf & Lcase(Format(Fields!PurchaseItemEndTime.Value,"h:mmt")),"") Textbox5 LightGrey 1pt 2pt 2pt true true =Fields!ServiceTypeName.Value ServiceTypeName Black Black 1pt 2pt 2pt true true =Fields!PurchaseLineName.Value PurchaseLineName Black Black 1pt 2pt 2pt true true =Fields!CityName.Value CityName Black Black 1pt 2pt 2pt true true =Split(Fields!PurchaseItemName.Value,",")(0) PurchaseItemName LightGrey 1pt 2pt 2pt PurchaseItemDetail 6 0.23622in true true Textbox84 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox93 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox85 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox86 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox89 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox90 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox91 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox92 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt 0.06955in true Textbox3 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true true Textbox94 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true Textbox4 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true Textbox11 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt true Textbox15 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true Textbox16 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true Textbox17 Black Black 1pt Yellow 2pt 2pt 2pt 2pt true Textbox18 LightGrey 1pt Yellow 2pt 2pt 2pt 2pt 0.06955in true true Textbox21 Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox95 Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox23 LightGrey 1pt 2pt 2pt 2pt 2pt true true Textbox24 LightGrey 1pt 2pt 2pt 2pt 2pt true true Textbox27 Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox28 Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox29 Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox30 LightGrey 1pt 2pt 2pt 2pt 2pt 0.23622in true true Textbox1 Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox96 Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox6 LightGrey 1pt 2pt 2pt 2pt 2pt true true Textbox7 LightGrey 1pt 2pt 2pt 2pt 2pt true true Black Black 1pt 2pt 2pt 2pt 2pt true true Black Black 1pt 2pt 2pt 2pt 2pt true true Black Black 1pt 2pt 2pt 2pt 2pt true true Textbox26 LightGrey 1pt 2pt 2pt 2pt 2pt true true =Fields!ItineraryID.Value =Fields!ItineraryID.Value =Fields!PurchaseItemStartDate.Value =Fields!CustomSort.Value =Fields!PurchaseItemStartTime.Value true After =Fields!PurchaseItemID.Value =Fields!PurchaseItemStartDate.Value =Fields!CustomSort.Value =Fields!PurchaseItemStartTime.Value true true true Before PurchaseItemDetail 0cm 0.03in 8.47997cm 27.051cm 8.47998cm 0.02657in 3.80539in 0.5cm 4.89591cm true true ="Page " & Globals!PageNumber & " of " & Globals!TotalPages 0.02657in 5.75687in 0.5cm 2.49126cm 1 21cm 29.7cm 29.7cm 21cm 1cm 1cm 1cm 1cm 1.27cm en-US true bb0ee6a1-9417-4d69-9271-2e33f062e7ad Cm