Thanks for help
Michal
Code: Select all
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
<Dictionary Ref="1" type="Dictionary" isKey="true">
<BusinessObjects isList="true" count="0" />
<Databases isList="true" count="1">
<Document Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
<Alias>Document</Alias>
<Name>Document</Name>
<PathData>C:\testdocument991118.xml</PathData>
<PathSchema>C:\Workspace\BOSS\Vodafone\4.2.12.08\Customization\DocumentFormatting\Templates\501_detail_statement.xsd</PathSchema>
</Document>
</Databases>
<DataSources isList="true" count="4">
<Parameters Ref="3" type="DataTableSource" isKey="true">
<Alias>Parameters</Alias>
<Columns isList="true" count="4">
<value>number_of_bill,System.String</value>
<value>customer_number,System.Int64</value>
<value>contract_number,System.String</value>
<value>purchase_number,System.String</value>
</Columns>
<Dictionary isRef="1" />
<Name>Parameters</Name>
<NameInSource>Document.Parameters</NameInSource>
</Parameters>
<Accounting_period Ref="4" type="DataTableSource" isKey="true">
<Alias>Accounting_period</Alias>
<Columns isList="true" count="1">
<value>maturity_date,System.DateTime</value>
</Columns>
<Dictionary isRef="1" />
<Name>Accounting_period</Name>
<NameInSource>Document.Accounting_period</NameInSource>
</Accounting_period>
<Payment_information Ref="5" type="DataTableSource" isKey="true">
<Alias>Payment_information</Alias>
<Columns isList="true" count="4">
<value>bank_account_number,System.String</value>
<value>bank_code,System.String</value>
<value>variable_symbol,System.String</value>
<value>specific_symbol,System.String</value>
</Columns>
<Dictionary isRef="1" />
<Name>Payment_information</Name>
<NameInSource>Document.Payment_information</NameInSource>
</Payment_information>
<detail_invoice_item Ref="6" type="DataTableSource" isKey="true">
<Alias>detail_invoice_item</Alias>
<Columns isList="true" count="15">
<value>customer_hierarchy,System.String</value>
<value>customer_name,System.String</value>
<value>customer_group_name,System.String</value>
<value>phone_number,System.String</value>
<value>service_group_name,System.String</value>
<value>billing_service_name,System.String</value>
<value>event_name,System.String</value>
<value>unit_quantity,System.String</value>
<value>unit_price,System.Decimal</value>
<value>metric_unit_code,System.String</value>
<value>item_ammount,System.Decimal</value>
<value>discount,System.Decimal</value>
<value>allowance,System.Decimal</value>
<value>taxable,System.Decimal</value>
<value>taxable_non,System.Decimal</value>
</Columns>
<Dictionary isRef="1" />
<Name>detail_invoice_item</Name>
<NameInSource>Document.detail_invoice_item</NameInSource>
</detail_invoice_item>
</DataSources>
<Relations isList="true" count="0" />
<Report isRef="0" />
<Variables isList="true" count="0" />
</Dictionary>
<EngineVersion>EngineV1</EngineVersion>
<GlobalizationStrings isList="true" count="0" />
<MetaTags isList="true" count="0" />
<Pages isList="true" count="1">
<Page1 Ref="7" type="Page" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<Components isList="true" count="13">
<PageHeader2 Ref="8" type="PageHeaderBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,4,190,10</ClientRectangle>
<Components isList="true" count="6">
<Text35 Ref="9" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>0,2,76,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,14</Font>
<Margins>0,0,0,0</Margins>
<Name>Text35</Name>
<Page isRef="7" />
<Parent isRef="8" />
<PrintOn>OnlyFirstPage</PrintOn>
<Text>Detailní vyúčtování služeb - příloha č. 2</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text35>
<StartPointPrimitive6 Ref="10" type="Stimulsoft.Report.Components.StiStartPointPrimitive" isKey="true">
<ClientRectangle>40,-2,0,0</ClientRectangle>
<Name>StartPointPrimitive6</Name>
<Page isRef="7" />
<Parent isRef="8" />
<ReferenceToGuid>de92490767524b1ba8049e70222bcb38</ReferenceToGuid>
</StartPointPrimitive6>
<StartPointPrimitive1 Ref="11" type="Stimulsoft.Report.Components.StiStartPointPrimitive" isKey="true">
<ClientRectangle>72,-2,0,0</ClientRectangle>
<Name>StartPointPrimitive1</Name>
<Page isRef="7" />
<Parent isRef="8" />
<ReferenceToGuid>071da7b7e1664d72bb41f00964b8856e</ReferenceToGuid>
</StartPointPrimitive1>
<StartPointPrimitive2 Ref="12" type="Stimulsoft.Report.Components.StiStartPointPrimitive" isKey="true">
<ClientRectangle>92,-2,0,0</ClientRectangle>
<Name>StartPointPrimitive2</Name>
<Page isRef="7" />
<Parent isRef="8" />
<ReferenceToGuid>e2aa8f77c2a24abdb6092b6d9d516e47</ReferenceToGuid>
</StartPointPrimitive2>
<StartPointPrimitive3 Ref="13" type="Stimulsoft.Report.Components.StiStartPointPrimitive" isKey="true">
<ClientRectangle>132,-2,0,0</ClientRectangle>
<Name>StartPointPrimitive3</Name>
<Page isRef="7" />
<Parent isRef="8" />
<ReferenceToGuid>46a7355395f54785a9c9d86c6971d318</ReferenceToGuid>
</StartPointPrimitive3>
<StartPointPrimitive4 Ref="14" type="Stimulsoft.Report.Components.StiStartPointPrimitive" isKey="true">
<ClientRectangle>166,-2,0,0</ClientRectangle>
<Name>StartPointPrimitive4</Name>
<Page isRef="7" />
<Parent isRef="8" />
<ReferenceToGuid>a1320de3031f4a3ba7e3bcb714aea461</ReferenceToGuid>
</StartPointPrimitive4>
</Components>
<Conditions isList="true" count="0" />
<Name>PageHeader2</Name>
<Page isRef="7" />
<Parent isRef="7" />
</PageHeader2>
<PageFooter2 Ref="15" type="PageFooterBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,261,190,16</ClientRectangle>
<Components isList="true" count="1">
<Text37 Ref="16" type="Text" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>160,11,28,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text37</Name>
<Page isRef="7" />
<Parent isRef="15" />
<Text>Strana {PageNumber} z {TotalPageCount}</Text>
<TextBrush>Black</TextBrush>
<Type>Expression</Type>
</Text37>
</Components>
<Conditions isList="true" count="0" />
<Name>PageFooter2</Name>
<Page isRef="7" />
<Parent isRef="7" />
</PageFooter2>
<GroupHeaderCustomerName Ref="17" type="GroupHeaderBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,22,190,10</ClientRectangle>
<Components isList="true" count="2">
<Text1 Ref="18" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<CanGrow>True</CanGrow>
<ClientRectangle>0,0,160,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,14,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text1</Name>
<Page isRef="7" />
<Parent isRef="17" />
<Text>{detail_invoice_item.customer_name}</Text>
<TextBrush>Black</TextBrush>
<TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
<TextQuality>Typographic</TextQuality>
</Text1>
<Text15 Ref="19" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>160,0,30,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,14,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text15</Name>
<Page isRef="7" />
<Parent isRef="17" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.item_ammount - detail_invoice_item.discount - detail_invoice_item.allowance))} Kč</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text15>
</Components>
<Condition>{detail_invoice_item.customer_name}</Condition>
<Conditions isList="true" count="0" />
<Name>GroupHeaderCustomerName</Name>
<Page isRef="7" />
<Parent isRef="7" />
<StartNewPage>True</StartNewPage>
</GroupHeaderCustomerName>
<GroupHeaderCustomerHierarchy Ref="20" type="GroupHeaderBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,40,190,10</ClientRectangle>
<Components isList="true" count="2">
<Text4 Ref="21" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<CanGrow>True</CanGrow>
<ClientRectangle>0,0,160,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,14,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text4</Name>
<Page isRef="7" />
<Parent isRef="20" />
<Text>{detail_invoice_item.customer_hierarchy}</Text>
<TextBrush>Black</TextBrush>
<TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
<TextQuality>Typographic</TextQuality>
</Text4>
<Text16 Ref="22" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>160,0,30,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,14,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text16</Name>
<Page isRef="7" />
<Parent isRef="20" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.item_ammount - detail_invoice_item.discount - detail_invoice_item.allowance))} Kč</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text16>
</Components>
<Condition>{detail_invoice_item.customer_hierarchy}</Condition>
<Conditions isList="true" count="0" />
<Name>GroupHeaderCustomerHierarchy</Name>
<Page isRef="7" />
<Parent isRef="7" />
<StartNewPage>True</StartNewPage>
</GroupHeaderCustomerHierarchy>
<GroupHeaderPhoneNumber Ref="23" type="GroupHeaderBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,58,190,8</ClientRectangle>
<Components isList="true" count="2">
<Container4 Ref="24" type="Container" isKey="true">
<Brush>[226:227:228]</Brush>
<ClientRectangle>0,0,190,8</ClientRectangle>
<Components isList="true" count="8">
<Text2 Ref="25" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>0,2,58,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,12,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text2</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>{detail_invoice_item.phone_number}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
</Text2>
<Text47 Ref="26" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>154,4,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text47</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>Sleva*</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text47>
<Text49 Ref="27" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>84,4,14,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text49</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>Jednotka</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text49>
<Text45 Ref="28" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>172,0,18,8</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text45</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>Celkem k
vyúčtování*</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text45>
<Text48 Ref="29" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>98,0,18,8</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text48</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>Jednotková
cena*</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text48>
<Text50 Ref="30" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>66,0,18,8</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text50</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>Účtované
jednotky</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text50>
<Text51 Ref="31" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>116,4,20,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text51</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>Celkem*</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text51>
<Text46 Ref="32" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>136,0,18,8</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text46</Name>
<Page isRef="7" />
<Parent isRef="24" />
<Text>Čerpáno
z kreditu*</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text46>
</Components>
<Conditions isList="true" count="0" />
<Name>Container4</Name>
<Page isRef="7" />
<Parent isRef="23" />
</Container4>
<HorizontalLine1 Ref="33" type="HorizontalLinePrimitive" isKey="true">
<ClientRectangle>0,8,190,0.254</ClientRectangle>
<Color>Black</Color>
<EndCap Ref="34" type="Cap" isKey="true">
<Color>Black</Color>
</EndCap>
<Name>HorizontalLine1</Name>
<Page isRef="7" />
<Parent isRef="23" />
<StartCap Ref="35" type="Cap" isKey="true">
<Color>Black</Color>
</StartCap>
<Style>Double</Style>
</HorizontalLine1>
</Components>
<Condition>{detail_invoice_item.phone_number}</Condition>
<Conditions isList="true" count="0" />
<Name>GroupHeaderPhoneNumber</Name>
<Page isRef="7" />
<Parent isRef="7" />
<PrintOnAllPages>True</PrintOnAllPages>
<StartNewPage>True</StartNewPage>
</GroupHeaderPhoneNumber>
<GroupHeaderServiceGroup Ref="36" type="GroupHeaderBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,74,190,10</ClientRectangle>
<Components isList="true" count="6">
<Text5 Ref="37" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<CanGrow>True</CanGrow>
<ClientRectangle>0,4,66,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,12,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text5</Name>
<Page isRef="7" />
<Parent isRef="36" />
<Text>{detail_invoice_item.service_group_name}</Text>
<TextBrush>Black</TextBrush>
<TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
<TextQuality>Typographic</TextQuality>
</Text5>
<Text33 Ref="38" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>118,6,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text33</Name>
<Page isRef="7" />
<Parent isRef="36" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.item_ammount))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text33>
<Text32 Ref="39" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>136,6,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text32</Name>
<Page isRef="7" />
<Parent isRef="36" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.allowance))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text32>
<Text18 Ref="40" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>154,6,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text18</Name>
<Page isRef="7" />
<Parent isRef="36" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.discount))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text18>
<Text52 Ref="41" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>172,6,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text52</Name>
<Page isRef="7" />
<Parent isRef="36" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.item_ammount - detail_invoice_item.discount - detail_invoice_item.allowance))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text52>
<HorizontalLine3 Ref="42" type="HorizontalLinePrimitive" isKey="true">
<ClientRectangle>0,10,190,0.254</ClientRectangle>
<Color>Black</Color>
<EndCap Ref="43" type="Cap" isKey="true">
<Color>Black</Color>
</EndCap>
<Name>HorizontalLine3</Name>
<Page isRef="7" />
<Parent isRef="36" />
<StartCap Ref="44" type="Cap" isKey="true">
<Color>Black</Color>
</StartCap>
</HorizontalLine3>
</Components>
<Condition>{detail_invoice_item.service_group_name}</Condition>
<Conditions isList="true" count="0" />
<Name>GroupHeaderServiceGroup</Name>
<Page isRef="7" />
<Parent isRef="7" />
</GroupHeaderServiceGroup>
<GroupHeaderBillingServiceName Ref="45" type="GroupHeaderBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,92,190,4</ClientRectangle>
<Components isList="true" count="2">
<Text3 Ref="46" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<CanGrow>True</CanGrow>
<ClientRectangle>0,0,66,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text3</Name>
<Page isRef="7" />
<Parent isRef="45" />
<Text>{detail_invoice_item.billing_service_name}</Text>
<TextBrush>Black</TextBrush>
<TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
<TextQuality>Typographic</TextQuality>
</Text3>
<Text39 Ref="47" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>172,0,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text39</Name>
<Page isRef="7" />
<Parent isRef="45" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.item_ammount - detail_invoice_item.discount - detail_invoice_item.allowance))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text39>
</Components>
<Condition>{detail_invoice_item.billing_service_name}</Condition>
<Conditions isList="true" count="0" />
<Name>GroupHeaderBillingServiceName</Name>
<Page isRef="7" />
<Parent isRef="7" />
</GroupHeaderBillingServiceName>
<Data1 Ref="48" type="DataBand" isKey="true">
<Brush>Transparent</Brush>
<BusinessObjectGuid isNull="true" />
<CanBreak>True</CanBreak>
<ClientRectangle>0,104,190,4</ClientRectangle>
<Components isList="true" count="8">
<Text6 Ref="49" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>66,0,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text6</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{detail_invoice_item.unit_quantity}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
</Text6>
<Text7 Ref="50" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>84,0,14,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text7</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{detail_invoice_item.metric_unit_code}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
</Text7>
<Text8 Ref="51" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>98,0,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text8</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{Format("{0:N2}",detail_invoice_item.unit_price)}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text8>
<Text9 Ref="52" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>116,0,20,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text9</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{Format("{0:N2}",detail_invoice_item.item_ammount)}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text9>
<Text10 Ref="53" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>154,0,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text10</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{Format("{0:N2}",detail_invoice_item.discount)}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text10>
<Text11 Ref="54" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>172,0,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text11</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{Format("{0:N2}",detail_invoice_item.item_ammount - detail_invoice_item.discount - detail_invoice_item.allowance)}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text11>
<Text12 Ref="55" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<CanGrow>True</CanGrow>
<ClientRectangle>0,0,66,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg8 type=,10</Font>
<Margins>0,0,0,0</Margins>
<Name>Text12</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{detail_invoice_item.event_name}</Text>
<TextBrush>Black</TextBrush>
<TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
<TextQuality>Typographic</TextQuality>
</Text12>
<Text31 Ref="56" type="Text" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>136,0,18,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text31</Name>
<Page isRef="7" />
<Parent isRef="48" />
<Text>{Format("{0:N2}", detail_invoice_item.allowance)}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text31>
</Components>
<Conditions isList="true" count="0" />
<DataSourceName>detail_invoice_item</DataSourceName>
<Filters isList="true" count="0" />
<Name>Data1</Name>
<Page isRef="7" />
<Parent isRef="7" />
<Sort isList="true" count="0" />
</Data1>
<GroupFooterBillingServiceName Ref="57" type="GroupFooterBand" isKey="true">
<Brush>Transparent</Brush>
<CanShrink>True</CanShrink>
<ClientRectangle>0,116,190,8</ClientRectangle>
<Components isList="true" count="0" />
<Conditions isList="true" count="0" />
<Name>GroupFooterBillingServiceName</Name>
<Page isRef="7" />
<Parent isRef="7" />
</GroupFooterBillingServiceName>
<GroupFooterServiceGroup Ref="58" type="GroupFooterBand" isKey="true">
<Brush>Transparent</Brush>
<CanShrink>True</CanShrink>
<ClientRectangle>0,132,190,8</ClientRectangle>
<Components isList="true" count="0" />
<Conditions isList="true" count="0" />
<Name>GroupFooterServiceGroup</Name>
<Page isRef="7" />
<Parent isRef="7" />
</GroupFooterServiceGroup>
<GroupFooterPhoneNumber Ref="59" type="GroupFooterBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,148,190,26</ClientRectangle>
<Components isList="true" count="7">
<Text40 Ref="60" type="Text" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,8,90,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text40</Name>
<Page isRef="7" />
<Parent isRef="59" />
<Text>Celkem za položky podléhající DPH</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text40>
<Text41 Ref="61" type="Text" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,12,90,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text41</Name>
<Page isRef="7" />
<Parent isRef="59" />
<Text>Celkem za položky nepodléhající DPH</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text41>
<Text42 Ref="62" type="Text" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,18,90,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Arial,12,Bold</Font>
<Margins>0,0,0,0</Margins>
<Name>Text42</Name>
<Page isRef="7" />
<Parent isRef="59" />
<Text>Celkem za {detail_invoice_item.phone_number}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text42>
<Text43 Ref="63" type="Text" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>164,8,26,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text43</Name>
<Page isRef="7" />
<Parent isRef="59" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.taxable))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text43>
<Text44 Ref="64" type="Text" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>164,12,26,4</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,10,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text44</Name>
<Page isRef="7" />
<Parent isRef="59" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.taxable_non))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text44>
<Text17 Ref="65" type="Text" isKey="true">
<Border>None;Black;2;Solid;False;4;Black</Border>
<Brush>Transparent</Brush>
<ClientRectangle>164,18,26,6</ClientRectangle>
<Conditions isList="true" count="0" />
<Font>Vodafone Rg,12,Bold</Font>
<HorAlignment>Right</HorAlignment>
<Margins>0,0,0,0</Margins>
<Name>Text17</Name>
<Page isRef="7" />
<Parent isRef="59" />
<Text>{Format("{0:N2}",Sum(detail_invoice_item.item_ammount - detail_invoice_item.discount - detail_invoice_item.allowance))}</Text>
<TextBrush>Black</TextBrush>
<TextQuality>Typographic</TextQuality>
<Type>Expression</Type>
</Text17>
<HorizontalLine2 Ref="66" type="HorizontalLinePrimitive" isKey="true">
<ClientRectangle>0,16,190,0.254</ClientRectangle>
<Color>Black</Color>
<EndCap Ref="67" type="Cap" isKey="true">
<Color>Black</Color>
</EndCap>
<Name>HorizontalLine2</Name>
<Page isRef="7" />
<Parent isRef="59" />
<StartCap Ref="68" type="Cap" isKey="true">
<Color>Black</Color>
</StartCap>
</HorizontalLine2>
</Components>
<Conditions isList="true" count="0" />
<Name>GroupFooterPhoneNumber</Name>
<Page isRef="7" />
<Parent isRef="7" />
</GroupFooterPhoneNumber>
<GroupFooterCustomerHierarchy Ref="69" type="GroupFooterBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,182,190,8</ClientRectangle>
<Components isList="true" count="0" />
<Conditions isList="true" count="0" />
<Name>GroupFooterCustomerHierarchy</Name>
<Page isRef="7" />
<Parent isRef="7" />
</GroupFooterCustomerHierarchy>
<GroupFooterCustomerName Ref="70" type="GroupFooterBand" isKey="true">
<Brush>Transparent</Brush>
<ClientRectangle>0,198,190,8</ClientRectangle>
<Components isList="true" count="0" />
<Conditions isList="true" count="0" />
<Name>GroupFooterCustomerName</Name>
<Page isRef="7" />
<Parent isRef="7" />
</GroupFooterCustomerName>
</Components>
<Conditions isList="true" count="0" />
<Guid>558dbfb055864a2c9e1d5d45fdbf6c12</Guid>
<Margins>10,10,10,10</Margins>
<Name>Page1</Name>
<PageHeight>297</PageHeight>
<PageWidth>210</PageWidth>
<Report isRef="0" />
<Watermark Ref="71" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
<Font>Arial,100</Font>
<TextBrush>[50:0:0:0]</TextBrush>
</Watermark>
</Page1>
</Pages>
<PrinterSettings Ref="72" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
<ReferencedAssemblies isList="true" count="8">
<value>System.Dll</value>
<value>System.Drawing.Dll</value>
<value>System.Windows.Forms.Dll</value>
<value>System.Data.Dll</value>
<value>System.Xml.Dll</value>
<value>Stimulsoft.Controls.Dll</value>
<value>Stimulsoft.Base.Dll</value>
<value>Stimulsoft.Report.Dll</value>
</ReferencedAssemblies>
<ReportAlias>Report</ReportAlias>
<ReportChanged>7/13/2012 12:54:29 PM</ReportChanged>
<ReportCreated>3/20/2012 8:31:03 AM</ReportCreated>
<ReportFile>C:\Workspace\BOSS\Vodafone\4.2.12.08\Customization\DocumentFormatting\Templates\Copy of 501_detail_statement.mrt</ReportFile>
<ReportGuid>dde2cffc7d0c41dfa6b01d378116e542</ReportGuid>
<ReportName>Report</ReportName>
<ReportUnit>Millimeters</ReportUnit>
<ReportVersion>2012.1.1300</ReportVersion>
<Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;
namespace Reports
{
public class Report : Stimulsoft.Report.StiReport
{
public Report()
{
this.InitializeComponent();
}
#region StiReport Designer generated code - do not modify#endregion StiReport Designer generated code - do not modify
}
}</Script>
<ScriptLanguage>CSharp</ScriptLanguage>
<Styles isList="true" count="0" />
</StiSerializer>