﻿<?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">
      <MSSQL1 Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>MSSQL1</Alias>
        <ConnectionStringEncrypted>9Fb1C+8JS4VGW+3cwyWgXtE++yvGaKvZYhXozOlsYQ/V0OEJyUtDleF7Jdx3dOA/jWzRiU5x0+1pSe3JYHSim9xW+evIBcOk7Hulpenk4HvCyFODQ1lymW9a8ZzDdG03xHqbr2FWeoF/a1Hod2ykd9/EwetFXQ==</ConnectionStringEncrypted>
        <Name>MSSQL1</Name>
      </MSSQL1>
    </Databases>
    <DataSources isList="true" count="2">
      <Categories Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" 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>MSSQL1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from Categories</SqlCommand>
      </Categories>
      <Products Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Products</Alias>
        <Columns isList="true" count="10">
          <value>ProductID,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>Discontinued,System.Boolean</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>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_p1,this_x005B__x0022_CatID_x0022__x005D_,8,0</value>
        </Parameters>
        <SqlCommand>select * from Products where CategoryID = @p1</SqlCommand>
      </Products>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <Page1 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataCategories Ref="6" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.2,7.72,0.3</ClientRectangle>
          <Components isList="true" count="4">
            <DataCategories_CategoryID Ref="7" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_CategoryID</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{Categories.CategoryID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataCategories_CategoryID>
            <DataCategories_CategoryName Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>1.9,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_CategoryName</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{Categories.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataCategories_CategoryName>
            <DataCategories_Description Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>3.8,0,1.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_Description</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{Categories.Description}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataCategories_Description>
            <DataCategories_Picture Ref="10" type="Image" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>5.7,0,2,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DataColumn>Categories.Picture</DataColumn>
              <Margins>0,0,0,0</Margins>
              <Name>DataCategories_Picture</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
            </DataCategories_Picture>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>Categories</DataSourceName>
          <Filters isList="true" count="0" />
          <Interaction Ref="11" type="Stimulsoft.Report.Components.StiBandInteraction" isKey="true">
            <DrillDownEnabled>True</DrillDownEnabled>
            <DrillDownPageGuid>bf17bcd436e44f6590f9245bc4531296</DrillDownPageGuid>
            <DrillDownParameter1 Ref="12" type="Stimulsoft.Report.Components.StiDrillDownParameter" isKey="true">
              <Expression>Categories.CategoryID</Expression>
              <Name>CatID</Name>
            </DrillDownParameter1>
          </Interaction>
          <Name>DataCategories</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="0" />
        </DataCategories>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>bd5e923c6d444f9c93d77b15f348f0a6</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="13" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
    <Page2 Ref="14" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataProducts Ref="15" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.72,0.3</ClientRectangle>
          <Components isList="true" count="10">
            <DataProducts_ProductID Ref="16" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ProductID</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.ProductID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductID>
            <DataProducts_ProductName Ref="17" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0.8,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ProductName</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.ProductName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductName>
            <DataProducts_Discontinued Ref="18" type="CheckBox" isKey="true">
              <Brush>Transparent</Brush>
              <Checked>{Products.Discontinued}</Checked>
              <ClientRectangle>1.6,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <ContourColor>Black</ContourColor>
              <Name>DataProducts_Discontinued</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <TextBrush>Black</TextBrush>
            </DataProducts_Discontinued>
            <DataProducts_SupplierID Ref="19" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>2.4,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_SupplierID</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.SupplierID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_SupplierID>
            <DataProducts_CategoryID Ref="20" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>3.2,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_CategoryID</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.CategoryID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_CategoryID>
            <DataProducts_QuantityPerUnit Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>4,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_QuantityPerUnit</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.QuantityPerUnit}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_QuantityPerUnit>
            <DataProducts_UnitPrice Ref="22" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>4.8,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_UnitPrice</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.UnitPrice}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_UnitPrice>
            <DataProducts_UnitsInStock Ref="23" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>5.6,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_UnitsInStock</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.UnitsInStock}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_UnitsInStock>
            <DataProducts_UnitsOnOrder Ref="24" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>6.4,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_UnitsOnOrder</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.UnitsOnOrder}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_UnitsOnOrder>
            <DataProducts_ReorderLevel Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>7.2,0,0.5,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ReorderLevel</Name>
              <Page isRef="14" />
              <Parent isRef="15" />
              <Text>{Products.ReorderLevel}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ReorderLevel>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Products</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataProducts</Name>
          <Page isRef="14" />
          <Parent isRef="14" />
          <Sort isList="true" count="0" />
        </DataProducts>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>bf17bcd436e44f6590f9245bc4531296</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page2</Name>
      <PageHeight>11</PageHeight>
      <PageWidth>8.5</PageWidth>
      <PaperSize>Letter</PaperSize>
      <Report isRef="0" />
      <Watermark Ref="26" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page2>
  </Pages>
  <PreviewSettings>268435455</PreviewSettings>
  <PrinterSettings Ref="27" 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>5/24/2016 9:24:21 AM</ReportChanged>
  <ReportCreated>5/24/2016 9:17:45 AM</ReportCreated>
  <ReportFile />
  <ReportGuid>4746d19e54394a46be4b052849177da8</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2016.1.11</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;

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>