﻿<?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">
      <MSSQL1 Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>MSSQL1</Alias>
        <ConnectionStringEncrypted>9FZlSFsJ2chGW+2A5SVtP9Fq2w1FSpLIYhXoRG8Y5E/VeGkCxV3TBfF75Y13PeFnw3DRK05Wo5nLTe3c+2ygf9lW++tNS0ukRmTRBGcYYnv2VPeDxU/TbXJNPRhjUGUn13ybiEVUWvVFfEW9YQCxE9k=</ConnectionStringEncrypted>
        <Name>MSSQL1</Name>
      </MSSQL1>
    </Databases>
    <DataSources isList="true" count="3">
      <CategorySet Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>CategorySet</Alias>
        <Columns isList="true" count="7">
          <value>Id,System.Int32</value>
          <value>CategoryName,System.String</value>
          <value>RowVersion,System.Int64</value>
          <value>CreatedBy,System.String</value>
          <value>Created,System.DateTimeOffset</value>
          <value>ModifiedBy,System.String</value>
          <value>Modified,System.DateTimeOffset</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>CategorySet</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="0" />
        <ReconnectOnEachRow>True</ReconnectOnEachRow>
        <SqlCommand>select * from CategorySet</SqlCommand>
      </CategorySet>
      <ProductSet Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>ProductSet</Alias>
        <Columns isList="true" count="9">
          <value>Id,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>RowVersion,System.Int64</value>
          <value>Product_Category,System.Int32</value>
          <value>Product_Category1,System.Int32</value>
          <value>CreatedBy,System.String</value>
          <value>Created,System.DateTimeOffset</value>
          <value>ModifiedBy,System.String</value>
          <value>Modified,System.DateTimeOffset</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>ProductSet</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from ProductSet</SqlCommand>
      </ProductSet>
      <SubCategorySet Ref="5" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>SubCategorySet</Alias>
        <Columns isList="true" count="8">
          <value>Id,System.Int32</value>
          <value>Description,System.String</value>
          <value>RowVersion,System.Int64</value>
          <value>SubCategory_Category,System.Int32</value>
          <value>CreatedBy,System.String</value>
          <value>Created,System.DateTimeOffset</value>
          <value>ModifiedBy,System.String</value>
          <value>Modified,System.DateTimeOffset</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <ConnectOnStart>False</ConnectOnStart>
        <Dictionary isRef="1" />
        <Name>SubCategorySet</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_CatID,,8,0</value>
        </Parameters>
        <SqlCommand>select * from SubCategorySet 
	where subcategory_category = @CatID</SqlCommand>
      </SubCategorySet>
    </DataSources>
    <Relations isList="true" count="3">
      <CatCommercial Ref="6" type="DataRelation" isKey="true">
        <Alias>CatCommercial</Alias>
        <ChildColumns isList="true" count="1">
          <value>Product_Category</value>
        </ChildColumns>
        <ChildSource isRef="4" />
        <Dictionary isRef="1" />
        <Name>CatCommercial</Name>
        <NameInSource>CatCommercial</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>Id</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </CatCommercial>
      <CatProdution Ref="7" type="DataRelation" isKey="true">
        <Alias>CatProdution</Alias>
        <ChildColumns isList="true" count="1">
          <value>Product_Category1</value>
        </ChildColumns>
        <ChildSource isRef="4" />
        <Dictionary isRef="1" />
        <Name>CatProdution</Name>
        <NameInSource>CatProdution</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>Id</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </CatProdution>
      <Category Ref="8" type="DataRelation" isKey="true">
        <Alias>Category</Alias>
        <ChildColumns isList="true" count="1">
          <value>SubCategory_Category</value>
        </ChildColumns>
        <ChildSource isRef="5" />
        <Dictionary isRef="1" />
        <Name>Category</Name>
        <NameInSource>Category</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>Id</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </Category>
    </Relations>
    <Report isRef="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="9" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="7">
        <HeaderProductSet Ref="10" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <HeaderProductSet_ProductName Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,3.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderProductSet_ProductName</Name>
              <Page isRef="9" />
              <Parent isRef="10" />
              <Text>ProductName</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderProductSet_ProductName>
            <Text3 Ref="12" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>6.4,0,3.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold</Font>
              <Guid>0ecfdbef5c3543d9901e45c3ce41cc5e</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="9" />
              <Parent isRef="10" />
              <Text>Comm. category</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text3>
            <Text4 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>15.8,0,3.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11,Bold</Font>
              <Guid>4dbbc781268e47458b0d6c0288a32202</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="9" />
              <Parent isRef="10" />
              <Text>Prod. Category</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text4>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderProductSet</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
        </HeaderProductSet>
        <DataProductSet Ref="14" type="DataBand" isKey="true">
          <AfterPrintEvent>SubCategorySet.Parameters["@CatID"].ParameterValue = ProductSet.Product_Category;
