﻿<?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">
      <CatalogStudio Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>CatalogStudio</Alias>
        <ConnectionStringEncrypted>9HDPoUZR04VsXKG94XyiF99W+4hMUJPNb3i58Hlc9jvUfPfP708xpOJm2cxj7KRe31rZaMVcc8XiGXls5EyxL4vEd4NIWcLBa1/5hA==</ConnectionStringEncrypted>
        <Name>CatalogStudio</Name>
      </CatalogStudio>
    </Databases>
    <DataSources isList="true" count="6">
      <Categories Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Categories</Alias>
        <Columns isList="true" count="4">
          <value>CategoryID,System.Int64</value>
          <value>CategoryName,System.String</value>
          <value>Description,System.String</value>
          <value>Picture,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>Categories</Name>
        <NameInSource>CatalogStudio</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from Categories</SqlCommand>
      </Categories>
      <Customers Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Customers</Alias>
        <Columns isList="true" count="12">
          <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>
          <value>Bool,System.Boolean</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>Customers</Name>
        <NameInSource>CatalogStudio</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from Customers</SqlCommand>
      </Customers>
      <Employees Ref="5" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Employees</Alias>
        <Columns isList="true" count="18">
          <value>EmployeeID,System.Int64</value>
          <value>LastName,System.String</value>
          <value>FirstName,System.String</value>
          <value>Title,System.String</value>
          <value>TitleOfCourtesy,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>Extension,System.String</value>
          <value>Photo,System.String</value>
          <value>Notes,System.String</value>
          <value>ReportsTo,System.Int64</value>
          <value>PhotoPath,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>Employees</Name>
        <NameInSource>CatalogStudio</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from Employees</SqlCommand>
      </Employees>
      <Order_x0020_Details Ref="6" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Order Details</Alias>
        <Columns isList="true" count="5">
          <value>OrderID,System.Int32</value>
          <value>ProductID,System.Int64</value>
          <value>UnitPrice,System.Decimal</value>
          <value>Quantity,System.Int64</value>
          <value>Discount,System.Double</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>Order Details</Name>
        <NameInSource>CatalogStudio</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select top(10)* from [Order Details]</SqlCommand>
      </Order_x0020_Details>
      <Orders Ref="7" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Orders</Alias>
        <Columns isList="true" count="14">
          <value>OrderID,System.Int32</value>
          <value>CustomerID,System.String</value>
          <value>EmployeeID,System.Int64</value>
          <value>OrderDate,System.DateTime</value>
          <value>RequiredDate,System.DateTime</value>
          <value>ShippedDate,System.DateTime</value>
          <value>ShipVia,System.Int64</value>
          <value>Freight,System.Decimal</value>
          <value>ShipName,System.String</value>
          <value>ShipAddress,System.String</value>
          <value>ShipCity,System.String</value>
          <value>ShipPostalCode,System.String</value>
          <value>ShipRegion,System.String</value>
          <value>ShipCountry,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>Orders</Name>
        <NameInSource>CatalogStudio</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select top(10)* from Orders</SqlCommand>
      </Orders>
      <Products Ref="8" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Products</Alias>
        <Columns isList="true" count="11">
          <value>ProductID,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>Discontinued,System.Boolean</value>
          <value>Picture1,System.String</value>
          <value>SupplierID,System.Int64</value>
          <value>CategoryID,System.Int64</value>
          <value>QuantityPerUnit,System.String</value>
          <value>UnitPrice,System.Decimal</value>
          <value>UnitsInStock,System.Int64</value>
          <value>UnitsOnOrder,System.Int64</value>
          <value>ReorderLevel,System.Int64</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>Products</Name>
        <NameInSource>CatalogStudio</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select top(10) * from Products</SqlCommand>
      </Products>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="3">
      <value>,AttachmentPath,AttachmentPath,System.String,Y:_x005C__x005C_,False,False</value>
      <value>,PrevCatID,PrevCatID,System.Int32,,False,False</value>
      <value>,PrevProdID,PrevProdID,System.Int32,,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <Catalog Ref="9" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Columns>1</Columns>
      <Components isList="true" count="4">
        <Text45 Ref="10" type="Text" isKey="true">
          <BeforePrintEvent>Text45.Enabled=true;
if(PageNumber%2==0)
Text45.Enabled=false;</BeforePrintEvent>
          <Brush>Transparent</Brush>
          <ClientRectangle>-0.4,9.8,0.3,0.4</ClientRectangle>
          <Conditions isList="true" count="0" />
          <Font>Arial,10,Bold</Font>
          <Guid>f82682fad06b4d508d3eb6bbe27606d0</Guid>
          <HorAlignment>Center</HorAlignment>
          <Margins>0,0,0,0</Margins>
          <Name>Text45</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
          <Text>{PageNumber}</Text>
          <TextBrush>Black</TextBrush>
          <Type>SystemVariables</Type>
          <VertAlignment>Center</VertAlignment>
        </Text45>
        <Text6 Ref="11" type="Text" isKey="true">
          <BeforePrintEvent>Text6.Enabled=true;
