﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.0" application="StiReport">
  <CacheAllData>True</CacheAllData>
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <Databases isList="true" count="0" />
    <DataSources isList="true" count="3">
      <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>
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>Demo.Categories</NameInSource>
      </Categories>
      <Products Ref="3" 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>
      <AveragePriceByCategory Ref="4" type="Stimulsoft.Report.Dictionary.StiVirtualSource" isKey="true">
        <Alias>AveragePriceByCategory</Alias>
        <Columns isList="true" count="2">
          <value>CategoryID,System.Int32</value>
          <value>UnitPriceAvg,System.Decimal</value>
        </Columns>
        <Dictionary isRef="1" />
        <Filters isList="true" count="0" />
        <GroupColumns isList="true" count="1">
          <value>CategoryID</value>
        </GroupColumns>
        <Name>AveragePriceByCategory</Name>
        <NameInSource>Products</NameInSource>
        <Results isList="true" count="3">
          <value>UnitPrice</value>
          <value>Avg</value>
          <value>UnitPriceAvg</value>
        </Results>
        <Sort isList="true" count="0" />
      </AveragePriceByCategory>
    </DataSources>
    <Relations isList="true" count="2">
      <CategoriesProducts Ref="5" type="DataRelation" isKey="true">
        <Alias>CategoriesProducts</Alias>
        <ChildColumns isList="true" count="1">
          <value>CategoryID</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>CategoriesProducts</Name>
        <NameInSource>CategoriesProducts</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CategoryID</value>
        </ParentColumns>
        <ParentSource isRef="2" />
      </CategoriesProducts>
      <CategoriesAverage Ref="6" type="DataRelation" isKey="true">
        <Alias>CategoriesAverage</Alias>
        <ChildColumns isList="true" count="1">
          <value>CategoryID</value>
        </ChildColumns>
        <ChildSource isRef="4" />
        <Dictionary isRef="1" />
        <Name>CategoriesAverage</Name>
        <NameInSource>CategoriesAverage</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CategoryID</value>
        </ParentColumns>
        <ParentSource isRef="2" />
      </CategoriesAverage>
    </Relations>
    <Report isRef="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <GlobalizationStrings isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="7" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="5">
        <GroupHeader1 Ref="8" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.49,0.3</ClientRectangle>
          <Components isList="true" count="2">
            <DataCategories_CategoryID Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,0.6,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_CategoryID</Name>
              <Page isRef="7" />
              <Parent isRef="8" />
              <Restrictions>All</Restrictions>
              <Text>{Categories.CategoryID}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="10" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </DataCategories_CategoryID>
            <DataCategories_CategoryName Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.6,0,4,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_CategoryName</Name>
              <Page isRef="7" />
              <Parent isRef="8" />
              <Restrictions>All</Restrictions>
              <Text>{Categories.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="12" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </DataCategories_CategoryName>
          </Components>
          <Condition>{Categories.CategoryID}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeader1</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <Restrictions>All</Restrictions>
          <StartNewPage>True</StartNewPage>
        </GroupHeader1>
        <DataCategories Ref="13" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.9,7.49,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <DataRelationName />
          <DataSourceName>Categories</DataSourceName>
          <Filters isList="true" count="0" />
          <KeepHeaderTogether>False</KeepHeaderTogether>
          <Name>DataCategories</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <Restrictions>All</Restrictions>
          <Sort isList="true" count="0" />
        </DataCategories>
        <GroupFooter1 Ref="14" type="GroupFooterBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.3,7.49,1.7</ClientRectangle>
          <Components isList="true" count="1">
            <Container1 Ref="15" type="Container" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.1,0.1,7.3,1.6</ClientRectangle>
              <Components isList="true" count="2">
                <Header1 Ref="16" type="HeaderBand" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.2,7.3,0.3</ClientRectangle>
                  <Components isList="true" count="1">
                    <Text1 Ref="17" type="Text" isKey="true">
                      <Brush>Transparent</Brush>
                      <ClientRectangle>0,0,7.3,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Dock>Fill</Dock>
                      <Font>Arial,20,Bold</Font>
                      <HorAlignment>Center</HorAlignment>
                      <LinesOfUnderline>None</LinesOfUnderline>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text1</Name>
                      <Page isRef="7" />
                      <Parent isRef="16" />
                      <Restrictions>All</Restrictions>
                      <Text>Payments details</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="18" type="GeneralFormat" isKey="true" />
                      <Type>Expression</Type>
                      <VertAlignment>Center</VertAlignment>
                    </Text1>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <Name>Header1</Name>
                  <Page isRef="7" />
                  <Parent isRef="15" />
                  <Restrictions>All</Restrictions>
                </Header1>
                <AverageBand Ref="19" type="DataBand" isKey="true">
                  <Border>All;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.9,7.3,0.2</ClientRectangle>
                  <Components isList="true" count="2">
                    <DataProducts2_CategoryID Ref="20" type="Text" isKey="true">
                      <Brush>Transparent</Brush>
                      <ClientRectangle>0,0,1.1,0.2</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,12,Bold</Font>
                      <LinesOfUnderline>None</LinesOfUnderline>
                      <Margins>0,0,0,0</Margins>
                      <Name>DataProducts2_CategoryID</Name>
                      <Page isRef="7" />
                      <Parent isRef="19" />
                      <Restrictions>All</Restrictions>
                      <Text>{AveragePriceByCategory.CategoryID}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="21" type="GeneralFormat" isKey="true" />
                      <VertAlignment>Center</VertAlignment>
                    </DataProducts2_CategoryID>
                    <DataProducts2_ProductName Ref="22" type="Text" isKey="true">
                      <Brush>Transparent</Brush>
                      <ClientRectangle>1.1,0,1.5,0.2</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,12,Bold</Font>
                      <LinesOfUnderline>None</LinesOfUnderline>
                      <Margins>0,0,0,0</Margins>
                      <Name>DataProducts2_ProductName</Name>
                      <Page isRef="7" />
                      <Parent isRef="19" />
                      <Restrictions>All</Restrictions>
                      <Text>{AveragePriceByCategory.UnitPriceAvg}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextFormat Ref="23" type="CurrencyFormat" isKey="true">
                        <GroupSeparator>,</GroupSeparator>
                        <NegativePattern>0</NegativePattern>
                        <PositivePattern>0</PositivePattern>
                        <UseLocalSetting>False</UseLocalSetting>
                      </TextFormat>
                      <VertAlignment>Center</VertAlignment>
                    </DataProducts2_ProductName>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <DataRelationName>CategoriesAverage</DataRelationName>
                  <DataSourceName>AveragePriceByCategory</DataSourceName>
                  <Filters isList="true" count="0" />
                  <MasterComponent isRef="13" />
                  <Name>AverageBand</Name>
                  <Page isRef="7" />
                  <Parent isRef="15" />
                  <ResetDataSource>True</ResetDataSource>
                  <Restrictions>All</Restrictions>
                  <Sort isList="true" count="0" />
                </AverageBand>
              </Components>
              <Conditions isList="true" count="0" />
              <Name>Container1</Name>
              <Page isRef="7" />
              <Parent isRef="14" />
              <Restrictions>All</Restrictions>
            </Container1>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>GroupFooter1</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <PrintAtBottom>True</PrintAtBottom>
          <Restrictions>All</Restrictions>
        </GroupFooter1>
        <DataProducts Ref="24" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.4,7.49,0.2</ClientRectangle>
          <Components isList="true" count="2">
            <DataProducts_ProductName Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.6,0,6.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ProductName</Name>
              <Page isRef="7" />
              <Parent isRef="24" />
              <Restrictions>All</Restrictions>
              <Text>{Products.ProductName}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="26" type="GeneralFormat" isKey="true" />
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductName>
            <Text2 Ref="27" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.1,0,0.5,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="7" />
              <Parent isRef="24" />
              <Restrictions>All</Restrictions>
              <Text>{Products.CategoriesProducts.CategoryID}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="28" type="GeneralFormat" isKey="true" />
            </Text2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>CategoriesProducts</DataRelationName>
          <DataSourceName>Products</DataSourceName>
          <Filters isList="true" count="0" />
          <KeepHeaderTogether>False</KeepHeaderTogether>
          <MasterComponent isRef="13" />
          <Name>DataProducts</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <Restrictions>All</Restrictions>
          <Sort isList="true" count="0" />
        </DataProducts>
        <Data1 Ref="29" type="DataBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>AntiqueWhite</Brush>
          <ClientRectangle>0,4,7.49,2.2</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <CountData>4</CountData>
          <DataSourceName />
          <Filters isList="true" count="0" />
          <KeepHeaderTogether>False</KeepHeaderTogether>
          <MasterComponent isRef="13" />
          <Name>Data1</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <Restrictions>All</Restrictions>
          <Sort isList="true" count="0" />
        </Data1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>c85c963043e7427bba369111176b8a40</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <Page isRef="7" />
      <PageHeight>11.69</PageHeight>
      <PageWidth>8.27</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="30" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="31" 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>9/3/2007 6:06:40 PM</ReportChanged>
  <ReportCreated>9/3/2007 4:45:03 PM</ReportCreated>
  <ReportGuid>7705e4ae8f464643a882730e044656ad</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2007.2</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>