9pt170.8596pt54.37512pt541.5ptSalesOrderDetail32pt82.5pt144pt93pt63pt58.5pt68.5pt18.99998pt0in0in18.99998pt32.00003pttrueS.No110in0in18.99998pt82.5pttrueProduct No110in0in18.99998pt144pttrueProduct110in0in18.99998pt93pttrueTracking No.110in0in18.99998pt63pttrueQty110in0in18.99998pt58.5pttrueUnit Price110in0in18.99998pt68.49998pttrueTotal1118pt0in0in18pt32.00003pttrue=RowNumber("SalesOrderDetail")110in0in18pt82.5pttrue=Fields!ProductNumber.Value110in0in18pt144pttrue=Fields!Name.Value110in0in18pt93pttrue=Fields!CarrierTrackingNumber.Value110in0in18pt63pttrue=Fields!OrderQty.Value110in0in18pt58.5pttrue=Fields!UnitPrice.Value110in0in18pt68.49998pttrue=Fields!OrderQty.Value*Round(Fields!UnitPrice.Value,2)1118pt0in0in18pt473.0002pttrueTotal Price610in0in18pt68.49998pttrue=Sum(Fields!OrderQty.Value*Round(Fields!UnitPrice.Value,2))11AftertrueBefore8.1pt46.45872pt0pt542.7727pt19pt248.8601pt29.49984pt541.5pt2truetrueI/We hereby certify that the information on this invoice is true and correct and that the contents of this shipment are as stated above.362.4149pt319.6577pt17.58744pt186.9674pt3truetrue Signature of Authorized Person7.73136pt5.50008pt13.45968pt93.68568pt4truetrueOrder ID109.967pt5.50008pt13.8204pt93.68568pt5truetrueBilling Date212.2308pt5.50008pt13.8204pt103.4993pt6truetrueOrder Date109.967pt21.74544pt12.6pt93.68568pt7truetrue=Format(today(), "dd-MM-yyyy")212.2308pt21.74544pt12.6pt103.5pt8truetrue=Format(First(Fields!OrderDate.Value, "SalesOrder"), "dd-MM-yyyy")7.73136pt21.74544pt12.74976pt93.68568pt9truetrue="#" & Parameters!SalesOrderNumber.Value325.1347pt5.50008pt13.8204pt104.04pt10truetruePurchase Order438.2554pt5.50008pt13.8204pt112.0291pt11truetrueShippment Method325.1347pt21.74544pt12.6pt104.04pt12truetrue=First(Fields!PurchaseOrderNumber.Value, "SalesOrder")438.2554pt21.74544pt12.6pt112.0298pt13truetrue=First(Fields!ShipMethod.Value, "SalesOrder")421.0704pt58.94496pt14.31pt129.2148pt14truetrueContact421.0704pt76.7052pt30.6pt129.2148pt15truetrue=First(Fields!CustFirstName.Value, "SalesOrder") & " " & First(Fields!CustLastName.Value, "SalesOrder")="Ph: " & First(Fields!CustPhone.Value, "SalesOrder")215.9766pt58.18359pt14.31pt192.7246pt16truetrueShipping Address215.9766pt75.94922pt78.83496pt192.7246pt17truetrue=First(Fields!CustFirstName.Value, "SalesOrder") & " " & First(Fields!CustLastName.Value, "SalesOrder")=First(Fields!Store.Value, "SalesOrder")=First(Fields!ShipAddress1.Value, "SalesOrder")=First(Fields!ShipCity.Value, "SalesOrder") & ", " & First(Fields!ShipStateProvince.Value, "SalesOrder")=First(Fields!ShipPostalCode.Value, "SalesOrder")=First(Fields!ShipCountryRegion.Value, "SalesOrder")9.97266pt58.18359pt15.3108pt186.8191pt18truetrueBilling Address9.97266pt75.94922pt78.83496pt186.0689pt19truetrue=First(Fields!CustFirstName.Value, "SalesOrder") & " " & First(Fields!CustLastName.Value, "SalesOrder")=First(Fields!Store.Value, "SalesOrder")=First(Fields!BillAddress1.Value, "SalesOrder")=First(Fields!BillCity.Value, "SalesOrder") & ", " & First(Fields!BillStateProvince.Value, "SalesOrder")=First(Fields!BillPostalCode.Value, "SalesOrder")=First(Fields!BillCountryRegion.Value, "SalesOrder")167.2502pt58.9428pt101.25pt0pt378.1649pt58.9428pt102.0002pt0pt339.75pt559.5pt841.68pt595.44pt45pttruetrue0pt0pt37.44pt559.5pt0pt4.58568pt27.54pt137.2658pt1true Sales Order3.6pttrue7.49952pttruetrue18pt18pt18pt18ptDetail of an individual Adventure Works order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.0SQLData Source=dataplatformdemodata.syncfusion.com;Initial Catalog=AdventureWorks;truefalseSalesOrderNumberSystem.StringStoreSystem.StringOrderDateSystem.DateTimeSalesFirstNameSystem.StringSalesLastNameSystem.StringSalesTitleSystem.StringPurchaseOrderNumberSystem.StringShipMethodSystem.StringBillAddress1System.StringBillAddress2System.StringBillCitySystem.StringBillPostalCodeSystem.StringBillStateProvinceSystem.StringBillCountryRegionSystem.StringShipAddress1System.StringShipAddress2System.StringShipCitySystem.StringShipPostalCodeSystem.StringShipStateProvinceSystem.StringShipCountryRegionSystem.StringCustPhoneSystem.StringCustFirstNameSystem.StringCustLastNameSystem.StringAdventureWorksTextSELECT SOH.SalesOrderNumber, S.Name AS Store, SOH.OrderDate, C.FirstName AS SalesFirstName, C.LastName AS SalesLastName, E.Title AS SalesTitle,
SOH.PurchaseOrderNumber, SM.Name AS ShipMethod, BA.AddressLine1 AS BillAddress1, BA.AddressLine2 AS BillAddress2, BA.City AS BillCity,
BA.PostalCode AS BillPostalCode, BSP.Name AS BillStateProvince, BCR.Name AS BillCountryRegion,
SA.AddressLine1 AS ShipAddress1, SA.AddressLine2 AS ShipAddress2, SA.City AS ShipCity, SA.PostalCode AS ShipPostalCode,
SSP.Name AS ShipStateProvince, SCR.Name AS ShipCountryRegion, CC.Phone AS CustPhone,
CC.FirstName AS CustFirstName, CC.LastName AS CustLastName
FROM Person.Address SA INNER JOIN
Person.StateProvince SSP ON SA.StateProvinceID = SSP.StateProvinceID INNER JOIN
Person.CountryRegion SCR ON SSP.CountryRegionCode = SCR.CountryRegionCode RIGHT OUTER JOIN
Sales.SalesOrderHeader SOH LEFT OUTER JOIN
Person.Contact CC ON SOH.ContactID = CC.ContactID LEFT OUTER JOIN
Person.Address BA INNER JOIN
Person.StateProvince BSP ON BA.StateProvinceID = BSP.StateProvinceID INNER JOIN
Person.CountryRegion BCR ON BSP.CountryRegionCode = BCR.CountryRegionCode ON SOH.BillToAddressID = BA.AddressID ON
SA.AddressID = SOH.ShipToAddressID LEFT OUTER JOIN
Person.Contact C RIGHT OUTER JOIN
HumanResources.Employee E ON C.ContactID = E.ContactID ON SOH.SalesPersonID = E.EmployeeID LEFT OUTER JOIN
Purchasing.ShipMethod SM ON SOH.ShipMethodID = SM.ShipMethodID LEFT OUTER JOIN
Sales.Store S ON SOH.CustomerID = S.CustomerID
WHERE (SOH.SalesOrderNumber = @SalesOrderNumber)=Parameters!SalesOrderNumber.Value30SalesOrderDetailIDSystem.Int32OrderQtySystem.Int16UnitPriceSystem.DecimalUnitPriceDiscountSystem.DecimalLineTotalSystem.DecimalCarrierTrackingNumberSystem.StringSalesOrderIDSystem.Int32NameSystem.StringProductNumberSystem.StringAdventureWorksTextSELECT SOD.SalesOrderDetailID, SOD.OrderQty, SOD.UnitPrice,
CASE WHEN SOD.UnitPriceDiscount IS NULL THEN 0 ELSE SOD.UnitPriceDiscount END AS UnitPriceDiscount,
SOD.LineTotal, SOD.CarrierTrackingNumber, SOD.SalesOrderID, P.Name, P.ProductNumber
FROM Sales.SalesOrderDetail SOD INNER JOIN
Production.Product P ON SOD.ProductID = P.ProductID INNER JOIN
Sales.SalesOrderHeader SOH ON SOD.SalesOrderID = SOH.SalesOrderID
WHERE (SOH.SalesOrderNumber = @SalesOrderNumber)
ORDER BY SOD.SalesOrderDetailID=Parameters!SalesOrderNumber.Value30StringSO50750Sales Order No:SO50750SO50751SO50752SO50753SO50754SO50755SO50756SO50757SO50758SO50759SO50760trueInchPx