320.25pt 9pt 9pt 16.5pt 178.5pt true true Order ID 9pt 27.75pt 16.5pt 178.5pt true true ="#" & Parameters!InvoiceID.Value 9pt 51.75pt 17.25pt 84.75pt true true Order Date 9pt 72.75pt 17.25pt 84.75pt true true =Format(First(Fields!OrderDate.Value, "ShipmentDetails"),"dd-MM-yyyy") 104.25pt 51.75pt 17.25pt 83.25pt true true Shipping Date 104.25pt 72.75pt 17.25pt 83.25pt true true =Format(First(Fields!ShippedDate.Value, "ShipmentDetails"),"dd-MM-yyyy") 197.25pt 4.5pt 96.75pt 0pt 205.5pt 8.25pt 97.5pt 161.25pt 2.25pt 3.75pt 15.75pt 156pt true true Billing Address 3pt 21pt 75pt 155.25pt true true =StrConv(First(Fields!ShipName.Value, "ShipmentDetails"),vbProperCase) =StrConv(First(Fields!ShipAddress.Value, "ShipmentDetails"),vbProperCase) =StrConv(First(Fields!ShipCity.Value, "ShipmentDetails"),vbProperCase) =StrConv(First(Fields!ShipCountry.Value, "ShipmentDetails"),vbProperCase) =StrConv(First(Fields!ShipPostalCode.Value, "ShipmentDetails"),vbProperCase) true 374.25pt 5.25pt 96.75pt 0pt 383.25pt 8.25pt 97.5pt 165pt 2.25pt 3pt 16.5pt 161.25pt true true Shipment Address 2.25pt 21.75pt 74.25pt 161.25pt true true =StrConv(First(Fields!ShipName.Value, "ShipmentDetails"), vbProperCase) =StrConv(First(Fields!ShipAddress.Value, "ShipmentDetails"), vbProperCase) =StrConv(First(Fields!ShipCity.Value, "ShipmentDetails"), vbProperCase) =StrConv(First(Fields!ShipCountry.Value, "ShipmentDetails"), vbProperCase) =StrConv(First(Fields!ShipPostalCode.Value, "ShipmentDetails"), vbProperCase) true 9pt 116.25pt 36pt 539.25pt MaxRowCount 100000 MaxColumnCount 20 ShipmentDetails 90.75pt 85.5pt 81pt 83.25pt 83.25pt 115.5pt 18pt 0in 0in 18pt 90.75pt true true Ship Name 1 1 0in 0in 18pt 85.5pt true true Ship Address 1 1 0in 0in 18pt 81pt true true Freight 1 1 0in 0in 18pt 83.25pt true true Shipping Date 1 1 0in 0in 18pt 83.25pt true true Ship City 1 1 0in 0in 18pt 115.5pt true true Ship Country 1 1 18pt 0in 0in 18pt 90.75pt true true =StrConv(Fields!ShipName.Value,vbProperCase) 1 1 0in 0in 18pt 85.5pt true true =StrConv(Fields!ShipAddress.Value,vbProperCase) 1 1 0in 0in 18pt 81pt true true =Fields!Freight.Value 1 1 0in 0in 18pt 83.25pt true true =Fields!ShippedDate.Value 1 1 0in 0in 18pt 83.25pt true true =Trim(StrConv(Fields!ShipCity.Value,vbProperCase)) 1 1 0in 0in 18pt 115.5pt true true =StrConv(Fields!ShipCountry.Value,vbProperCase) 1 1 After 9.75pt 162pt 54pt 539.25pt MaxRowCount 100000 MaxColumnCount 20 OrderDetails 82.5pt 124.5pt 88.5pt 72pt 72pt 99.75pt 18pt 0in 0in 18pt 82.5pt true true Product ID 1 1 0in 0in 18pt 124.5pt true true Product Name 1 1 0in 0in 18pt 88.5pt true true Quantity 1 1 0in 0in 18pt 72pt true true Unit Price 1 1 0in 0in 18pt 72pt true true Discount 1 1 0in 0in 18pt 99.75pt true true Price 1 1 18pt 0in 0in 18pt 82.5pt true true =Fields!ProductID.Value 1 1 0in 0in 18pt 124.5pt true true =Fields!ProductName.Value 1 1 0in 0in 18pt 88.5pt true true =Fields!Quantity.Value 1 1 0in 0in 18pt 72pt true true =Fields!UnitPrice.Value 1 1 0in 0in 18pt 72pt true true =Fields!Discount.Value 1 1 0in 0in 18pt 99.75pt true true =Fields!Price.Value 1 1 18pt 0in 0in 18pt 439.5pt true true Total 1 5 0in 0in 18pt 99.75pt true true =Sum(CDec(Fields!Price.Value)) 1 1 After Before 9pt 225pt 37.5pt 540pt true true I/We hereby certify that the information on this invoice is true and correct and that the contents of this shipment are as stated above. 372pt 292.5pt 18.75pt 171pt true true Signature of the Authorized Person 558pt 47.25pt true true 3pt 5.25pt 38.25pt 550.5pt 3.75pt 6pt 24pt 150pt true true Invoice true 0.72917in true true 1in 1in 1in 1in None SQL Data Source=dataplatformdemodata.syncfusion.com;Initial Catalog=Northwind; true Northwind SELECT Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry FROM Orders where Orders.OrderID=@InvoiceID =Parameters!InvoiceID.Value OrderDate System.DateTime RequiredDate System.DateTime ShippedDate System.DateTime ShipVia System.Int32 Freight System.Decimal ShipName System.String ShipAddress System.String ShipCity System.String ShipRegion System.String ShipPostalCode System.String ShipCountry System.String Northwind SELECT [Order Details].ProductID, Products.ProductName, [Order Details].Quantity, [Order Details].UnitPrice, [Order Details].Discount FROM [Order Details] INNER JOIN Products ON [Order Details].ProductID = Products.ProductID WHERE ([Order Details].OrderID = @InvoiceID) =Parameters!InvoiceID.Value ProductID System.Int32 ProductName System.String Quantity System.Int16 UnitPrice System.Decimal Discount System.Single =Fields!Discount.Value*Fields!Quantity.Value*Fields!UnitPrice.Value =Round((Fields!Quantity.Value*Fields!UnitPrice.Value)-Fields!DiscountAmount.Value,2) Northwind SELECT DISTINCT OrderID FROM [Order Details] OrderID System.Int32 String Invoice ID 10252 InvoiceDetails OrderID OrderID 4 2 0 0 InvoiceID Inch Px Segoe UI