OBJECT Report 111 Customer - Top 10 List { OBJECT-PROPERTIES { Date=18/05/12; Time=15:42:54; Modified=Yes; Version List=NAVW16.00.01; } PROPERTIES { CaptionML=[ENU=Customer - Top 10 List; FRB=Clients : PalmarŠs; NLB=Klant - Top 10]; OnPreReport=BEGIN CustFilter := Customer.GETFILTERS; CustDateFilter := Customer.GETFILTER("Date Filter"); END; } DATAITEMS { { PROPERTIES { DataItemTable=Table18; DataItemTableView=SORTING(No.); OnPreDataItem=BEGIN Window.OPEN(Text000); i := 0; CustAmount.DELETEALL; CurrReport.CREATETOTALS("Sales (LCY)","Balance (LCY)"); END; OnAfterGetRecord=BEGIN Window.UPDATE(1,"No."); CALCFIELDS("Sales (LCY)","Balance (LCY)"); IF ("Sales (LCY)" = 0) AND ("Balance (LCY)" = 0) THEN CurrReport.SKIP; CustAmount.INIT; CustAmount."Customer No." := "No."; IF ShowType = ShowType::"Sales (LCY)" THEN BEGIN CustAmount."Amount (LCY)" := -"Sales (LCY)"; CustAmount."Amount 2 (LCY)" := -"Balance (LCY)"; END ELSE BEGIN CustAmount."Amount (LCY)" := -"Balance (LCY)"; CustAmount."Amount 2 (LCY)" := -"Sales (LCY)"; END; CustAmount.INSERT; IF (NoOfRecordsToPrint = 0) OR (i < NoOfRecordsToPrint) THEN i := i + 1 ELSE BEGIN CustAmount.FIND('+'); CustAmount.DELETE; END; IF ISSERVICETIER THEN BEGIN TotalSales += "Sales (LCY)"; TotalBalance += "Balance (LCY)"; ChartTypeNo := ChartType; ShowTypeNo := ShowType; END; END; ReqFilterFields=No.,Customer Posting Group,Currency Code,Date Filter; } SECTIONS { } } { PROPERTIES { DataItemTable=Table2000000026; DataItemTableView=SORTING(Number) WHERE(Number=FILTER(1..)); OnPreDataItem=BEGIN CustSalesLCY := Customer."Sales (LCY)"; CustBalanceLCY := Customer."Balance (LCY)"; Window.CLOSE; CurrReport.CREATETOTALS(Customer."Sales (LCY)",Customer."Balance (LCY)"); END; OnAfterGetRecord=BEGIN IF Number = 1 THEN BEGIN IF NOT CustAmount.FIND('-') THEN CurrReport.BREAK; END ELSE IF CustAmount.NEXT = 0 THEN CurrReport.BREAK; CustAmount."Amount (LCY)" := -CustAmount."Amount (LCY)"; Customer.GET(CustAmount."Customer No."); Customer.CALCFIELDS("Sales (LCY)","Balance (LCY)"); IF MaxAmount = 0 THEN MaxAmount := CustAmount."Amount (LCY)"; IF (MaxAmount > 0) AND (CustAmount."Amount (LCY)" > 0) THEN BarText := PADSTR('',ROUND(CustAmount."Amount (LCY)" / MaxAmount * 45,1),'*') ELSE BarText := ''; CustAmount."Amount (LCY)" := -CustAmount."Amount (LCY)"; END; } SECTIONS { { PROPERTIES { SectionType=Header; PrintOnEveryPage=Yes; SectionWidth=18150; SectionHeight=2538; } CONTROLS { { 1 ;Label ;0 ;0 ;7500 ;423 ;FontSize=8; FontBold=Yes; CaptionML=[ENU=Customer - Top 10 List; FRB=Clients : PalmarŠs; NLB=Klant - Top 10]; DataSetFieldName=Customer___Top_10_ListCaption } { 2 ;TextBox ;15000;0 ;3150 ;423 ;HorzAlign=Right; SourceExpr=FORMAT(TODAY,0,4); DataSetFieldName=FORMAT_TODAY_0_4_ } { 3 ;TextBox ;0 ;423 ;7500 ;423 ;SourceExpr=STRSUBSTNO(Text001,CustDateFilter); DataSetFieldName=STRSUBSTNO_Text001_CustDateFilter_ } { 4 ;Label ;16950;423 ;750 ;423 ;ParentControl=5; DataSetFieldName=CurrReport_PAGENOCaption } { 5 ;TextBox ;17700;423 ;450 ;423 ;CaptionML=[ENU=Page; FRB=Page; NLB=Pagina]; SourceExpr=CurrReport.PAGENO; DataSetFieldName=CurrReport_PAGENO } { 6 ;TextBox ;0 ;846 ;7500 ;423 ;SourceExpr=COMPANYNAME; DataSetFieldName=COMPANYNAME } { 7 ;TextBox ;15900;846 ;2250 ;423 ;HorzAlign=Right; SourceExpr=USERID; DataSetFieldName=USERID } { 8 ;TextBox ;0 ;1692 ;7500 ;423 ;SourceExpr=STRSUBSTNO(Text002,SELECTSTR(ShowType+1,Text004)); DataSetFieldName=STRSUBSTNO_Text002_SELECTSTR_ShowType_1_Text004__ } { 32 ;TextBox ;9600 ;0 ;450 ;423 ;Name=ShowTypeNo; Visible=No; ForeColor=65535; SourceExpr=ShowTypeNo; DataSetFieldName=ShowTypeNo } { 33 ;TextBox ;10050;0 ;450 ;423 ;Name=NoOfRecordsToPrint; Visible=No; ForeColor=65535; SourceExpr=NoOfRecordsToPrint; DataSetFieldName=NoOfRecordsToPrint } { 36 ;TextBox ;10500;0 ;450 ;423 ;Name=ChartTypeNo; Visible=No; ForeColor=65535; SourceExpr=ChartTypeNo; DataSetFieldName=ChartTypeNo } } } { PROPERTIES { SectionType=Header; PrintOnEveryPage=Yes; SectionWidth=18150; SectionHeight=846; OnPreSection=BEGIN CurrReport.SHOWOUTPUT((CurrReport.PAGENO = 1) AND (CustFilter <> '')); END; } CONTROLS { { 9 ;TextBox ;0 ;0 ;18150;423 ;SourceExpr=Customer.TABLECAPTION + ': ' + CustFilter; DataSetFieldName=Customer_TABLECAPTION__________CustFilter } { 31 ;TextBox ;18000;0 ;150 ;423 ;Name=CustFilter; Visible=No; ForeColor=65535; SourceExpr=CustFilter; DataSetFieldName=CustFilter } } } { PROPERTIES { SectionType=Header; PrintOnEveryPage=Yes; SectionWidth=18150; SectionHeight=1269; } CONTROLS { { 10 ;Label ;0 ;0 ;1050 ;846 ;ParentControl=16; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Integer_NumberCaption } { 11 ;Label ;1200 ;0 ;1500 ;846 ;ParentControl=17; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Customer__No__Caption } { 12 ;Label ;2850 ;0 ;4500 ;846 ;ParentControl=18; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Customer_NameCaption } { 13 ;Label ;7500 ;0 ;1800 ;846 ;ParentControl=19; HorzAlign=Right; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Customer__Sales__LCY__Caption } { 14 ;Label ;9450 ;0 ;1800 ;846 ;ParentControl=20; HorzAlign=Right; VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; DataSetFieldName=Customer__Balance__LCY__Caption } { 15 ;TextBox ;11400;0 ;6750 ;846 ;VertAlign=Bottom; FontBold=Yes; MultiLine=Yes; SourceExpr=STRSUBSTNO(Text003,SELECTSTR(ShowType+1,Text004)); DataSetFieldName=STRSUBSTNO_Text003_SELECTSTR_ShowType_1_Text004__ } } } { PROPERTIES { SectionType=Body; SectionWidth=18150; SectionHeight=423; } CONTROLS { { 16 ;TextBox ;0 ;0 ;1050 ;423 ;CaptionML=[ENU=Rank; FRB=Rang; NLB=Plaats]; SourceExpr=Number; DataSetFieldName=Integer_Number } { 17 ;TextBox ;1200 ;0 ;1500 ;423 ;SourceExpr=Customer."No."; DataSetFieldName=Customer__No__ } { 18 ;TextBox ;2850 ;0 ;4500 ;423 ;SourceExpr=Customer.Name; DataSetFieldName=Customer_Name } { 19 ;TextBox ;7500 ;0 ;1800 ;423 ;SourceExpr=Customer."Sales (LCY)"; DataSetFieldName=Customer__Sales__LCY__ } { 20 ;TextBox ;9450 ;0 ;1800 ;423 ;SourceExpr=Customer."Balance (LCY)"; DataSetFieldName=Customer__Balance__LCY__ } { 21 ;TextBox ;11400;0 ;6750 ;423 ;SourceExpr=BarText; DataSetFieldName=BarText } } } { PROPERTIES { SectionType=Footer; SectionWidth=18150; SectionHeight=1692; OnPreSection=BEGIN SalesPct := Pct(Customer."Sales (LCY)",CustSalesLCY); BalancePct := Pct(Customer."Balance (LCY)",CustBalanceLCY); END; } CONTROLS { { 22 ;Label ;5100 ;423 ;2250 ;423 ;ParentControl=23; FontBold=Yes; DataSetFieldName=Customer__Sales__LCY___Control23Caption } { 23 ;TextBox ;7500 ;423 ;1800 ;423 ;FontBold=Yes; CaptionML=[ENU=Total; FRB=Total; NLB=Totaal]; SourceExpr=Customer."Sales (LCY)"; DataSetFieldName=Customer__Sales__LCY___Control23 } { 24 ;TextBox ;9450 ;423 ;1800 ;423 ;FontBold=Yes; SourceExpr=Customer."Balance (LCY)"; DataSetFieldName=Customer__Balance__LCY___Control24 } { 25 ;Label ;5100 ;846 ;2250 ;423 ;ParentControl=26; DataSetFieldName=CustSalesLCYCaption } { 26 ;TextBox ;7500 ;846 ;1800 ;423 ;CaptionML=[ENU=Total Sales; FRB=Total des ventes; NLB=Totale verkoop]; SourceExpr=CustSalesLCY; AutoFormatType=1; DataSetFieldName=CustSalesLCY } { 27 ;TextBox ;9450 ;846 ;1800 ;423 ;SourceExpr=CustBalanceLCY; AutoFormatType=1; DataSetFieldName=CustBalanceLCY } { 28 ;Label ;5100 ;1269 ;2250 ;423 ;ParentControl=29; DataSetFieldName=SalesPctCaption } { 29 ;TextBox ;7500 ;1269 ;1800 ;423 ;CaptionML=[ENU=% of Total Sales; FRB=% total ventes; NLB=% van totale verkoop]; DecimalPlaces=1:1; SourceExpr=SalesPct; DataSetFieldName=SalesPct } { 30 ;TextBox ;9450 ;1269 ;1800 ;423 ;DecimalPlaces=1:1; SourceExpr=BalancePct; DataSetFieldName=BalancePct } { 34 ;TextBox ;9150 ;846 ;150 ;423 ;Name=TotalSales; Visible=No; ForeColor=65535; SourceExpr=TotalSales; DataSetFieldName=TotalSales } { 35 ;TextBox ;11100;846 ;150 ;423 ;Name=TotalBalance; Visible=No; ForeColor=65535; SourceExpr=TotalBalance; DataSetFieldName=TotalBalance } } } } } { PROPERTIES { DataItemTable=Table2000000026; DataItemTableView=WHERE(Number=CONST(1)); DataItemVarName=PageFooter; } SECTIONS { { PROPERTIES { SectionType=Footer; PlaceInBottom=Yes; SectionWidth=18150; SectionHeight=846; } CONTROLS { { 1000000000;TextBox;0 ;0 ;18150;846 ;HorzAlign=Center; FontSize=16; FontBold=Yes; SourceExpr='This is the text that needs to go to the bottom of the page...'; DataSetFieldName=This_is_the_text_that_needs_to_go_to_the_bottom_of_the_page____ } } } } } } REQUESTFORM { PROPERTIES { Width=7700; Height=2310; SaveValues=Yes; OnOpenForm=BEGIN IF NoOfRecordsToPrint = 0 THEN NoOfRecordsToPrint := 10; IF NOT ISSERVICETIER THEN RequestOptionsForm.ChartType.VISIBLE := FALSE; END; } CONTROLS { { 1 ;OptionButton ;3410 ;0 ;3850 ;440 ;CaptionML=[ENU=Sales (LCY); FRB=Ventes DS; NLB=Verkoop (LV)]; SourceExpr=ShowType; OptionValue=Sales (LCY) } { 21 ;Label ;0 ;0 ;3300 ;440 ;ParentControl=1; CaptionML=[ENU=Show; FRB=Afficher; NLB=Weergeven] } { 2 ;OptionButton ;3410 ;550 ;3850 ;440 ;CaptionML=[ENU=Balance (LCY); FRB=Solde DS; NLB=Saldo (LV)]; SourceExpr=ShowType; OptionValue=Balance (LCY) } { 3 ;TextBox ;3410 ;1210 ;1650 ;440 ;CaptionML=[ENU=Quantity; FRB=Quantit‚; NLB=Aantal]; SourceExpr=NoOfRecordsToPrint } { 23 ;Label ;0 ;1210 ;3300 ;440 ;ParentControl=3 } { 4 ;TextBox ;3410 ;1870 ;3850 ;440 ;Name=ChartType; CaptionML=[ENU=Chart Type; FRB=Type de graphique; NLB=Diagramtype]; OptionCaptionML=[ENU=Bar chart,Pie chart; FRB=Graphique … barres,Graphique en secteurs; NLB=Staafdiagram,Cirkeldiagram]; SourceExpr=ChartType } { 5 ;Label ;0 ;1870 ;3300 ;440 ;ParentControl=4 } } } REQUESTPAGE { PROPERTIES { SaveValues=Yes; OnInit=BEGIN ChartTypeVisible := TRUE; END; OnOpenPage=BEGIN IF NoOfRecordsToPrint = 0 THEN NoOfRecordsToPrint := 10; IF NOT ISSERVICETIER THEN ChartTypeVisible := FALSE; END; } CONTROLS { { 1900000001;0;Container; ContainerType=ContentArea } { 1900000002;1;Group ; CaptionML=[ENU=Options; FRB=Options; NLB=Opties] } { 1 ;2 ;Field ; CaptionML=[ENU=Show; FRB=Afficher; NLB=Weergeven]; OptionCaptionML=[ENU=Sales (LCY),Balance (LCY); FRB=Ventes DS,Solde DS; NLB=Verkoop (LV),Saldo (LV)]; SourceExpr=ShowType } { 3 ;2 ;Field ; CaptionML=[ENU=Quantity; FRB=Quantit‚; NLB=Aantal]; SourceExpr=NoOfRecordsToPrint } { 4 ;2 ;Field ; Name=ChartType; CaptionML=[ENU=Chart Type; FRB=Type de graphique; NLB=Diagramtype]; OptionCaptionML=[ENU=Bar chart,Pie chart; FRB=Graphique … barres,Graphique en secteurs; NLB=Staafdiagram,Cirkeldiagram]; SourceExpr=ChartType; Visible=ChartTypeVisible } } } CODE { VAR Text000@1000 : TextConst 'ENU=Sorting customers #1##########;FRB=Tri des clients #1##########;NLB=Sorteren klanten #1##########'; Text001@1001 : TextConst 'ENU=Period: %1;FRB=P‚riode : %1;NLB=Periode: %1'; Text002@1002 : TextConst 'ENU=Ranked according to %1;FRB=Classement par %1;NLB=Gerangschikt volgens %1'; Text003@1003 : TextConst 'ENU=Portion of %1;FRB=Portion de %1;NLB=Aandeel in %1'; Window@1004 : Dialog; CustAmount@1005 : TEMPORARY Record 266; CustFilter@1006 : Text[250]; CustDateFilter@1007 : Text[30]; ShowType@1008 : 'Sales (LCY),Balance (LCY)'; NoOfRecordsToPrint@1009 : Integer; CustSalesLCY@1010 : Decimal; CustBalanceLCY@1011 : Decimal; SalesPct@1012 : Decimal; BalancePct@1013 : Decimal; MaxAmount@1014 : Decimal; BarText@1015 : Text[50]; i@1019 : Integer; TotalSales@1016 : Decimal; Text004@1017 : TextConst 'ENU=Sales (LCY),Balance (LCY);FRB=Ventes DS, Solde DS;NLB=Verkoop (LV),Saldo (LV)'; TotalBalance@1018 : Decimal; ChartType@1020 : 'Bar chart,Pie chart'; ChartTypeNo@1021 : Integer; ShowTypeNo@1022 : Integer; ChartTypeVisible@19004067 : Boolean INDATASET; LOCAL PROCEDURE Pct@1(Numeral1@1000 : Decimal;Numeral2@1001 : Decimal) : Decimal; BEGIN IF Numeral2 = 0 THEN EXIT(0); EXIT(ROUND(Numeral1 / Numeral2 * 100,0.1)); END; BEGIN END. } RDLDATA { 23.80952cm 1.26984cm true =Last(Fields!This_is_the_text_that_needs_to_go_to_the_bottom_of_the_page____.Value) This_is_the_text_that_needs_to_go_to_the_bottom_of_the_page____ 4.44444cm 15.87302cm 4 Outside 0 Outside true <Style /> true =Fields!Customer__No__.Value DataSet_Result Table BottomCenter true Default 0 Plain 30 30 Simple 50 <Style /> 14.92063cm Pie true Outside true 0 true <Visible>true</Visible> </Axis> </ValueAxis> <Visibility> <Hidden>=IIF(Fields!ChartTypeNo.Value = 1,FALSE,TRUE)</Hidden> </Visibility> <Width>12.38095cm</Width> <ZIndex>3</ZIndex> </Chart> <Chart Name="BarChart"> <CategoryAxis> <Axis> <MajorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MajorGridLines> <MajorTickMarks>Outside</MajorTickMarks> <Min>0</Min> <MinorGridLines> <Style> <BorderStyle> <Default>Solid</Default> </BorderStyle> </Style> </MinorGridLines> <MinorTickMarks>Outside</MinorTickMarks> <Reverse>true</Reverse> <Title> <Style /> true =Fields!Customer__No__.Value DataSet_Result 8.88889cm BottomCenter true Default 0 Plain 35 15 Real 4 <Style /> 6.03176cm Bar true Outside true 0 true <Visible>true</Visible> </Axis> </ValueAxis> <Visibility> <Hidden>=IIF(Fields!ChartTypeNo.Value = 0,FALSE,TRUE)</Hidden> </Visibility> <Width>12.38095cm</Width> <ZIndex>2</ZIndex> </Chart> <Textbox Name="Customer_TABLECAPTION__________CustFilter"> <Height>0.423cm</Height> <Style> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=First(Fields!Customer_TABLECAPTION__________CustFilter.Value)</Value> <Visibility> <Hidden>=IIF(First(Fields!CustFilter.Value) = "",TRUE,FALSE)</Hidden> </Visibility> <Width>14.28571cm</Width> <ZIndex>1</ZIndex> </Textbox> <Table Name="Table1"> <DataSetName>DataSet_Result</DataSetName> <Details> <TableRows> <TableRow> <Height>0.423cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox71"> <CanGrow>true</CanGrow> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=RowNumber(Nothing)</Value> <rd:DefaultName>textbox71</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__No__"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!Customer__No__.Value</Value> <ZIndex>12</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ColSpan>2</ColSpan> <ReportItems> <Textbox Name="Customer_Name"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!Customer_Name.Value</Value> <ZIndex>11</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__Sales__LCY__"> <CanGrow>true</CanGrow> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <FontSize>9pt</FontSize> <Format>=Fields!Customer__Sales__LCY__Format.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!Customer__Sales__LCY__.Value</Value> <ZIndex>10</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__Balance__LCY__"> <CanGrow>true</CanGrow> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <FontSize>9pt</FontSize> <Format>=Fields!Customer__Balance__LCY__Format.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!Customer__Balance__LCY__.Value</Value> <ZIndex>9</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TotalBalance"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <TextAlign>Right</TextAlign> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!TotalBalance.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> <ZIndex>8</ZIndex> <rd:DefaultName>TotalBalance</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TotalSales"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <TextAlign>Right</TextAlign> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!TotalSales.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> <ZIndex>7</ZIndex> <rd:DefaultName>TotalSales</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="STRSUBSTNO_Text001_CustDateFilter_"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!STRSUBSTNO_Text001_CustDateFilter_.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> <ZIndex>6</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="COMPANYNAME"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!COMPANYNAME.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> <ZIndex>5</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="STRSUBSTNO_Text002_SELECTSTR_ShowType_1_Text004__"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!STRSUBSTNO_Text002_SELECTSTR_ShowType_1_Text004__.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> <ZIndex>4</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="NoOfRecordsToPrint"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!NoOfRecordsToPrint.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> <ZIndex>3</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox12"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>2</ZIndex> <rd:DefaultName>textbox12</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer___Top_10_ListCaption"> <CanGrow>true</CanGrow> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value>=Fields!Customer___Top_10_ListCaption.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> <ZIndex>1</ZIndex> <rd:DefaultName>Customer___Top_10_ListCaption</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="CurrReport_PAGENOCaption"> <Style> <BackgroundColor>=iif(RowNumber(Nothing) mod 2, "AliceBlue", "White")</BackgroundColor> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Fields!CurrReport_PAGENOCaption.Value</Value> <Visibility> <Hidden>true</Hidden> </Visibility> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Details> <Footer> <TableRows> <TableRow> <Height>0.423cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox72"> <CanGrow>true</CanGrow> <Style> <FontWeight>700</FontWeight> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox72</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox20"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>26</ZIndex> <rd:DefaultName>textbox20</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox1"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>25</ZIndex> <rd:DefaultName>textbox1</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox13"> <CanGrow>true</CanGrow> <Style> <FontSize>7pt</FontSize> <FontWeight>700</FontWeight> <Format>F2</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>24</ZIndex> <rd:DefaultName>textbox13</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox22"> <CanGrow>true</CanGrow> <Style> <FontSize>7pt</FontSize> <FontWeight>700</FontWeight> <Format>F2</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>23</ZIndex> <rd:DefaultName>textbox22</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox23"> <CanGrow>true</CanGrow> <Style> <FontSize>7pt</FontSize> <FontWeight>700</FontWeight> <Format>F2</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>22</ZIndex> <rd:DefaultName>textbox23</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox25"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>21</ZIndex> <rd:DefaultName>textbox25</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox26"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>20</ZIndex> <rd:DefaultName>textbox26</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox27"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>19</ZIndex> <rd:DefaultName>textbox27</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox28"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>18</ZIndex> <rd:DefaultName>textbox28</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox29"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>17</ZIndex> <rd:DefaultName>textbox29</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox30"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>16</ZIndex> <rd:DefaultName>textbox30</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox31"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>15</ZIndex> <rd:DefaultName>textbox31</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox32"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>14</ZIndex> <rd:DefaultName>textbox32</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox33"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>13</ZIndex> <rd:DefaultName>textbox33</rd:DefaultName> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.423cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox73"> <CanGrow>true</CanGrow> <Style> <FontWeight>700</FontWeight> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox73</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TextBox11"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>40</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox21"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>39</ZIndex> <rd:DefaultName>textbox21</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__Sales__LCY___Control23Caption"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=First(Fields!Customer__Sales__LCY___Control23Caption.Value)</Value> <ZIndex>38</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__Sales__LCY___Control23"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <Format>=Fields!Customer__Sales__LCY__Format.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Sum(Fields!Customer__Sales__LCY__.Value)</Value> <ZIndex>37</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__Balance__LCY___Control24"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <Format>=Fields!Customer__Balance__LCY__Format.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Sum(Fields!Customer__Balance__LCY__.Value)</Value> <ZIndex>36</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox8"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>35</ZIndex> <rd:DefaultName>textbox8</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox4"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>34</ZIndex> <rd:DefaultName>textbox4</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TextBox110"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>33</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox40"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>32</ZIndex> <rd:DefaultName>textbox40</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox41"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>31</ZIndex> <rd:DefaultName>textbox41</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox42"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>30</ZIndex> <rd:DefaultName>textbox42</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox43"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>29</ZIndex> <rd:DefaultName>textbox43</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox44"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>28</ZIndex> <rd:DefaultName>textbox44</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox45"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>27</ZIndex> <rd:DefaultName>textbox45</rd:DefaultName> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.423cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox74"> <CanGrow>true</CanGrow> <Style> <FontWeight>700</FontWeight> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox74</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TextBox14"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>54</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox15"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>53</ZIndex> <rd:DefaultName>textbox15</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="CustSalesLCYCaption"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=First(Fields!CustSalesLCYCaption.Value)</Value> <ZIndex>52</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="CustSalesLCY"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <Format>=Fields!TotalSalesFormat.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=First(Fields!TotalSales.Value)</Value> <ZIndex>51</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="CustBalanceLCY"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <Format>=Fields!TotalBalanceFormat.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=First(Fields!TotalBalance.Value)</Value> <ZIndex>50</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox9"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>49</ZIndex> <rd:DefaultName>textbox9</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox5"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>48</ZIndex> <rd:DefaultName>textbox5</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TextBox111"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>47</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox46"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>46</ZIndex> <rd:DefaultName>textbox46</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox47"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>45</ZIndex> <rd:DefaultName>textbox47</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox48"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>44</ZIndex> <rd:DefaultName>textbox48</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox49"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>43</ZIndex> <rd:DefaultName>textbox49</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox50"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>42</ZIndex> <rd:DefaultName>textbox50</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox51"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>41</ZIndex> <rd:DefaultName>textbox51</rd:DefaultName> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.423cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox75"> <CanGrow>true</CanGrow> <Style> <FontWeight>700</FontWeight> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox75</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TextBox17"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>68</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox16"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>67</ZIndex> <rd:DefaultName>textbox16</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="SalesPctCaption"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=First(Fields!SalesPctCaption.Value)</Value> <ZIndex>66</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="SalesPct"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <Format>=Fields!Customer__Sales__LCY__Format.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Code.CalcPct(Sum(Fields!Customer__Sales__LCY__.Value), First(Fields!TotalSales.Value))</Value> <ZIndex>65</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="BalancePct"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <Format>=Fields!Customer__Balance__LCY__Format.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Code.CalcPct(Sum(Fields!Customer__Balance__LCY__.Value), First(Fields!TotalBalance.Value))</Value> <ZIndex>64</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox10"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>63</ZIndex> <rd:DefaultName>textbox10</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox6"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>62</ZIndex> <rd:DefaultName>textbox6</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TextBox112"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>61</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox52"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>60</ZIndex> <rd:DefaultName>textbox52</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox53"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>59</ZIndex> <rd:DefaultName>textbox53</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox54"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>58</ZIndex> <rd:DefaultName>textbox54</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox55"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>57</ZIndex> <rd:DefaultName>textbox55</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox56"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>56</ZIndex> <rd:DefaultName>textbox56</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox57"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>55</ZIndex> <rd:DefaultName>textbox57</rd:DefaultName> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.423cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox77"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <rd:DefaultName>textbox77</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ColSpan>4</ColSpan> <ReportItems> <Textbox Name="textbox24"> <CanGrow>true</CanGrow> <Style> <Color>Red</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Code.GenerateVbCrLf(42 - cint(CountRows("Table1")))</Value> <rd:DefaultName>textbox24</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox60"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <Format>=Fields!Customer__Balance__LCY__Format.Value</Format> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox60</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox61"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox61</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox62"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox62</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox63"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox63</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox64"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox64</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox65"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox65</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox66"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox66</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox67"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox67</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox68"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox68</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox69"> <CanGrow>true</CanGrow> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox69</rd:DefaultName> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Footer> <Header> <RepeatOnNewPage>true</RepeatOnNewPage> <TableRows> <TableRow> <Height>0.72cm</Height> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox70"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Bottom</VerticalAlign> </Style> <Value /> <rd:DefaultName>textbox70</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__No__Caption"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Bottom</VerticalAlign> </Style> <UserSort> <SortExpression>=Fields!Customer__No__.Value</SortExpression> </UserSort> <Value>=First(Fields!Customer__No__Caption.Value)</Value> <ZIndex>82</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer_NameCaption"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Bottom</VerticalAlign> </Style> <UserSort> <SortExpression>=Fields!Customer_Name.Value</SortExpression> </UserSort> <Value>=First(Fields!Customer_NameCaption.Value)</Value> <ZIndex>81</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox2"> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <TextAlign>Right</TextAlign> <VerticalAlign>Bottom</VerticalAlign> </Style> <Value /> <ZIndex>80</ZIndex> <rd:DefaultName>textbox2</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__Sales__LCY__Caption"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <TextAlign>Right</TextAlign> <VerticalAlign>Bottom</VerticalAlign> </Style> <UserSort> <SortExpression>=Fields!Customer__Sales__LCY__.Value</SortExpression> </UserSort> <Value>=First(Fields!Customer__Sales__LCY__Caption.Value)</Value> <ZIndex>79</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="Customer__Balance__LCY__Caption"> <CanGrow>true</CanGrow> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>0.075cm</PaddingLeft> <PaddingRight>0.075cm</PaddingRight> <PaddingTop>2pt</PaddingTop> <TextAlign>Right</TextAlign> <VerticalAlign>Bottom</VerticalAlign> </Style> <UserSort> <SortExpression>=Fields!Customer__Balance__LCY__.Value</SortExpression> </UserSort> <Value>=First(Fields!Customer__Balance__LCY__Caption.Value)</Value> <ZIndex>78</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox7"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>77</ZIndex> <rd:DefaultName>textbox7</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox3"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>76</ZIndex> <rd:DefaultName>textbox3</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="TextBox19"> <Style> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>75</ZIndex> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox34"> <Style> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>74</ZIndex> <rd:DefaultName>textbox34</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox35"> <Style> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>73</ZIndex> <rd:DefaultName>textbox35</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox36"> <Style> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>72</ZIndex> <rd:DefaultName>textbox36</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox18"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>71</ZIndex> <rd:DefaultName>textbox18</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox58"> <Style> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Value /> <ZIndex>70</ZIndex> <rd:DefaultName>textbox58</rd:DefaultName> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox39"> <Style> <PaddingBottom>8pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <VerticalAlign>Middle</VerticalAlign> </Style> <Value /> <ZIndex>69</ZIndex> <rd:DefaultName>textbox39</rd:DefaultName> </Textbox> </ReportItems> </TableCell> </TableCells> </TableRow> </TableRows> </Header> <Height>3.258cm</Height> <TableColumns> <TableColumn> <Width>0.63492cm</Width> </TableColumn> <TableColumn> <Width>2.22222cm</Width> </TableColumn> <TableColumn> <Width>4.44444cm</Width> </TableColumn> <TableColumn> <Width>2.85714cm</Width> </TableColumn> <TableColumn> <Width>2.85714cm</Width> </TableColumn> <TableColumn> <Width>2.85714cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> <TableColumn> <Width>0.07937cm</Width> </TableColumn> </TableColumns> <Top>0.95238cm</Top> </Table> </ReportItems> </Body> <BottomMargin>2cm</BottomMargin> <Code>Public Function GenerateVbCrLf(ByVal Count as integer) dim Value as String dim i as integer For i = 1 To Count Step 1 Value = Value & " " & VbCrLf Next i Return Value End Function Public Function BlankZero(ByVal Value As Decimal) if Value = 0 then Return "" end if Return Value End Function Public Function BlankPos(ByVal Value As Decimal) if Value > 0 then Return "" end if Return Value End Function Public Function BlankZeroAndPos(ByVal Value As Decimal) if Value >= 0 then Return "" end if Return Value End Function Public Function BlankNeg(ByVal Value As Decimal) if Value < 0 then Return "" end if Return Value End Function Public Function BlankNegAndZero(ByVal Value As Decimal) if Value <= 0 then Return "" end if Return Value End Function Shared Pct as Decimal Public Function CalcPct(Amount1 as Decimal, Amount2 as Decimal) as Decimal if Amount2 <> 0 then Pct = Amount1 / Amount2 * 100 else Pct = 0 end if REM Rounding precision = 0.1 Return ROUND(10*Pct)/10 End Function</Code> <DataSets> <DataSet Name="DataSet_Result"> <Fields> <Field Name="Customer_No_"> <DataField>Customer_No_</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer___Top_10_ListCaption"> <DataField>Customer___Top_10_ListCaption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="FORMAT_TODAY_0_4_"> <DataField>FORMAT_TODAY_0_4_</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="STRSUBSTNO_Text001_CustDateFilter_"> <DataField>STRSUBSTNO_Text001_CustDateFilter_</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CurrReport_PAGENOCaption"> <DataField>CurrReport_PAGENOCaption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CurrReport_PAGENO"> <DataField>CurrReport_PAGENO</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="COMPANYNAME"> <DataField>COMPANYNAME</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="USERID"> <DataField>USERID</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="STRSUBSTNO_Text002_SELECTSTR_ShowType_1_Text004__"> <DataField>STRSUBSTNO_Text002_SELECTSTR_ShowType_1_Text004__</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="ShowTypeNo"> <DataField>ShowTypeNo</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="NoOfRecordsToPrint"> <DataField>NoOfRecordsToPrint</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="ChartTypeNo"> <DataField>ChartTypeNo</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Customer_TABLECAPTION__________CustFilter"> <DataField>Customer_TABLECAPTION__________CustFilter</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CustFilter"> <DataField>CustFilter</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Integer_NumberCaption"> <DataField>Integer_NumberCaption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__No__Caption"> <DataField>Customer__No__Caption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer_NameCaption"> <DataField>Customer_NameCaption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__Sales__LCY__Caption"> <DataField>Customer__Sales__LCY__Caption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__Balance__LCY__Caption"> <DataField>Customer__Balance__LCY__Caption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="STRSUBSTNO_Text003_SELECTSTR_ShowType_1_Text004__"> <DataField>STRSUBSTNO_Text003_SELECTSTR_ShowType_1_Text004__</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Integer_Number"> <DataField>Integer_Number</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="Customer__No__"> <DataField>Customer__No__</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer_Name"> <DataField>Customer_Name</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__Sales__LCY__"> <DataField>Customer__Sales__LCY__</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="Customer__Sales__LCY__Format"> <DataField>Customer__Sales__LCY__Format</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__Balance__LCY__"> <DataField>Customer__Balance__LCY__</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="Customer__Balance__LCY__Format"> <DataField>Customer__Balance__LCY__Format</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="BarText"> <DataField>BarText</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__Sales__LCY___Control23Caption"> <DataField>Customer__Sales__LCY___Control23Caption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__Sales__LCY___Control23Format"> <DataField>Customer__Sales__LCY___Control23Format</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="Customer__Balance__LCY___Control24Format"> <DataField>Customer__Balance__LCY___Control24Format</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CustSalesLCYCaption"> <DataField>CustSalesLCYCaption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CustSalesLCY"> <DataField>CustSalesLCY</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="CustSalesLCYFormat"> <DataField>CustSalesLCYFormat</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="CustBalanceLCY"> <DataField>CustBalanceLCY</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="CustBalanceLCYFormat"> <DataField>CustBalanceLCYFormat</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="SalesPctCaption"> <DataField>SalesPctCaption</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="SalesPct"> <DataField>SalesPct</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="SalesPctFormat"> <DataField>SalesPctFormat</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="BalancePct"> <DataField>BalancePct</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="BalancePctFormat"> <DataField>BalancePctFormat</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="TotalSales"> <DataField>TotalSales</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="TotalSalesFormat"> <DataField>TotalSalesFormat</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="TotalBalance"> <DataField>TotalBalance</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> <Field Name="TotalBalanceFormat"> <DataField>TotalBalanceFormat</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="This_is_the_text_that_needs_to_go_to_the_bottom_of_the_page____"> <DataField>This_is_the_text_that_needs_to_go_to_the_bottom_of_the_page____</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> </Fields> <Query> <CommandText /> <DataSourceName>DummyDataSource</DataSourceName> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> </Query> <rd:DataSetInfo> <rd:DataSetName>DataSet</rd:DataSetName> <rd:TableName>Result</rd:TableName> </rd:DataSetInfo> </DataSet> </DataSets> <DataSources> <DataSource Name="DummyDataSource"> <ConnectionProperties> <ConnectString /> <DataProvider>SQL</DataProvider> </ConnectionProperties> <rd:DataSourceID>6f5c4ac1-03f2-450d-bbd7-1e7f8c0305e2</rd:DataSourceID> </DataSource> </DataSources> <InteractiveHeight>11in</InteractiveHeight> <InteractiveWidth>8.5in</InteractiveWidth> <Language>=User!Language</Language> <LeftMargin>1.5cm</LeftMargin> <PageHeader> <Height>2.53968cm</Height> <PrintOnFirstPage>true</PrintOnFirstPage> <PrintOnLastPage>true</PrintOnLastPage> <ReportItems> <Textbox Name="PageNumberTextBox"> <Height>0.423cm</Height> <Left>11.42857cm</Left> <Style> <FontSize>9pt</FontSize> <TextAlign>Right</TextAlign> <VerticalAlign>Middle</VerticalAlign> </Style> <Top>0.423cm</Top> <Value>=Globals!PageNumber</Value> <Width>0.95238cm</Width> <ZIndex>7</ZIndex> </Textbox> <Textbox Name="UserIdTextBox"> <Height>0.423cm</Height> <Left>9.10635cm</Left> <Style> <FontSize>9pt</FontSize> <TextAlign>Right</TextAlign> <VerticalAlign>Middle</VerticalAlign> </Style> <Top>0.846cm</Top> <Value>=User!UserID</Value> <Width>3.25cm</Width> <ZIndex>6</ZIndex> </Textbox> <Textbox Name="ExecutionTimeTextBox"> <Height>0.423cm</Height> <Left>9.20635cm</Left> <Style> <FontSize>9pt</FontSize> <Format>g</Format> <TextAlign>Right</TextAlign> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=Globals!ExecutionTime</Value> <Width>3.15cm</Width> <ZIndex>5</ZIndex> </Textbox> <Textbox Name="STRSUBSTNO_Text001_CustDateFilter_1"> <Height>0.423cm</Height> <Style> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> </Style> <Top>0.423cm</Top> <Value>=ReportItems!STRSUBSTNO_Text001_CustDateFilter_.Value</Value> <Width>7.5cm</Width> <ZIndex>4</ZIndex> </Textbox> <Textbox Name="COMPANYNAME1"> <Height>0.423cm</Height> <Style> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> </Style> <Top>0.846cm</Top> <Value>=ReportItems!COMPANYNAME.Value</Value> <Width>7.5cm</Width> <ZIndex>3</ZIndex> </Textbox> <Textbox Name="STRSUBSTNO_Text002_SELECTSTR_ShowType_1_Text004__1"> <Height>0.423cm</Height> <Style> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> </Style> <Top>1.692cm</Top> <Value>=ReportItems!STRSUBSTNO_Text002_SELECTSTR_ShowType_1_Text004__.Value</Value> <Width>7.5cm</Width> <ZIndex>2</ZIndex> </Textbox> <Textbox Name="Customer___Top_10_ListCaption1"> <Height>0.423cm</Height> <Style> <FontSize>9pt</FontSize> <FontWeight>700</FontWeight> <VerticalAlign>Middle</VerticalAlign> </Style> <Value>=ReportItems!Customer___Top_10_ListCaption.Value</Value> <Width>7.5cm</Width> <ZIndex>1</ZIndex> </Textbox> <Textbox Name="CurrReport_PAGENOCaption1"> <Height>0.423cm</Height> <Left>10.39524cm</Left> <Style> <FontSize>9pt</FontSize> <VerticalAlign>Middle</VerticalAlign> </Style> <Top>0.423cm</Top> <Value>=ReportItems!CurrReport_PAGENOCaption.Value</Value> <Width>1.1127cm</Width> </Textbox> </ReportItems> </PageHeader> <PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <TopMargin>2cm</TopMargin> <Width>16.58733cm</Width> <rd:DrawGrid>true</rd:DrawGrid> <rd:ReportID>b0b59414-8f75-4e25-a7c8-b230383b57c8</rd:ReportID> <rd:SnapToGrid>true</rd:SnapToGrid> </Report> END_OF_RDLDatA } }