﻿<?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="1">
      <Connection Ref="2" type="Stimulsoft.Report.Dictionary.StiOleDbDatabase" isKey="true">
        <Alias>Connection</Alias>
        <ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Stimulsoft Reports.Net 2008.1 Trial\.Net 2.0\Bin\Data\NWIND.MDB;Persist Security Info=False</ConnectionString>
        <Name>Connection</Name>
        <PromptUserNameAndPassword>False</PromptUserNameAndPassword>
      </Connection>
    </Databases>
    <DataSources isList="true" count="2">
      <Categories Ref="3" type="Stimulsoft.Report.Dictionary.StiOleDbSource" isKey="true">
        <Alias>Categories</Alias>
        <Columns isList="true" count="4">
          <value>CategoryID,System.Int32</value>
          <value>CategoryName,System.String</value>
          <value>Description,System.String</value>
          <value>Picture,System.Byte[]</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>NorthWind</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT Categories.*
FROM Categories</SqlCommand>
      </Categories>
      <Products Ref="4" type="Stimulsoft.Report.Dictionary.StiOleDbSource" isKey="true">
        <Alias>Products</Alias>
        <Columns isList="true" count="10">
          <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>
          <value>UnitsOnOrder,System.Int16</value>
          <value>ReorderLevel,System.Int16</value>
          <value>Discontinued,System.Boolean</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>NorthWind</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_CategoryIDParameter,Categories.CategoryID,3,0</value>
        </Parameters>
        <SqlCommand>SELECT Products.*
FROM Products where Products.CategoryID = @CategoryIDParameter</SqlCommand>
      </Products>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="2">
      <value>,LastEmployeeName,LastEmployeeName,System.String,,False,False</value>
      <value>,LastCountryName,LastCountryName,System.String,,False,False</value>
    </Variables>
  </Dictionary>
  <GlobalizationStrings isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="5" type="Page" isKey="true">
      <BeforePrintEvent>Products.Disconnect();
