2a832447-8f60-4f99-a9ee-1e9023bbc25b ItineraryName System.String ItineraryStatusName System.String PurchaseLineID System.Int PurchaseLineName System.String PurchaseItemName System.String BookingReference System.String RequestStatusName System.String PurchaseItemStartDate System.DateTime SupplierName System.String TotalNet System.Decimal TotalGross System.Decimal CurrencyFormat System.String CurrencyCode System.String SupplierNamePayee System.String PayeeID System.Integer PurchaseItemDetail SELECT P.SupplierID,P.SupplierName, sp.PayeeID ,IsNULL(s.SupplierName,p.SupplierName) as SupplierNamePayee ,sp.IsDefault ,ItineraryName,ItineraryStatusName,PurchaseLineID,PurchaseLineName,PurchaseItemName ,BookingReference,RequestStatusName,PurchaseItemStartDate ,NetBaseTotal as TotalNet,GrossBaseTotal as TotalGross , isnull(CurrencyFormat,'c') as CurrencyFormat, CurrencyCode FROM dbo.PurchaseItemDetail P LEFT OUTER JOIN SupplierPayee sp ON sp.SupplierID = P.SupplierID LEFT OUTER JOIN Supplier s ON s.SupplierID = sp.PayeeID WHERE PurchaseItemStartDate >= @StartDate AND PurchaseItemStartDate < @EndDate AND (ItineraryStatusID IN @ItineraryStatusIDList) AND (RequestStatusID IN @RequestStatusIDList) AND (sp.IsDefault=1 or sp.IsDefault IS NULL) true PurchaseItemDetail PurchaseItemDetail Fill GetData PurchaseItemDetailTableAdapter 0.7874in 1.72999in 3.14599in 0.69259in 0.88583in 0.80823in 0.80823in 0.88583in 0.88583in 0.15748in true true DATE 1pt 2pt 2pt 2pt 2pt true true ITINERARY 1pt 5pt 2pt 2pt 2pt true true SERVICE, OPTION 1pt 2pt 2pt 2pt 2pt true true BOOKING ID Textbox37 1pt 2pt 2pt 2pt 2pt true true BOOKING REF textbox1 1pt 2pt 2pt 2pt 2pt true true ITIN STATUS textbox5 1pt 2pt 2pt 2pt 2pt true true BKG STATUS Textbox30 1pt 2pt 2pt 2pt 2pt true true GROSS 1pt 2pt 2pt 2pt 2pt true true NET textbox10 1pt 2pt 2pt 2pt 2pt 0.09843in true true textbox3 1pt 2pt 2pt 2pt 2pt true true textbox12 1pt 5pt 2pt 2pt 2pt true true textbox18 1pt 2pt 2pt 2pt 2pt true true Textbox45 1pt 2pt 2pt 2pt 2pt true true textbox19 1pt 2pt 2pt 2pt 2pt true true textbox21 1pt 2pt 2pt 2pt 2pt true true Textbox33 1pt 2pt 2pt 2pt 2pt true true textbox23 1pt 2pt 2pt 2pt 2pt true true textbox24 1pt 2pt 2pt 2pt 2pt 0.19685in true true =Fields!SupplierNamePayee.Value + iif(not isnothing(Fields!CurrencyCode.Value), " (" + Fields!CurrencyCode.Value + ")", "") 1pt 2pt 2pt 2pt 2pt 3 true true 1pt 2pt 2pt 2pt 2pt true true 1pt 2pt 2pt 2pt 2pt true true 1pt 2pt 2pt 2pt 2pt true true 1pt 2pt 2pt 2pt 2pt true true 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!TotalNet.Value) 1pt 2pt 2pt 2pt 2pt 0.19685in true true =Fields!PurchaseItemStartDate.Value 1pt 2pt 2pt 2pt 2pt true true =Fields!ItineraryName.Value 1pt 5pt 2pt 2pt 2pt true true =Fields!PurchaseItemName.Value 1pt 2pt 2pt 2pt 2pt true true =Fields!PurchaseLineID.Value 1pt 2pt 2pt 2pt 2pt true true =Fields!BookingReference.Value 1pt 2pt 2pt 2pt 2pt true true =Fields!ItineraryStatusName.Value 1pt 2pt 2pt 2pt 2pt true true =Fields!RequestStatusName.Value 1pt 2pt 2pt 2pt 2pt true true =Fields!TotalGross.Value textbox26 1pt 2pt 2pt 2pt 2pt true true =Fields!TotalNet.Value 1pt 2pt 2pt 2pt 2pt 0.09843in true true textbox20 1pt 2pt 2pt 2pt 2pt true true textbox28 1pt 2pt 2pt 2pt 2pt true true textbox32 1pt 2pt 2pt 2pt 2pt true true Textbox43 1pt 2pt 2pt 2pt 2pt true true textbox17 1pt 2pt 2pt 2pt 2pt true true textbox9 1pt 2pt 2pt 2pt 2pt true true Textbox38 1pt 2pt 2pt 2pt 2pt true true textbox27 1pt 2pt 2pt 2pt 2pt true true 1pt 2pt 2pt 2pt 2pt After true true After true true =Fields!SupplierNamePayee.Value =Fields!CurrencyFormat.Value =Fields!SupplierNamePayee.Value After true Detail =Fields!PurchaseItemStartDate.Value Detail_Collection Output Before true true PurchaseItemDetail 1.25cm 1.90002cm 27cm 0.75cm 27cm 1 8.84784in 0.88583in 0.88583in 0.15748in true true ="TOTAL PURCHASES: " + DateValue(Parameters!StartDate.Value).ToString("d") + " to " + DateValue(Parameters!EndDate.Value).ToString("d") 1pt 2pt 2pt 2pt 2pt true true GROSS 1pt 2pt 2pt 2pt 2pt true true NET textbox10 1pt 2pt 2pt 2pt 2pt 0.09843in true true Textbox207 1pt 2pt 2pt 2pt 2pt true true Textbox208 1pt 2pt 2pt 2pt 2pt true true Textbox209 1pt 2pt 2pt 2pt 2pt 0.23622in true true =Fields!CurrencyCode.Value 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!TotalGross.Value) TotalGross 1pt 2pt 2pt 2pt 2pt true true =Sum(Fields!TotalNet.Value) TotalNet 1pt 2pt 2pt 2pt 2pt 0.04872in true true Black 1pt 2pt 2pt 2pt 2pt true true Textbox211 Black 1pt 2pt 2pt 2pt 2pt true true Textbox212 Black 1pt 2pt 2pt 2pt 2pt After true true After true true =Fields!CurrencyFormat.Value =Fields!CurrencyCode.Value Before true PurchaseItemDetail 4.1175cm 0.02646cm 1.37376cm 26.97353cm 2 0.3175cm 0.5cm 27cm