﻿<?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>9Fa3oOhd84VpWr045UAjDsRq9wBObBHFaXTl9GNspC/VeM9pZEy7mPkVjfTldGIv3Nh/DE9Lo9VCQZzs5FRlO4PI0atpVEvNbVypmOlM63/53NkJZWpCiGMQrJ39JWWjiGDbDeVdu8jiRiHM5djgF91awYnHTHv8chnhgPGA4xfyePsL3UpRwfVHOcThAKR7xNbPy2d6k31sdKmYckzhG+ToywlITFqMaXT9zMMlKUrybNWNxldhTcFc7cxquGE70WDPaE0Y00E=</ConnectionStringEncrypted>
        <Name>MSSQL1</Name>
      </MSSQL1>
    </Databases>
    <DataSources isList="true" count="4">
      <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>
        <Dictionary isRef="1" />
        <Name>SubCategorySet</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_CatID,ProductSet.CatCommercial.Id,8,0</value>
        </Parameters>
        <ReconnectOnEachRow>True</ReconnectOnEachRow>
        <SqlCommand>select * from SubCategorySet where subcategory_category = @CatID</SqlCommand>
      </SubCategorySet>
      <SubCategorySet2 Ref="6" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>SubCategorySet2</Alias>
        <Columns isList="true" count="8">
          <value>Id,System.Int32</value>
          <value>Description,System.String</value>
          <value>CreatedBy,System.String</value>
          <value>Created,System.DateTimeOffset</value>
          <value>ModifiedBy,System.String</value>
          <value>Modified,System.DateTimeOffset</value>
          <value>RowVersion,System.Byte[]</value>
          <value>SubCategory_Category,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>SubCategorySet2</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_CatID2,ProductSet.CatProdution.Id,8,0</value>
        </Parameters>
        <ReconnectOnEachRow>True</ReconnectOnEachRow>
        <SqlCommand>SELECT *
FROM SubCategorySet where subcategory_category = @CatID2</SqlCommand>
      </SubCategorySet2>
    </DataSources>
    <Relations isList="true" count="4">
      <CatCommercial Ref="7" 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="8" 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="9" 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>
      <Category Ref="10" type="DataRelation" isKey="true">
        <Alias>Category</Alias>
        <ChildColumns isList="true" count="1">
          <value>SubCategory_Category</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <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="11" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="6">
        <HeaderProductSet Ref="12" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <HeaderProductSet_ProductName Ref="13" 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="11" />
              <Parent isRef="12" />
              <Text>ProductName</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderProductSet_ProductName>
            <Text3 Ref="14" 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="11" />
              <Parent isRef="12" />
              <Text>Comm. category</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text3>
            <Text4 Ref="15" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>15,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="11" />
              <Parent isRef="12" />
              <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="11" />
          <Parent isRef="11" />
        </HeaderProductSet>
        <DataProductSet Ref="16" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <DataProductSet_ProductName Ref="17" 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="11" />
              <Parent isRef="16" />
              <Text>{ProductSet.ProductName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProductSet_ProductName>
            <Text1 Ref="18" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>7.2,0,6.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="11" />
              <Parent isRef="16" />
              <Text>{ProductSet.CatCommercial.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text1>
            <Text5 Ref="19" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>15.8,0,3.2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="11" />
              <Parent isRef="16" />
              <Text>{ProductSet.CatProdution.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text5>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>ProductSet</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataProductSet</Name>
          <Page isRef="11" />
          <Parent isRef="11" />
          <Sort isList="true" count="0" />
        </DataProductSet>
        <HeaderSubCategorySet Ref="20" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.6,19,0.4</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="11" />
              <Parent isRef="20" />
              <Text>Commercial City</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="11" />
          <Parent isRef="11" />
        </HeaderSubCategorySet>
        <DataSubCategorySet Ref="22" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,4.8,19,0.8</ClientRectangle>
          <Components isList="true" count="1">
            <DataSubCategorySet_Description Ref="23" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,19,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSubCategorySet_Description</Name>
              <Page isRef="11" />
              <Parent isRef="22" />
              <Text>{SubCategorySet.Description}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSubCategorySet_Description>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>SubCategorySet</DataSourceName>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="16" />
          <Name>DataSubCategorySet</Name>
          <Page isRef="11" />
          <Parent isRef="11" />
          <Sort isList="true" count="0" />
        </DataSubCategorySet>
        <HeaderSubCategorySet2 Ref="24" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,6.4,19,0.4</ClientRectangle>
          <Components isList="true" count="1">
            <Text2 Ref="25" 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="11" />
              <Parent isRef="24" />
              <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="11" />
          <Parent isRef="11" />
        </HeaderSubCategorySet2>
        <DataSubCategorySet2 Ref="26" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,7.6,19,0.8</ClientRectangle>
          <Components isList="true" count="1">
            <Text10 Ref="27" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,9,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text10</Name>
              <Page isRef="11" />
              <Parent isRef="26" />
              <Text>{SubCategorySet2.Description}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text10>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>SubCategorySet2</DataSourceName>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="16" />
          <Name>DataSubCategorySet2</Name>
          <Page isRef="11" />
          <Parent isRef="11" />
          <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="28" 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="29" 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>5/31/2016 5:45:14 PM</ReportChanged>
  <ReportCreated>5/31/2016 4:10:12 PM</ReportCreated>
  <ReportFile>C:\Users\Luca\Desktop\2Next\sviluppo_nuovo_retail\Report\test\ReconnectOnEachRow_WithDifferentDataSource.mrt</ReportFile>
  <ReportGuid>830ef37cdb044f7cb979dc1c40899855</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2016.1.12</ReportVersion>
  <Script>Imports System
Imports System.Drawing
Imports System.Windows.Forms
Imports System.Data
Imports Stimulsoft.Controls
Imports Stimulsoft.Base.Drawing
Imports Stimulsoft.Report
Imports Stimulsoft.Report.Dialogs
Imports Stimulsoft.Report.Components

Namespace Reports
    Public Class Report
        Inherits Stimulsoft.Report.StiReport

        Public Sub New()
            MyBase.New
            Me.InitializeComponent
        End Sub

        #Region "StiReport Designer generated code - do not modify"
		#End Region 'StiReport Designer generated code - do not modify
    End Class
End Namespace
</Script>
  <ScriptLanguage>VB</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>