﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.0" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <Databases isList="true" count="0" />
    <DataSources isList="true" count="9">
      <Categories Ref="2" 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>
        <DataName>Demo.Categories</DataName>
        <Dictionary isRef="1" />
        <Name>Categories</Name>
      </Categories>
      <Customers Ref="3" 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>
        <DataName>Demo.Customers</DataName>
        <Dictionary isRef="1" />
        <Name>Customers</Name>
      </Customers>
      <Employees Ref="4" 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>
        <DataName>Demo.Employees</DataName>
        <Dictionary isRef="1" />
        <Name>Employees</Name>
      </Employees>
      <Order_x0020_Details Ref="5" 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>
        <DataName>Demo.Order Details</DataName>
        <Dictionary isRef="1" />
        <Name>Order Details</Name>
      </Order_x0020_Details>
      <Orders Ref="6" 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>
        <DataName>Demo.Orders</DataName>
        <Dictionary isRef="1" />
        <Name>Orders</Name>
      </Orders>
      <Products Ref="7" 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>
        <DataName>Demo.Products</DataName>
        <Dictionary isRef="1" />
        <Name>Products</Name>
      </Products>
      <Shippers Ref="8" 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>
        <DataName>Demo.Shippers</DataName>
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
      </Shippers>
      <Suppliers Ref="9" 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>
        <DataName>Demo.Suppliers</DataName>
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
      </Suppliers>
      <Countries Ref="10" 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>
        <DataName>Demo.Countries</DataName>
        <Dictionary isRef="1" />
        <Name>Countries</Name>
      </Countries>
    </DataSources>
    <Relations isList="true" count="8">
      <Employees Ref="11" type="DataRelation" isKey="true">
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>ReportsTo</value>
        </ChildColumns>
        <ChildSource isRef="4" />
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <ParentColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ParentColumns>
        <ParentSource isRef="4" />
        <RelationName>EmployeesEmployees</RelationName>
      </Employees>
      <Products Ref="12" type="DataRelation" isKey="true">
        <Alias>Products</Alias>
        <ChildColumns isList="true" count="1">
          <value>ProductID</value>
        </ChildColumns>
        <ChildSource isRef="5" />
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <ParentColumns isList="true" count="1">
          <value>ProductID</value>
        </ParentColumns>
        <ParentSource isRef="7" />
        <RelationName>ProductsOrder_Details</RelationName>
      </Products>
      <Orders Ref="13" type="DataRelation" isKey="true">
        <Alias>Orders</Alias>
        <ChildColumns isList="true" count="1">
          <value>OrderID</value>
        </ChildColumns>
        <ChildSource isRef="5" />
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <ParentColumns isList="true" count="1">
          <value>OrderID</value>
        </ParentColumns>
        <ParentSource isRef="6" />
        <RelationName>OrdersOrder_Details</RelationName>
      </Orders>
      <Customers Ref="14" type="DataRelation" isKey="true">
        <Alias>Customers</Alias>
        <ChildColumns isList="true" count="1">
          <value>CustomerID</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <Dictionary isRef="1" />
        <Name>Customers</Name>
        <ParentColumns isList="true" count="1">
          <value>CustomerID</value>
        </ParentColumns>
        <ParentSource isRef="3" />
        <RelationName>CustomersOrders</RelationName>
      </Customers>
      <Shippers Ref="15" type="DataRelation" isKey="true">
        <Alias>Shippers</Alias>
        <ChildColumns isList="true" count="1">
          <value>ShipVia</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
        <ParentColumns isList="true" count="1">
          <value>ShipperID</value>
        </ParentColumns>
        <ParentSource isRef="8" />
        <RelationName>ShippersOrders</RelationName>
      </Shippers>
      <Employees Ref="16" type="DataRelation" isKey="true">
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <ParentColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ParentColumns>
        <ParentSource isRef="4" />
        <RelationName>EmployeesOrders</RelationName>
      </Employees>
      <Categories Ref="17" type="DataRelation" isKey="true">
        <Alias>Categories</Alias>
        <ChildColumns isList="true" count="1">
          <value>CategoryID</value>
        </ChildColumns>
        <ChildSource isRef="7" />
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <ParentColumns isList="true" count="1">
          <value>CategoryID</value>
        </ParentColumns>
        <ParentSource isRef="2" />
        <RelationName>CategoriesProducts</RelationName>
      </Categories>
      <Suppliers Ref="18" type="DataRelation" isKey="true">
        <Alias>Suppliers</Alias>
        <ChildColumns isList="true" count="1">
          <value>SupplierID</value>
        </ChildColumns>
        <ChildSource isRef="7" />
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
        <ParentColumns isList="true" count="1">
          <value>SupplierID</value>
        </ParentColumns>
        <ParentSource isRef="9" />
        <RelationName>SuppliersProducts</RelationName>
      </Suppliers>
    </Relations>
    <Report isRef="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <GlobalizationStrings isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="19" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="4">
        <GroupHeader1 Ref="20" type="GroupHeaderBand" isKey="true">
          <Border>Top, Left, Right;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.49,0.3</ClientRectangle>
          <Components isList="true" count="1">
            <Text1 Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,3.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,22,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="19" />
              <Parent isRef="20" />
              <Text>{Categories.CategoryName.Substring(0,1)}</Text>
              <TextBrush>Chocolate</TextBrush>
              <TextFormat Ref="22" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </Text1>
          </Components>
          <Condition>{Categories.CategoryName.Substring(0,1)}</Condition>
          <Conditions isList="true" count="0" />
          <Dock>Top</Dock>
          <Name>GroupHeader1</Name>
          <Page isRef="19" />
          <Parent isRef="19" />
        </GroupHeader1>
        <DataCategories Ref="23" type="DataBand" isKey="true">
          <Border>Left, Right;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.9,7.49,0.3</ClientRectangle>
          <Components isList="true" count="2">
            <DataCategories_CategoryID Ref="24" type="Text" isKey="true">
              <Border>None;Transparent;1;Solid;False;4;Black</Border>
              <Brush>Gold</Brush>
              <ClientRectangle>0.6,0,0.6,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_CategoryID</Name>
              <Page isRef="19" />
              <Parent isRef="23" />
              <Text>{Categories.CategoryID}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="25" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </DataCategories_CategoryID>
            <DataCategories_CategoryName Ref="26" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.2,0,3.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_CategoryName</Name>
              <Page isRef="19" />
              <Parent isRef="23" />
              <Text>{Categories.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="27" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </DataCategories_CategoryName>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName />
          <DataSourceName>Categories</DataSourceName>
          <Dock>Top</Dock>
          <Filters isList="true" count="0" />
          <Name>DataCategories</Name>
          <Page isRef="19" />
          <Parent isRef="19" />
          <Sort isList="true" count="2">
            <value>ASC</value>
            <value>CategoryName</value>
          </Sort>
        </DataCategories>
        <GroupFooter1 Ref="28" type="GroupFooterBand" isKey="true">
          <Border>Left, Right, Bottom;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.6,7.49,0.6</ClientRectangle>
          <Components isList="true" count="2">
            <Text2 Ref="29" type="Text" isKey="true">
              <Brush>Gold</Brush>
              <ClientRectangle>0.6,0,3.1,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,18</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="19" />
              <Parent isRef="28" />
              <Text>{Count()}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="30" type="GeneralFormat" isKey="true" />
            </Text2>
            <Text3 Ref="31" type="Text" isKey="true">
              <Brush>DarkSalmon</Brush>
              <ClientRectangle>1.2,0.3,3.1,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,18</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="19" />
              <Parent isRef="28" />
              <Text>{Count(DataCategories:DataProducts)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="32" type="GeneralFormat" isKey="true" />
            </Text3>
          </Components>
          <Conditions isList="true" count="0" />
          <Dock>Top</Dock>
          <Name>GroupFooter1</Name>
          <Page isRef="19" />
          <Parent isRef="19" />
        </GroupFooter1>
        <DataProducts Ref="33" type="DataBand" isKey="true">
          <Border>Left, Right;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,2.6,7.49,0.4</ClientRectangle>
          <Components isList="true" count="3">
            <DataProducts_ProductID Ref="34" type="Text" isKey="true">
              <Brush>DarkSalmon</Brush>
              <ClientRectangle>1.2,0,0.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ProductID</Name>
              <Page isRef="19" />
              <Parent isRef="33" />
              <Text>{Products.ProductID}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="35" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductID>
            <DataProducts_ProductName Ref="36" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2,0,3.9,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ProductName</Name>
              <Page isRef="19" />
              <Parent isRef="33" />
              <Text>{Products.ProductName}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="37" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductName>
            <Text4 Ref="38" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.9,0,0.3,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,16,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="19" />
              <Parent isRef="33" />
              <Text>{Line}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="39" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </Text4>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>CategoriesProducts</DataRelationName>
          <DataSourceName>Products</DataSourceName>
          <Dock>Top</Dock>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="23" />
          <Name>DataProducts</Name>
          <Page isRef="19" />
          <Parent isRef="19" />
          <Sort isList="true" count="0" />
        </DataProducts>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>43165e9e7e0f4c15aa60b95164ef12c4</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <Page isRef="19" />
      <PageHeight>11.69</PageHeight>
      <PageWidth>8.27</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="40" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="41" 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/31/2007 4:38:35 PM</ReportChanged>
  <ReportCreated>8/31/2007 3:57:01 PM</ReportCreated>
  <ReportGuid>4c0fc92b8fbb4f0c9a7da3d39c5aef6f</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2007.1</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.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>