﻿<?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">
      <Demo Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
        <Alias>Demo</Alias>
        <Name>Demo</Name>
        <PathData>D:\Demo.xml</PathData>
        <PathSchema>D:\Demo.xsd</PathSchema>
      </Demo>
    </Databases>
    <DataSources isList="true" count="9">
      <Categories Ref="3" type="DataTableSource" isKey="true">
        <Alias>Categories</Alias>
        <Columns isList="true" count="3">
          <value>CategoryID,System.Int32</value>
          <value>CategoryName,System.String</value>
          <value>Description,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>Demo.Categories</NameInSource>
      </Categories>
      <Customers Ref="4" type="DataTableSource" isKey="true">
        <Alias>Customers</Alias>
        <Columns isList="true" count="11">
          <value>CustomerID,System.String</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>Phone,System.String</value>
          <value>Fax,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Customers</Name>
        <NameInSource>Demo.Customers</NameInSource>
      </Customers>
      <Employees Ref="5" type="DataTableSource" isKey="true">
        <Alias>Employees</Alias>
        <Columns isList="true" count="14">
          <value>EmployeeID,System.Int32</value>
          <value>LastName,System.String</value>
          <value>FirstName,System.String</value>
          <value>Title,System.String</value>
          <value>BirthDate,System.DateTime</value>
          <value>HireDate,System.DateTime</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>HomePhone,System.String</value>
          <value>Notes,System.String</value>
          <value>ReportsTo,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>Demo.Employees</NameInSource>
      </Employees>
      <Order_x0020_Details Ref="6" type="DataTableSource" isKey="true">
        <Alias>Order Details</Alias>
        <Columns isList="true" count="5">
          <value>OrderID,System.Int32</value>
          <value>ProductID,System.Int32</value>
          <value>UnitPrice,System.Decimal</value>
          <value>Quantity,System.Int16</value>
          <value>Discount,System.Single</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Order Details</Name>
        <NameInSource>Demo.Order Details</NameInSource>
      </Order_x0020_Details>
      <Orders Ref="7" type="DataTableSource" isKey="true">
        <Alias>Orders</Alias>
        <Columns isList="true" count="14">
          <value>OrderID,System.Int32</value>
          <value>CustomerID,System.String</value>
          <value>EmployeeID,System.Int32</value>
          <value>OrderDate,System.DateTime</value>
          <value>RequiredDate,System.DateTime</value>
          <value>ShippedDate,System.DateTime</value>
          <value>ShipVia,System.Int32</value>
          <value>Freight,System.Decimal</value>
          <value>ShipName,System.String</value>
          <value>ShipAddress,System.String</value>
          <value>ShipCity,System.String</value>
          <value>ShipRegion,System.String</value>
          <value>ShipPostalCode,System.String</value>
          <value>ShipCountry,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <NameInSource>Demo.Orders</NameInSource>
      </Orders>
      <Products Ref="8" type="DataTableSource" isKey="true">
        <Alias>Products</Alias>
        <Columns isList="true" count="7">
          <value>ProductID,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>SupplierID,System.Int32</value>
          <value>CategoryID,System.Int32</value>
          <value>QuantityPerUnit,System.String</value>
          <value>UnitPrice,System.Decimal</value>
          <value>UnitsInStock,System.Int16</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>Demo.Products</NameInSource>
      </Products>
      <Shippers Ref="9" type="DataTableSource" isKey="true">
        <Alias>Shippers</Alias>
        <Columns isList="true" count="3">
          <value>ShipperID,System.Int32</value>
          <value>CompanyName,System.String</value>
          <value>Phone,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
        <NameInSource>Demo.Shippers</NameInSource>
      </Shippers>
      <Suppliers Ref="10" type="DataTableSource" isKey="true">
        <Alias>Suppliers</Alias>
        <Columns isList="true" count="12">
          <value>SupplierID,System.Int32</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>Phone,System.String</value>
          <value>Fax,System.String</value>
          <value>HomePage,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
        <NameInSource>Demo.Suppliers</NameInSource>
      </Suppliers>
      <Countries Ref="11" type="DataTableSource" isKey="true">
        <Alias>Countries</Alias>
        <Columns isList="true" count="3">
          <value>CountriesID,System.Int32</value>
          <value>Flag,System.Byte[]</value>
          <value>CountryName,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Countries</Name>
        <NameInSource>Demo.Countries</NameInSource>
      </Countries>
    </DataSources>
    <Relations isList="true" count="8">
      <Employees Ref="12" type="DataRelation" isKey="true">
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>ReportsTo</value>
        </ChildColumns>
        <ChildSource isRef="5" />
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>EmployeesEmployees</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ParentColumns>
        <ParentSource isRef="5" />
      </Employees>
      <Products Ref="13" type="DataRelation" isKey="true">
        <Alias>Products</Alias>
        <ChildColumns isList="true" count="1">
          <value>ProductID</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>ProductsOrder_Details</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ProductID</value>
        </ParentColumns>
        <ParentSource isRef="8" />
      </Products>
      <Orders Ref="14" type="DataRelation" isKey="true">
        <Alias>Orders</Alias>
        <ChildColumns isList="true" count="1">
          <value>OrderID</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <NameInSource>OrdersOrder_Details</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>OrderID</value>
        </ParentColumns>
        <ParentSource isRef="7" />
      </Orders>
      <Customers Ref="15" type="DataRelation" isKey="true">
        <Alias>Customers</Alias>
        <ChildColumns isList="true" count="1">
          <value>CustomerID</value>
        </ChildColumns>
        <ChildSource isRef="7" />
        <Dictionary isRef="1" />
        <Name>Customers</Name>
        <NameInSource>CustomersOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CustomerID</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Customers>
      <Shippers Ref="16" type="DataRelation" isKey="true">
        <Alias>Shippers</Alias>
        <ChildColumns isList="true" count="1">
          <value>ShipVia</value>
        </ChildColumns>
        <ChildSource isRef="7" />
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
        <NameInSource>ShippersOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ShipperID</value>
        </ParentColumns>
        <ParentSource isRef="9" />
      </Shippers>
      <Employees Ref="17" type="DataRelation" isKey="true">
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ChildColumns>
        <ChildSource isRef="7" />
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>EmployeesOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ParentColumns>
        <ParentSource isRef="5" />
      </Employees>
      <Categories Ref="18" type="DataRelation" isKey="true">
        <Alias>Categories</Alias>
        <ChildColumns isList="true" count="1">
          <value>CategoryID</value>
        </ChildColumns>
        <ChildSource isRef="8" />
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>CategoriesProducts</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CategoryID</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </Categories>
      <Suppliers Ref="19" type="DataRelation" isKey="true">
        <Alias>Suppliers</Alias>
        <ChildColumns isList="true" count="1">
          <value>SupplierID</value>
        </ChildColumns>
        <ChildSource isRef="8" />
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
        <NameInSource>SuppliersProducts</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>SupplierID</value>
        </ParentColumns>
        <ParentSource isRef="10" />
      </Suppliers>
    </Relations>
    <Report isRef="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <NumberOfPass>DoublePass</NumberOfPass>
  <Pages isList="true" count="2">
    <Page1 Ref="20" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataCategories Ref="21" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <DataCategories_CategoryName Ref="22" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,7,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_CategoryName</Name>
              <Page isRef="20" />
              <Parent isRef="21" />
              <Text>{Categories.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataCategories_CategoryName>
            <Text11 Ref="23" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9,0,4.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>a15efc6c08374e6093677b7abbfe835a</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text11</Name>
              <Page isRef="20" />
              <Parent isRef="21" />
              <Tag>{Categories.CategoryName}</Tag>
              <Text>{GetAnchorPageNumber(sender.TagValue)}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text11>
            <Text12 Ref="24" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>13.6,0,5.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>31746c0fafa349b083605e4aca52a495</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text12</Name>
              <Page isRef="20" />
              <Parent isRef="21" />
              <Tag>{Categories.CategoryName}</Tag>
              <Text>{startPages[Categories.CategoryName]} - {endPages[Categories.CategoryName]}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text12>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Categories</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataCategories</Name>
          <Page isRef="20" />
          <Parent isRef="20" />
          <Sort isList="true" count="2">
            <value>ASC</value>
            <value>CategoryName</value>
          </Sort>
        </DataCategories>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>131bba71a41a4589a2fe38c07daaa5be</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>10</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="25" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
    <Page2 Ref="26" type="Page" isKey="true">
      <AfterPrintEvent>if (Categories.IsEof)
	endPages[Categories.CategoryName] = PageNumber;</AfterPrintEvent>
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="4">
        <PageFooterBand2 Ref="27" type="PageFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,27.3,19,0.4</ClientRectangle>
          <Components isList="true" count="1">
            <Text5 Ref="28" type="Text" isKey="true">
              <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>6.8,0,12.2,0.4</ClientRectangle>
              <ComponentStyle>Footer1</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>9c24b50b0b314dcbbe182ef15e27678f</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="26" />
              <Parent isRef="27" />
              <Text>{PageNofM}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text5>
          </Components>
          <Conditions isList="true" count="0" />
          <Guid>992471c4985549768134328cecc79f2d</Guid>
          <Name>PageFooterBand2</Name>
          <Page isRef="26" />
          <Parent isRef="26" />
        </PageFooterBand2>
        <DataBand1 Ref="29" type="DataBand" isKey="true">
          <AfterPrintEvent>AddAnchor(Categories.CategoryName);

if (isFirst)
{
	prevCategory = Categories.CategoryName;
	isFirst = false;
}

if (!startPages.ContainsKey(Categories.CategoryName))
{
	startPages[Categories.CategoryName] = PageNumber;
	endPages[prevCategory] = PageNumber - 1;
	prevCategory = Categories.CategoryName;
}
</AfterPrintEvent>
          <BeforePrintEvent>
</BeforePrintEvent>
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>[255:192:0]</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,2.2</ClientRectangle>
          <Components isList="true" count="3">
            <Text7 Ref="30" type="Text" isKey="true">
              <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>3.2,0.2,12.2,0.6</ClientRectangle>
              <ComponentStyle>Header2</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <Guid>59e8adae0d9c4add99207480b3ccf212</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="26" />
              <Parent isRef="29" />
              <Text>{Categories.CategoryName}</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text7>
            <Text10 Ref="31" type="Text" isKey="true">
              <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>3.2,0.8,12.2,0.8</ClientRectangle>
              <ComponentStyle>Data1</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>dad5c2f8e43a47ffa717eff23e184e02</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text10</Name>
              <Page isRef="26" />
              <Parent isRef="29" />
              <Text>{Categories.Description}</Text>
              <TextBrush>[102:77:38]</TextBrush>
            </Text10>
            <Image1 Ref="32" type="Image" isKey="true">
              <AspectRatio>True</AspectRatio>
              <Border>None;[183:117:64];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,0.2,2.8,1.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DataColumn>Categories.Picture</DataColumn>
              <Guid>65f2e5f41b234fde9827df5751e5b0b8</Guid>
              <Name>Image1</Name>
              <Page isRef="26" />
              <Parent isRef="29" />
              <Stretch>True</Stretch>
            </Image1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>Categories</DataSourceName>
          <Filters isList="true" count="0" />
          <Guid>3d8614a8a1734d5ea773dfed07625f8a</Guid>
          <Name>DataBand1</Name>
          <NewPageBefore>True</NewPageBefore>
          <Page isRef="26" />
          <Parent isRef="26" />
          <Sort isList="true" count="2">
            <value>ASC</value>
            <value>CategoryName</value>
          </Sort>
        </DataBand1>
        <DataBand2 Ref="33" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,3.4,19,1.8</ClientRectangle>
          <Components isList="true" count="7">
            <Text1 Ref="34" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>0,0,19,1.2</ClientRectangle>
              <ComponentStyle>Header3</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>af1255468f2c4b6899e1182f48d6725e</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="26" />
              <Parent isRef="33" />
              <Text>{Products.ProductName}</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <Type>DataColumn</Type>
              <VertAlignment>Center</VertAlignment>
            </Text1>
            <Text15 Ref="35" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>12.4,1.2,2.2,0.6</ClientRectangle>
              <ComponentStyle>Header3</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>acd64759bbf444ce8cec90773329b6d3</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text15</Name>
              <Page isRef="26" />
              <Parent isRef="33" />
              <Text>Price</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text15>
            <Text16 Ref="36" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>14.6,1.2,2.2,0.6</ClientRectangle>
              <ComponentStyle>Header3</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>d6c7ea1597b14787ae95c8e2fc3c7405</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text16</Name>
              <Page isRef="26" />
              <Parent isRef="33" />
              <Text>Quantity</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text16>
            <Text19 Ref="37" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>16.8,1.2,2.2,0.6</ClientRectangle>
              <ComponentStyle>Header3</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>6c83d25a41e7451b8f92e0a7a9472eeb</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text19</Name>
              <Page isRef="26" />
              <Parent isRef="33" />
              <Text>Discount</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text19>
            <Text20 Ref="38" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>2.4,1.2,5,0.6</ClientRectangle>
              <ComponentStyle>Header3</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>19cb0151c5e74cd4ab105acf794553b5</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text20</Name>
              <Page isRef="26" />
              <Parent isRef="33" />
              <Text>Company</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text20>
            <Text21 Ref="39" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>7.4,1.2,5,0.6</ClientRectangle>
              <ComponentStyle>Header3</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>89c8a90ee09e4cb9a81bab4f743dd81d</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text21</Name>
              <Page isRef="26" />
              <Parent isRef="33" />
              <Text>Employee</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text21>
            <Text22 Ref="40" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>0,1.2,2.4,0.6</ClientRectangle>
              <ComponentStyle>Header3</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>3c18c29145454fe089634eda5484b870</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text22</Name>
              <Page isRef="26" />
              <Parent isRef="33" />
              <Text>Date</Text>
              <TextBrush>[193:152:89]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text22>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>CategoriesProducts</DataRelationName>
          <DataSourceName>Products</DataSourceName>
          <Filters isList="true" count="0" />
          <Guid>dab3ae49b8ef42949b0fcc1400748f4b</Guid>
          <MasterComponent isRef="29" />
          <Name>DataBand2</Name>
          <Page isRef="26" />
          <Parent isRef="26" />
          <PrintOnAllPages>True</PrintOnAllPages>
          <Sort isList="true" count="2">
            <value>ASC</value>
            <value>ProductName</value>
          </Sort>
        </DataBand2>
        <DataBand3 Ref="41" type="DataBand" isKey="true">
          <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,6,19,0.6</ClientRectangle>
          <Components isList="true" count="6">
            <Text2 Ref="42" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>12.4,0,2.2,0.6</ClientRectangle>
              <ComponentStyle>Data1</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>13491c12967b4331b94cb3302a7c4e87</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="26" />
              <Parent isRef="41" />
              <Text>{Order_Details.UnitPrice}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <TextFormat Ref="43" type="CurrencyFormat" isKey="true">
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>0</NegativePattern>
                <PositivePattern>0</PositivePattern>
              </TextFormat>
              <VertAlignment>Center</VertAlignment>
            </Text2>
            <Text3 Ref="44" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>14.6,0,2.2,0.6</ClientRectangle>
              <ComponentStyle>Data1</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>09f4c0a95b9b4f3ea6e9cfd3b15dc19d</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="26" />
              <Parent isRef="41" />
              <Text>{Order_Details.Quantity}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <TextFormat Ref="45" type="NumberFormat" isKey="true">
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
              </TextFormat>
              <VertAlignment>Center</VertAlignment>
            </Text3>
            <Text8 Ref="46" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>2.4,0,5,0.6</ClientRectangle>
              <ComponentStyle>Data1</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>76190a47c1ea4e59aae34df4b1042eef</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="26" />
              <Parent isRef="41" />
              <Text>{Order_Details.Orders.Customers.CompanyName}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text8>
            <Text9 Ref="47" type="Text" isKey="true">
              <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>7.4,0,5,0.6</ClientRectangle>
              <ComponentStyle>Data1</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>c87c8aa7ddd145019f6c686f4cd33654</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text9</Name>
              <Page isRef="26" />
              <Parent isRef="41" />
              <Text>{Order_Details.Orders.Employees.LastName} {Order_Details.Orders.Employees.FirstName}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text9>
            <Text6 Ref="48" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.4,0.6</ClientRectangle>
              <ComponentStyle>Data1</ComponentStyle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>97399a38394c40ff8005bb2b3d7ea0d6</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="26" />
              <Parent isRef="41" />
              <Text>{Order_Details.Orders.OrderDate}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <TextFormat Ref="49" type="DateFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </Text6>
            <Text4 Ref="50" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>16.8,0,2.2,0.6</ClientRectangle>
              <ComponentStyle>Data1</ComponentStyle>
              <Conditions isList="true" count="1">
                <value>DataBar,Order_Details.Discount,Solid,BurlyWood,Green,False,DarkGreen,DarkRed,Default,Auto,0,Auto,1</value>
              </Conditions>
              <Font>Arial,9</Font>
              <Guid>5d59f91e4fcd4d7c85c98865da72b5a5</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="26" />
              <Parent isRef="41" />
              <Text>{Order_Details.Discount}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <TextFormat Ref="51" type="PercentageFormat" isKey="true">
                <DecimalSeparator>,</DecimalSeparator>
                <GroupSeparator> </GroupSeparator>
                <NegativePattern>0</NegativePattern>
                <PositivePattern>1</PositivePattern>
                <Symbol>%</Symbol>
              </TextFormat>
              <VertAlignment>Center</VertAlignment>
            </Text4>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>ProductsOrder_Details</DataRelationName>
          <DataSourceName>Order Details</DataSourceName>
          <EvenStyle>Data2</EvenStyle>
          <Filters isList="true" count="0" />
          <Guid>52dfd42e7fd549259b71c6679fcdedb8</Guid>
          <MasterComponent isRef="33" />
          <Name>DataBand3</Name>
          <Page isRef="26" />
          <Parent isRef="26" />
          <Sort isList="true" count="4">
            <value>ASC</value>
            <value>OrdersOrder_Details</value>
            <value>CustomersOrders</value>
            <value>CompanyName</value>
          </Sort>
        </DataBand3>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>68528ab825144ffeb502aebf3886d0b0</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page2</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="52" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page2>
  </Pages>
  <PrinterSettings Ref="53" 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.Base.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>Master-Detail-Subdetail</ReportAlias>
  <ReportAuthor>Stimulsoft</ReportAuthor>
  <ReportChanged>8/15/2013 4:22:42 PM</ReportChanged>
  <ReportCreated>5/29/2004 10:59:00 AM</ReportCreated>
  <ReportDescription>This sample demonstrates how to create a Master-Detail-Subdetail report.</ReportDescription>
  <ReportFile>E:\TOC.mrt</ReportFile>
  <ReportGuid>c5b3494700734cb7a0c5d5e5a82e4023</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2013.2.1614</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Report;
using Stimulsoft.Report.Components;
using Stimulsoft.Base.Drawing;
using System.Collections;

namespace StiReports
{
    
    public class Report : Stimulsoft.Report.StiReport
    {
        private Hashtable startPages = new Hashtable();
		private Hashtable endPages = new Hashtable();
		private string prevCategory = "";
		private bool isFirst = true;
		
        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="10">
    <Title1 Ref="54" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,19</Font>
      <HorAlignment>Right</HorAlignment>
      <Name>Title1</Name>
      <TextBrush>[193:152:89]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Title1>
    <Title2 Ref="55" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>None;[102:77:38];1;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,9</Font>
      <Name>Title2</Name>
      <TextBrush>[102:77:38]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Title2>
    <Header1 Ref="56" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,19</Font>
      <Name>Header1</Name>
      <TextBrush>[193:152:89]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Header1>
    <Header2 Ref="57" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,12,Bold</Font>
      <HorAlignment>Center</HorAlignment>
      <Name>Header2</Name>
      <TextBrush>[193:152:89]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Header2>
    <Header3 Ref="58" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>[242:234:221]</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,9,Bold</Font>
      <HorAlignment>Center</HorAlignment>
      <Name>Header3</Name>
      <TextBrush>[193:152:89]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Header3>
    <Data1 Ref="59" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,9</Font>
      <Name>Data1</Name>
      <TextBrush>[102:77:38]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Data1>
    <Data2 Ref="60" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderFormatting>False</AllowUseBorderFormatting>
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <AllowUseFont>False</AllowUseFont>
      <AllowUseTextBrush>False</AllowUseTextBrush>
      <AllowUseTextOptions>False</AllowUseTextOptions>
      <Brush>[240:237:232]</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,9</Font>
      <Name>Data2</Name>
      <TextBrush>Black</TextBrush>
    </Data2>
    <Data3 Ref="61" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>[240:237:232]</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,9</Font>
      <Name>Data3</Name>
      <TextBrush>[102:77:38]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Data3>
    <Footer1 Ref="62" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>Top;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,9</Font>
      <Name>Footer1</Name>
      <TextBrush>[102:77:38]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Footer1>
    <Footer2 Ref="63" type="Stimulsoft.Report.StiStyle" isKey="true">
      <AllowUseBorderSides>False</AllowUseBorderSides>
      <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Conditions isList="true" count="0" />
      <Description />
      <Font>Arial,12,Bold</Font>
      <HorAlignment>Right</HorAlignment>
      <Name>Footer2</Name>
      <TextBrush>[193:152:89]</TextBrush>
      <VertAlignment>Center</VertAlignment>
    </Footer2>
  </Styles>
</StiSerializer>