if(PageNumber%2==1)
Text6.Enabled=false;</BeforePrintEvent>
          <Brush>Transparent</Brush>
          <ClientRectangle>7.6,9.8,0.3,0.4</ClientRectangle>
          <Conditions isList="true" count="0" />
          <Font>Arial,10,Bold</Font>
          <Guid>bdd435e8232f492186011bd7be345bde</Guid>
          <HorAlignment>Center</HorAlignment>
          <Margins>0,0,0,0</Margins>
          <Name>Text6</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
          <Text>{PageNumber}</Text>
          <TextBrush>Black</TextBrush>
          <Type>SystemVariables</Type>
          <VertAlignment>Center</VertAlignment>
        </Text6>
        <DataBand2 Ref="12" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.5,0.2</ClientRectangle>
          <Components isList="true" count="2">
            <Text1 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,6.4,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="9" />
              <Parent isRef="12" />
              <Text>ORDERS:{Orders.OrderID}....................................................................................................................................................................................</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text1>
            <textcategory Ref="14" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>6.4,0,1.02,0.24</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12</Font>
              <Guid>9e51c9e08f9c428a86a3456a737ce3ce</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>textcategory</Name>
              <Page isRef="9" />
              <Parent isRef="12" />
              <ProcessAt>EndOfReport</ProcessAt>
              <ProcessAtEnd>True</ProcessAtEnd>
              <Tag>{Orders.OrderID}</Tag>
              <Text>{CatPages[Int32.Parse(sender.TagValue.ToString())]}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </textcategory>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Orders</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand2</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
          <Sort isList="true" count="0" />
        </DataBand2>
        <DataBand1 Ref="15" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.8,7.5,0.2</ClientRectangle>
          <Components isList="true" count="2">
            <Text2 Ref="16" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.4,0,6,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="9" />
              <Parent isRef="15" />
              <Text>ORDER DETAILS:{Order_Details.UnitPrice}........................................................................................................................................</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text2>
            <Textprod Ref="17" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>6.4,0,1.02,0.16</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>e8fa1a284262410199cfd1e6bea8c63a</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Textprod</Name>
              <Page isRef="9" />
              <Parent isRef="15" />
              <ProcessAt>EndOfReport</ProcessAt>
              <ProcessAtEnd>True</ProcessAtEnd>
              <Tag>{Order_Details.OrderID}</Tag>
              <Text>{ProdPages[Int32.Parse(sender.TagValue.ToString())]}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Textprod>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Order Details</DataSourceName>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="12" />
          <Name>DataBand1</Name>
          <Page isRef="9" />
          <Parent isRef="9" />
          <Sort isList="true" count="0" />
        </DataBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>0573ac14c335442585acf7584c862263</Guid>
      <Margins>0.5,0.5,0.39,0.39</Margins>
      <Name>Catalog</Name>
      <PageHeight>11</PageHeight>
      <PageWidth>8.5</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="18" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Catalog>
    <Page1 Ref="19" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <DataBand3 Ref="20" type="DataBand" isKey="true">
          <AfterPrintEvent>if (PrevCatID &gt; 0 &amp;&amp; (PageNumber - (int)CatPages[PrevCatID])&gt;1)
{
	CatPages[PrevCatID] += "-"+(PageNumber-1);
}
CatPages[Orders.OrderID] = PageNumber;
PrevCatID =Orders.OrderID;</AfterPrintEvent>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.72,0.4</ClientRectangle>
          <Components isList="true" count="3">
            <Text3 Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0.2,1.7,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="19" />
              <Parent isRef="20" />
              <Text>{Orders.OrderID}</Text>
              <TextBrush>Black</TextBrush>
              <Type>DataColumn</Type>
            </Text3>
            <Text5 Ref="22" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.7,0.2,6,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="19" />
              <Parent isRef="20" />
              <Text>{Orders.OrderDate}</Text>
              <TextBrush>Black</TextBrush>
              <Type>DataColumn</Type>
            </Text5>
            <Text4 Ref="23" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,1.4,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="19" />
              <Parent isRef="20" />
              <Text>ORDERS</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text4>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Orders</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand3</Name>
          <Page isRef="19" />
          <Parent isRef="19" />
          <Sort isList="true" count="0" />
        </DataBand3>
        <DataBand4 Ref="24" type="DataBand" isKey="true">
          <AfterPrintEvent>if (PrevProdID &gt; 0 &amp;&amp; (PageNumber - (int)ProdPages[PrevProdID])&gt;1)
{
	ProdPages[PrevProdID] += "-"+(PageNumber-1);
}
ProdPages[Order_Details.OrderID] = PageNumber;
PrevProdID = Order_Details.OrderID;</AfterPrintEvent>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1,7.72,0.5</ClientRectangle>
          <Components isList="true" count="3">
            <Text7 Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.6,0.3,1.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="19" />
              <Parent isRef="24" />
              <Text>{Order_Details.OrderID}</Text>
              <TextBrush>Black</TextBrush>
              <Type>DataColumn</Type>
            </Text7>
            <Text8 Ref="26" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.5,0.3,5.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,11</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="19" />
              <Parent isRef="24" />
              <Text>{Order_Details.UnitPrice}</Text>
              <TextBrush>Black</TextBrush>
              <Type>DataColumn</Type>
            </Text8>
            <Text9 Ref="27" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.6,0,1.5,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <Guid>f9bb06386c924085bdc3e3008d8fc000</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text9</Name>
              <Page isRef="19" />
              <Parent isRef="24" />
              <Text>ORDERS DETAILS</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text9>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Order Details</DataSourceName>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="20" />
          <Name>DataBand4</Name>
          <Page isRef="19" />
          <Parent isRef="19" />
          <Sort isList="true" count="0" />
        </DataBand4>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>77af8ca7d63941e3924a8c43c581e0e2</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="28" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </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>
  <ReportCacheMode>Auto</ReportCacheMode>
  <ReportChanged>5/13/2015 1:26:37 PM</ReportChanged>
  <ReportCreated>5/4/2015 10:21:24 AM</ReportCreated>
  <ReportFile>D:\Darsana R\Projects\3M\TOC.mrt</ReportFile>
  <ReportGuid>4930fee450d44b35bdb8796524c8c87f</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2014.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;
using System.Collections;
namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }
		private Hashtable CatPages = new Hashtable();
		private Hashtable ProdPages = new Hashtable();

        #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>