SubCategorySet.Connect();</AfterPrintEvent>
          <Brush>Yellow</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="5">
            <DataProductSet_ProductName Ref="15" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,19,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProductSet_ProductName</Name>
              <Page isRef="9" />
              <Parent isRef="14" />
              <Text>{ProductSet.ProductName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProductSet_ProductName>
            <Text1 Ref="16" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>7.2,0,4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="9" />
              <Parent isRef="14" />
              <Text>{ProductSet.CatCommercial.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text1>
            <Text5 Ref="17" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>13,0,4.2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="9" />
              <Parent isRef="14" />
              <Text>{ProductSet.CatProdution.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text5>
            <Text10 Ref="18" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>11.2,0,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text10</Name>
              <Page isRef="9" />
              <Parent isRef="14" />
              <Text>{ProductSet.Product_Category}</Text>
              <TextBrush>Black</TextBrush>
            </Text10>
            <Text11 Ref="19" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>17.4,0,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text11</Name>
              <Page isRef="9" />
              <Parent isRef="14" />
              <Text>{ProductSet.Product_Category1}</Text>
              <TextBrush>Black</TextBrush>
            </Text11>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>CatCommercial</DataRelationName>
          <DataSourceName>ProductSet</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataProductSet</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
          <PrintIfDetailEmpty>True</PrintIfDetailEmpty>
          <Sort isList="true" count="0" />
        </DataProductSet>
        <HeaderSubCategorySet Ref="20" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.6,19,0.8</ClientRectangle>
          <Components isList="true" count="1">
            <HeaderSubCategorySet_Description Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,19,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSubCategorySet_Description</Name>
              <Page isRef="9" />
              <Parent isRef="20" />
              <Text>Commercial City{SubCategorySet.Parameters["@CatID"].ParameterValue}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </HeaderSubCategorySet_Description>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderSubCategorySet</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
        </HeaderSubCategorySet>
        <DataSubCategorySet Ref="22" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,5.2,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <DataSubCategorySet_Description Ref="23" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,10,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSubCategorySet_Description</Name>
              <Page isRef="9" />
              <Parent isRef="22" />
              <Text>{SubCategorySet.Description}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSubCategorySet_Description>
            <Text6 Ref="24" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>11.8,0,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="9" />
              <Parent isRef="22" />
              <Text>{SubCategorySet.Id}</Text>
              <TextBrush>Black</TextBrush>
            </Text6>
            <Text7 Ref="25" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>13.4,0,3,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="9" />
              <Parent isRef="22" />
              <Text>{SubCategorySet.SubCategory_Category}</Text>
              <TextBrush>Black</TextBrush>
            </Text7>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>SubCategorySet</DataSourceName>
          <FilterEngine>SQLQuery</FilterEngine>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="14" />
          <Name>DataSubCategorySet</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
          <Sort isList="true" count="0" />
        </DataSubCategorySet>
        <FooterBand1 Ref="26" type="FooterBand" isKey="true">
          <AfterPrintEvent>SubCategorySet.Parameters["@CatID"].ParameterValue = ProductSet.Product_Category1;
SubCategorySet.Connect();</AfterPrintEvent>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,6.8,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <Name>FooterBand1</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
        </FooterBand1>
        <HeaderSubCategorySet2 Ref="27" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,7.6,19,0.8</ClientRectangle>
          <Components isList="true" count="1">
            <Text2 Ref="28" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,19,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Guid>24c9f1d3dfa54057869f754dd77a8e20</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="9" />
              <Parent isRef="27" />
              <Text>Production City</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text2>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderSubCategorySet2</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
        </HeaderSubCategorySet2>
        <DataSubCategorySet2 Ref="29" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,9.2,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <DataSubCategorySet_Description2 Ref="30" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,10,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSubCategorySet_Description2</Name>
              <Page isRef="9" />
              <Parent isRef="29" />
              <Text>{SubCategorySet.Description}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSubCategorySet_Description2>
            <Text8 Ref="31" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>11.8,0,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Guid>6c017b8a11bd4058ab9682b5d2356075</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="9" />
              <Parent isRef="29" />
              <Text>{SubCategorySet.Id}</Text>
              <TextBrush>Black</TextBrush>
            </Text8>
            <Text9 Ref="32" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>13.4,0,3,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Guid>44a4150235c64b359c9d642b71733e76</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text9</Name>
              <Page isRef="9" />
              <Parent isRef="29" />
              <Text>{SubCategorySet.SubCategory_Category}</Text>
              <TextBrush>Black</TextBrush>
            </Text9>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>SubCategorySet</DataSourceName>
          <FilterEngine>SQLQuery</FilterEngine>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="14" />
          <Name>DataSubCategorySet2</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
          <Sort isList="true" count="0" />
        </DataSubCategorySet2>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>8c0b77815f2c497c99d9a69cc6b201bf</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="33" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PreviewSettings>268435455</PreviewSettings>
  <PrinterSettings Ref="34" 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>6/3/2016 1:25:46 PM</ReportChanged>
  <ReportCreated>5/31/2016 4:10:12 PM</ReportCreated>
  <ReportFile>E:\0002\0005\ReconnectOnEachRow_WithSameDataSource.mrt</ReportFile>
  <ReportGuid>c1baa311c260434bb52adc7397640bcf</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2016.1.14</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>