OBJECT Report 99903 _Test Order Confirmation { OBJECT-PROPERTIES { Date=06.12.15; Time=09:22:46; Modified=Yes; Version List=_DMS8.00; } PROPERTIES { PreviewMode=PrintLayout; } DATASET { { 119451000;;DataItem; ; DataItemTable=Table36; DataItemTableView=SORTING(Document Type,No.) WHERE(Document Type=CONST(Order)); OnAfterGetRecord=BEGIN FormatAddr.SalesHeaderBillTo(CustAddr,"Sales Header"); END; ReqFilterFields=No. } { 119451001;1;Column;No_SalesHeader ; SourceExpr="Sales Header"."No." } { 119451009;1;Column;CustomerAddress1 ; SourceExpr=CustAddr[1] } { 119451008;1;Column;CustomerAddress2 ; SourceExpr=CustAddr[2] } { 119451007;1;Column;CustomerAddress3 ; SourceExpr=CustAddr[3] } { 119451006;1;Column;CustomerAddress4 ; SourceExpr=CustAddr[4] } { 119451005;1;Column;CustomerAddress5 ; SourceExpr=CustAddr[5] } { 119451004;1;Column;CustomerAddress6 ; SourceExpr=CustAddr[6] } { 119451003;1;Column;CustomerAddress7 ; SourceExpr=CustAddr[7] } { 119451002;1;Column;CustomerAddress8 ; SourceExpr=CustAddr[8] } { 119451010;1;DataItem; ; DataItemTable=Table37; DataItemTableView=SORTING(Document Type,Document No.,Line No.); DataItemLink=Document Type=FIELD(Document Type), Document No.=FIELD(No.) } { 119451011;2;Column;Type_SalesLine ; SourceExpr="Sales Line".Type } { 119451012;2;Column;No_SalesLine ; SourceExpr="Sales Line"."No." } { 119451013;2;Column;Description_SalesLine; SourceExpr="Sales Line".Description } { 119451014;2;Column;Quantity_SalesLine ; SourceExpr="Sales Line".Quantity } { 119451015;2;Column;UnitofMeasure_SalesLine; SourceExpr="Sales Line"."Unit of Measure" } { 119451016;2;Column;UnitPrice_SalesLine ; SourceExpr="Sales Line"."Unit Price" } { 119451019;2;Column;LineDiscount_SalesLine; SourceExpr="Sales Line"."Line Discount %" } { 119451017;2;Column;LineAmount_SalesLine; SourceExpr="Sales Line"."Line Amount" } } REQUESTPAGE { PROPERTIES { } CONTROLS { } } LABELS { } CODE { VAR FormatAddr@119451001 : Codeunit 365; CustAddr@119451000 : ARRAY [8] OF Text[50]; BEGIN END. } RDLDATA { 0 SQL 8af33f73-7acb-4c1e-9334-e2b263acc3d6 DataSource No_SalesHeader CustomerAddress1 CustomerAddress2 CustomerAddress3 CustomerAddress4 CustomerAddress5 CustomerAddress6 CustomerAddress7 CustomerAddress8 Type_SalesLine No_SalesLine Description_SalesLine Quantity_SalesLine Quantity_SalesLineFormat UnitofMeasure_SalesLine UnitPrice_SalesLine UnitPrice_SalesLineFormat LineDiscount_SalesLine LineDiscount_SalesLineFormat LineAmount_SalesLine LineAmount_SalesLineFormat DataSet Report.xsd Result 7.43094in 0.03125in true true =Code.SetFields(Fields) Yellow 2pt 2pt 2pt 2pt 0.85187in 1.50928cm 1.98553cm 5.49008cm 2.04727cm 1.41352cm 1.96789cm 1.635cm 2.17956cm 0.32748cm 0.78521cm true true Type 2pt 2pt 2pt 2pt true true No. 2pt 2pt 2pt 2pt true true Description 2pt 2pt 2pt 2pt true true Quantity 2pt 2pt 2pt 2pt true true UOM 2pt 2pt 2pt 2pt true true Unit Price 2pt 2pt 2pt 2pt true true Disc.% 2pt 2pt 2pt 2pt true true Line Amt. 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 0.6cm true true =Fields!Type_SalesLine.Value 2pt 5pt 2pt 2pt true true =Fields!No_SalesLine.Value 2pt 5pt 2pt 2pt true true =Fields!Description_SalesLine.Value 2pt 5pt 2pt 2pt true true =Fields!Quantity_SalesLine.Value 2pt 5pt 2pt 2pt true true =Fields!UnitofMeasure_SalesLine.Value 2pt 5pt 2pt 2pt true true =Fields!UnitPrice_SalesLine.Value 2pt 5pt 2pt 2pt true true =Fields!LineDiscount_SalesLine.Value 2pt 5pt 2pt 2pt true true =Fields!LineAmount_SalesLine.Value 2pt 5pt 2pt 2pt true true =RunningValue(Fields!LineAmount_SalesLine.Value,Sum,"No_SalesHeader") Yellow 2pt 5pt 2pt 2pt 0.6cm true true 2pt 5pt 2pt 2pt 6 true true Sum 2pt 5pt 2pt 2pt true true =Sum(Fields!LineAmount_SalesLine.Value) 2pt 5pt 2pt 2pt true true 2pt 5pt 2pt 2pt true After true Before DataSet_Result 0.1cm 0.18521cm 1.98521cm 18.5556cm true =Fields!No_SalesHeader.Value Between true =Fields!No_SalesHeader.Value true DataSet_Result 0.0325in 0.02in 0.88312in 7.43094in 2.42351cm 2pt 2pt 2pt 2pt true true =Code.custAddr(2) 2pt 2pt 2pt 2pt true true =Code.custAddr(3) 2pt 2pt 2pt 2pt true true =Code.custAddr(4) 2pt 2pt 2pt 2pt true true =Code.custAddr(5) 2pt 2pt 2pt 2pt true true =Code.custAddr(6) 2pt 2pt 2pt 2pt true true =Code.custAddr(7) 2pt 2pt 2pt 2pt true true =Code.custAddr(8) 2pt 2pt 2pt 2pt true true Order No. 2pt 2pt 2pt 2pt true true =Code.docNo 2pt 2pt 2pt 2pt true true Page 2pt 2pt 2pt 2pt true true =Globals!PageNumber 3.66599cm 13.83453cm 0.6cm 1.23cm 11 2pt 2pt 2pt 2pt true true =Code.carryforward 2pt 5pt 2pt 2pt true true Continued... 2pt 5pt 2pt 2pt true 5.00274cm 12.38038cm 1.02361cm 6.28cm 12 =ReportItems!SetFields.Value 1.27974cm true true true true =Code.SetCarryForward(ReportItems!RunningValueLineAmount.Value) 2pt 5pt 2pt 2pt true true Continued... 2pt 5pt 2pt 2pt true 0.07091cm 12.38038cm 1.02361cm 6.3054cm =ReportItems!Sum.Value <> "" 29.7cm 21cm 1cm 1cm 1cm 1cm 1.27cm