﻿<?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">
      <Report Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
        <Alias>Report</Alias>
        <Key />
        <Name>Report</Name>
        <PathData>E:\DOWNLOAD\Report.xml</PathData>
        <PathSchema />
      </Report>
    </Databases>
    <DataSources isList="true" count="3">
      <discounts Ref="3" type="DataTableSource" isKey="true">
        <Alias>discounts</Alias>
        <Columns isList="true" count="5">
          <value>amount,System.Decimal</value>
          <value>discReason,System.String</value>
          <value>lines_Id,System.Int32</value>
          <value>numLine,System.String</value>
          <value>transNumLine,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>2539a68501064cb293204374b18dffea</Key>
        <Name>discounts</Name>
        <NameInSource>Report.discounts</NameInSource>
      </discounts>
      <item Ref="4" type="DataTableSource" isKey="true">
        <Alias>item</Alias>
        <Columns isList="true" count="3">
          <value>id,System.String</value>
          <value>lines_Id,System.Int32</value>
          <value>shortDesc,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>fa72149515c04336bcc22b7007ce9a22</Key>
        <Name>item</Name>
        <NameInSource>Report.item</NameInSource>
      </item>
      <lines Ref="5" type="DataTableSource" isKey="true">
        <Alias>lines</Alias>
        <Columns isList="true" count="4">
          <value>itemId,System.String</value>
          <value>lines_Id,System.Int32</value>
          <value>netPrice,System.Decimal</value>
          <value>transLine,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>20f0e8f6f3fb42cab62146ca05349316</Key>
        <Name>lines</Name>
        <NameInSource>Report.lines</NameInSource>
      </lines>
    </DataSources>
    <Relations isList="true" count="2">
      <item Ref="6" type="DataRelation" isKey="true">
        <Alias>item</Alias>
        <ChildColumns isList="true" count="1">
          <value>itemId</value>
        </ChildColumns>
        <ChildSource isRef="5" />
        <Dictionary isRef="1" />
        <Name>item</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>id</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </item>
      <discounts Ref="7" type="DataRelation" isKey="true">
        <Alias>discounts</Alias>
        <ChildColumns isList="true" count="1">
          <value>numLine</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>discounts</Name>
        <NameInSource>Relation2</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>transLine</value>
        </ParentColumns>
        <ParentSource isRef="5" />
      </discounts>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>ec0937b90a6c4f0280250871ed8054c8</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="8" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <HeaderBand1 Ref="9" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="4">
            <Text1 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="8" />
              <Parent isRef="9" />
              <Text>ITEM_ID</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text1>
            <Text2 Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.8,0,5.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>8416fd8335354a59b0ac8ac3e5670b59</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="8" />
              <Parent isRef="9" />
              <Text>ITEM_DESC</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text2>
            <Text3 Ref="12" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>8.4,0,2.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>99f584d3b5e84aa28090ad0abc701d15</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="8" />
              <Parent isRef="9" />
              <Text>NET_PRICE</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text3>
            <Text8 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>11.2,0,4.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>37edcdc2140640ddac01b9cdfc3dfb68</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="8" />
              <Parent isRef="9" />
              <ShrinkFontToFit>True</ShrinkFontToFit>
              <Text>NET_PRICE W/O DISCOUNT</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
            </Text8>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderBand1</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
        </HeaderBand1>
        <DataBand1 Ref="14" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="4">
            <Text5 Ref="15" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="8" />
              <Parent isRef="14" />
              <Text>{lines.item.id}</Text>
              <TextBrush>Black</TextBrush>
            </Text5>
            <Text6 Ref="16" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.8,0,5.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="8" />
              <Parent isRef="14" />
              <ShrinkFontToFit>True</ShrinkFontToFit>
              <Text>{lines.item.shortDesc}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
            </Text6>
            <Text7 Ref="17" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>8.4,0,2.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="8" />
              <Parent isRef="14" />
              <Text>{lines.netPrice}</Text>
              <TextBrush>Black</TextBrush>
            </Text7>
            <Text10 Ref="18" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>11.2,0,4.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>2b40313aaaa34198a2dfec66c5ad4b85</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text10</Name>
              <Page isRef="8" />
              <Parent isRef="14" />
              <Text>{lines.netPrice - Sum(Datadiscounts,discounts.amount)}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text10>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>lines</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
          <PrintIfDetailEmpty>True</PrintIfDetailEmpty>
          <Sort isList="true" count="0" />
        </DataBand1>
        <Datadiscounts Ref="19" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,3.6,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <DataRelationName>Relation2</DataRelationName>
          <DataSourceName>discounts</DataSourceName>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="14" />
          <Name>Datadiscounts</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
          <Sort isList="true" count="0" />
        </Datadiscounts>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>76010e5e91504cab8f308a61c3db442e</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
    </Page1>
  </Pages>
  <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>10/17/2019 11:44:32 AM</ReportChanged>
  <ReportCreated>10/16/2019 2:14:13 PM</ReportCreated>
  <ReportFile>E:\Report_modified.mrt</ReportFile>
  <ReportGuid>816ebb43a48e416698d605ab75a958e1</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2019.3.7.0</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>