Products.Connect();</BeforePrintEvent>
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <PageFooterBand1 Ref="6" type="PageFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,26.9,19,0.8</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <MaxHeight>0</MaxHeight>
          <MinHeight>0</MinHeight>
          <Name>PageFooterBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </PageFooterBand1>
        <ReportTitleBand1 Ref="7" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,1.4</ClientRectangle>
          <Components isList="true" count="1">
            <Text5 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,19,1.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,32,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <MaxSize>0,0</MaxSize>
              <MinSize>0,0</MinSize>
              <Name>Text5</Name>
              <Page isRef="5" />
              <Parent isRef="7" />
              <Text>Chart on Databand for Sql source</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="9" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text5>
          </Components>
          <Conditions isList="true" count="0" />
          <MaxHeight>0</MaxHeight>
          <MinHeight>0</MinHeight>
          <Name>ReportTitleBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </ReportTitleBand1>
        <Data1 Ref="10" type="DataBand" isKey="true">
          <BeforePrintEvent>Products.Connect();</BeforePrintEvent>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,2.6,19,11.6</ClientRectangle>
          <Components isList="true" count="3">
            <Chart1 Ref="11" type="Stimulsoft.Report.Chart.StiChart" isKey="true">
              <Area Ref="12" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" isKey="true">
                <BorderColor>95, 72, 29</BorderColor>
                <Brush>GradientBrush,[255:255:255],[255:255:219],90</Brush>
                <Chart isRef="11" />
                <GridLinesHor Ref="13" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
                  <Area isRef="12" />
                  <Color>100, 95, 72, 29</Color>
                  <MinorColor>100, 95, 72, 29</MinorColor>
                </GridLinesHor>
                <GridLinesHorRight Ref="14" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
                  <Area isRef="12" />
                  <Color>Silver</Color>
                  <MinorColor>Gainsboro</MinorColor>
                  <Visible>False</Visible>
                </GridLinesHorRight>
                <GridLinesVert Ref="15" type="Stimulsoft.Report.Chart.StiGridLinesVert" isKey="true">
                  <Area isRef="12" />
                  <Color>100, 95, 72, 29</Color>
                  <MinorColor>100, 95, 72, 29</MinorColor>
                </GridLinesVert>
                <InterlacingHor Ref="16" type="Stimulsoft.Report.Chart.StiInterlacingHor" isKey="true">
                  <Area isRef="12" />
                  <InterlacedBrush>[10:145:122:79]</InterlacedBrush>
                </InterlacingHor>
                <InterlacingVert Ref="17" type="Stimulsoft.Report.Chart.StiInterlacingVert" isKey="true">
                  <Area isRef="12" />
                  <InterlacedBrush>[10:145:122:79]</InterlacedBrush>
                </InterlacingVert>
                <XAxis Ref="18" type="Stimulsoft.Report.Chart.StiXBottomAxis" isKey="true">
                  <Area isRef="12" />
                  <Labels Ref="19" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Angle>45</Angle>
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>95, 72, 29</LineColor>
                  <Range Ref="20" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true">
                    <Maximum>0</Maximum>
                    <Minimum>0</Minimum>
                  </Range>
                  <Ticks Ref="21" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="22" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </XAxis>
                <XTopAxis Ref="23" type="Stimulsoft.Report.Chart.StiXTopAxis" isKey="true">
                  <Area isRef="12" />
                  <Labels Ref="24" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>95, 72, 29</LineColor>
                  <Ticks Ref="25" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="26" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </XTopAxis>
                <YAxis Ref="27" type="Stimulsoft.Report.Chart.StiYLeftAxis" isKey="true">
                  <Area isRef="12" />
                  <Labels Ref="28" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>95, 72, 29</LineColor>
                  <Range Ref="29" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true">
                    <Maximum>0</Maximum>
                    <Minimum>0</Minimum>
                  </Range>
                  <Ticks Ref="30" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="31" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YAxis>
                <YRightAxis Ref="32" type="Stimulsoft.Report.Chart.StiYRightAxis" isKey="true">
                  <Area isRef="12" />
                  <Labels Ref="33" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>95, 72, 29</LineColor>
                  <Ticks Ref="34" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="35" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 72, 29</Color>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YRightAxis>
              </Area>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0,1,19,10.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <ConstantLines isList="true" count="0" />
              <DataRelationName isNull="true" />
              <DataSourceName>Products</DataSourceName>
              <Filters isList="true" count="0" />
              <Legend Ref="36" type="Stimulsoft.Report.Chart.StiLegend" isKey="true">
                <BorderColor>95, 72, 29</BorderColor>
                <Brush>GradientBrush,[255:255:255],[255:242:199],90</Brush>
                <Chart isRef="11" />
                <Font>Arial,8</Font>
                <LabelsColor>95, 72, 29</LabelsColor>
                <MarkerSize>10, 10</MarkerSize>
                <Size>0,0</Size>
                <TitleColor>95, 72, 29</TitleColor>
                <TitleFont>Arial,14,Bold</TitleFont>
              </Legend>
              <MaxSize>0,0</MaxSize>
              <MinSize>0,0</MinSize>
              <Name>Chart1</Name>
              <Page isRef="5" />
              <Parent isRef="10" />
              <Series isList="true" count="1">
                <Item10 Ref="37" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" isKey="true">
                  <ArgumentDataColumn>Products.ProductName</ArgumentDataColumn>
                  <BorderColor>144, 67, 3</BorderColor>
                  <Brush>GlareBrush,[144:67:3],[194:117:53],0,0.5,1</Brush>
                  <Chart isRef="11" />
                  <Conditions isList="true" count="0" />
                  <Filters isList="true" count="0" />
                  <ValueDataColumn>Products.UnitPrice</ValueDataColumn>
                </Item10>
              </Series>
              <SeriesLabels Ref="38" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
                <BorderColor>95, 72, 29</BorderColor>
                <Brush>Wheat</Brush>
                <Chart isRef="11" />
                <Font>Arial,7</Font>
                <LabelColor>95, 72, 29</LabelColor>
                <MarkerSize>8, 6</MarkerSize>
              </SeriesLabels>
              <Sort isList="true" count="0" />
              <Strips isList="true" count="0" />
              <Style Ref="39" type="Stimulsoft.Report.Chart.StiStyle01" isKey="true" />
              <Title Ref="40" type="Stimulsoft.Report.Chart.StiChartTitle" isKey="true">
                <Brush>[95:72:29]</Brush>
                <Font>Tahoma,12,Bold</Font>
              </Title>
            </Chart1>
            <Text1 Ref="41" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>8.2,0,5.2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14,Bold</Font>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <MaxSize>0,0</MaxSize>
              <MinSize>0,0</MinSize>
              <Name>Text1</Name>
              <Page isRef="5" />
              <Parent isRef="10" />
              <Text>{Products.Parameters["@CategoryIDParameter"].ParameterValue}</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="42" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text1>
            <Text2 Ref="43" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,8.2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14,Bold</Font>
              <Guid>b88fb1553c95401f98c24020abcb7d6a</Guid>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <MaxSize>0,0</MaxSize>
              <MinSize>0,0</MinSize>
              <Name>Text2</Name>
              <Page isRef="5" />
              <Parent isRef="10" />
              <Text>Products.@CategoryIDParameter =</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="44" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName />
          <DataSourceName>Categories</DataSourceName>
          <Filters isList="true" count="0" />
          <MaxHeight>0</MaxHeight>
          <MinHeight>0</MinHeight>
          <Name>Data1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="0" />
        </Data1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>1351c274fde749b1b7501ed96b1ce0de</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <Page isRef="5" />
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="45" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="46" 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>Chart on Databand</ReportAlias>
  <ReportAuthor isNull="true" />
  <ReportChanged>5/1/2008 9:20:46 AM</ReportChanged>
  <ReportCreated>6/1/2006 11:13:09 AM</ReportCreated>
  <ReportDescription isNull="true" />
  <ReportGuid>e72f2522773f4cfdb73747be9a320a63</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2008.1.200</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.ReportControls;
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="1">
    <Odd Ref="47" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Brush>PapayaWhip</Brush>
      <Font>Arial,8</Font>
      <Name>Odd</Name>
      <TextBrush>Black</TextBrush>
    </Odd>
  </Styles>
</StiSerializer>