﻿<?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">
      <Book1 Ref="2" type="Stimulsoft.Report.Dictionary.StiExcelDatabase" isKey="true">
        <Alias>Book1</Alias>
        <Key />
        <Name>Book1</Name>
        <PathData>C:\Users\vinee\Desktop\Sti Test\Databand same filter twice\Book1.xlsx</PathData>
      </Book1>
    </Databases>
    <DataSources isList="true" count="1">
      <Sheet1 Ref="3" type="DataTableSource" isKey="true">
        <Alias>Sheet1</Alias>
        <Columns isList="true" count="4">
          <value>id,System.Double</value>
          <value>Name,System.String</value>
          <value>isParent,System.Boolean</value>
          <value>Parent,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Sheet1</Name>
        <NameInSource>Book1.Sheet1</NameInSource>
      </Sheet1>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <Page1 Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <HeaderSheet1 Ref="5" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.72,0.3</ClientRectangle>
          <Components isList="true" count="3">
            <HeaderSheet1_id Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.6,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSheet1_id</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>id</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderSheet1_id>
            <HeaderSheet1_Name Ref="7" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.6,0,2.6,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSheet1_Name</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>Name</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderSheet1_Name>
            <HeaderSheet1_isParent Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5.2,0,2.5,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSheet1_isParent</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>isParent</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderSheet1_isParent>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderSheet1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </HeaderSheet1>
        <DataSheet1 Ref="9" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.9,7.72,0.3</ClientRectangle>
          <Components isList="true" count="3">
            <DataSheet1_id Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,2.6,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSheet1_id</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sheet1.id}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSheet1_id>
            <DataSheet1_Name Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>2.6,0,2.6,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSheet1_Name</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sheet1.Name}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSheet1_Name>
            <DataSheet1_isParent Ref="12" type="CheckBox" isKey="true">
              <Brush>Transparent</Brush>
              <Checked>{Sheet1.isParent}</Checked>
              <ClientRectangle>5.2,0,2.5,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <ContourColor>Black</ContourColor>
              <Name>DataSheet1_isParent</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <TextBrush>Black</TextBrush>
            </DataSheet1_isParent>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Sheet1</DataSourceName>
          <Filters isList="true" count="1">
            <value>isParent,EqualTo,true,,Boolean</value>
          </Filters>
          <Name>DataSheet1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataSheet1>
        <ChildBand1 Ref="13" type="ChildBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.6,7.72,0.3</ClientRectangle>
          <Components isList="true" count="1">
            <SubReport1 Ref="14" type="SubReport" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,7.7,0.3</ClientRectangle>
              <Components isList="true" count="0" />
              <Name>SubReport1</Name>
              <Page isRef="4" />
              <Parameters isList="true" count="1">
                <Parent Ref="15" type="Stimulsoft.Report.Components.StiParameter" isKey="true">
                  <Expression>Sheet1.Name</Expression>
                  <Name>Parent</Name>
                </Parent>
              </Parameters>
              <Parent isRef="13" />
              <SubReportPageGuid>115c297699354b3282487c51eef52b95</SubReportPageGuid>
              <SubReportUrl />
            </SubReport1>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ChildBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </ChildBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>bd8d7f8ac62f4164bdbe82a4c74787df</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <PageHeight>11</PageHeight>
      <PageWidth>8.5</PageWidth>
      <PaperSize>Letter</PaperSize>
      <Report isRef="0" />
      <Watermark Ref="16" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
    <subReport_1 Ref="17" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <HeaderSheet12 Ref="18" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.7,0.3</ClientRectangle>
          <Components isList="true" count="4">
            <HeaderSheet1_id2 Ref="19" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSheet1_id2</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Text>id</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderSheet1_id2>
            <HeaderSheet1_Name2 Ref="20" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.9,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSheet1_Name2</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Text>Name</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderSheet1_Name2>
            <HeaderSheet1_isParent2 Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>3.8,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSheet1_isParent2</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Text>isParent</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderSheet1_isParent2>
            <HeaderSheet1_Parent Ref="22" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5.7,0,2,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderSheet1_Parent</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Text>Parent</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderSheet1_Parent>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderSheet12</Name>
          <Page isRef="17" />
          <Parent isRef="17" />
        </HeaderSheet12>
        <DataSheet12 Ref="23" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.9,7.7,0.3</ClientRectangle>
          <Components isList="true" count="4">
            <DataSheet1_id2 Ref="24" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSheet1_id2</Name>
              <Page isRef="17" />
              <Parent isRef="23" />
              <Text>{Sheet1.id}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSheet1_id2>
            <DataSheet1_Name2 Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>1.9,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSheet1_Name2</Name>
              <Page isRef="17" />
              <Parent isRef="23" />
              <Text>{Sheet1.Name}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSheet1_Name2>
            <DataSheet1_isParent2 Ref="26" type="CheckBox" isKey="true">
              <Brush>Transparent</Brush>
              <Checked>{Sheet1.isParent}</Checked>
              <ClientRectangle>3.8,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <ContourColor>Black</ContourColor>
              <Name>DataSheet1_isParent2</Name>
              <Page isRef="17" />
              <Parent isRef="23" />
              <TextBrush>Black</TextBrush>
            </DataSheet1_isParent2>
            <DataSheet1_Parent Ref="27" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>5.7,0,2,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataSheet1_Parent</Name>
              <Page isRef="17" />
              <Parent isRef="23" />
              <Text>{Sheet1.Parent}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataSheet1_Parent>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Sheet1</DataSourceName>
          <Filters isList="true" count="1">
            <value>_x007B_Sheet1.Parent_x0020__x003D__x003D__x0020_this_x005B__x0022_Parent_x0022__x005D_.ToString_x0028__x0029__x007D_</value>
          </Filters>
          <Name>DataSheet12</Name>
          <Page isRef="17" />
          <Parent isRef="17" />
          <Sort isList="true" count="0" />
        </DataSheet12>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>115c297699354b3282487c51eef52b95</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>subReport_1</Name>
      <PageHeight>11.69</PageHeight>
      <PageWidth>8.48</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>
    </subReport_1>
  </Pages>
  <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>8/2/2018 5:05:47 PM</ReportChanged>
  <ReportCreated>8/2/2018 4:53:26 PM</ReportCreated>
  <ReportFile>C:\Users\vinee\Desktop\Sti Test\Databand same filter twice\Report.mrt</ReportFile>
  <ReportGuid>f1295754c704436094e118955b71ae71</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2018.2.3.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>