﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <CalculationMode>Interpretation</CalculationMode>
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <MS_x0020_SQL Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>MS SQL</Alias>
        <ConnectionStringEncrypted>+Xr7iUZR+pnzE+gAY1zyKt4gjc/FWUsJYkn1hGQsNeOQbpspYlHqbelHJYDpACU3gcjZz01bk0XtY4SESxhlKtF4zwLGMtP1anuc3GicqF7YyFPCS0xzfEZf2VhjHKwvgXD7CclW8gXLR+iA9w==</ConnectionStringEncrypted>
        <Key>a2216a1c6fa84248bb1a996d813ff298</Key>
        <Name>MS SQL</Name>
      </MS_x0020_SQL>
    </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>ORIGINAL,CategoryID,CategoryID,CategoryID,System.Int32,ce693ca98d964aa0816d28167e0ae7a6</value>
          <value>ORIGINAL,CategoryName,CategoryName,CategoryName,System.String,ba7d165108bd4fcf9a57c7a66e4c1d4c</value>
          <value>ORIGINAL,Description,Description,Description,System.String,d248b5c3672a4819a1e4148b2ec95b57</value>
          <value>ORIGINAL,Picture,Picture,Picture,System.Byte[],_x0037_1518a52c73c4502a689ab689dae65ed</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>33d6747b9e8849e181e3b2f0c4c717f6</Key>
        <Name>Categories</Name>
        <NameInSource>MS SQL</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>CategoryID,System.Int32</value>
          <value>Discontinued,System.Boolean</value>
          <value>ProductID,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>QuantityPerUnit,System.String</value>
          <value>ReorderLevel,System.Int16</value>
          <value>SupplierID,System.Int32</value>
          <value>UnitPrice,System.Decimal</value>
          <value>UnitsInStock,System.Int16</value>
          <value>UnitsOnOrder,System.Int16</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Key>301f4ac626064b19a9f00a5bdd4ba246</Key>
        <Name>Products</Name>
        <NameInSource>MS SQL</NameInSource>
        <Parameters isList="true" count="1">
          <value>_x0040_P1,Var1,8,0</value>
        </Parameters>
        <SqlCommand>select * from Products where CategoryID = @P1</SqlCommand>
      </Products>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="1">
      <value>,Var1,Var1,,System.Int32,_x0030_,False,False,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>259862c71a4f4c81b0497f8018767ca1</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <Dashboard1 Ref="5" type="Stimulsoft.Dashboard.Components.StiDashboard" isKey="true">
      <BackColor>Transparent</BackColor>
      <Components isList="true" count="1">
        <TableCategories Ref="6" type="Stimulsoft.Dashboard.Components.Table.StiTableElement" isKey="true">
          <AltClientRectangle>0,0,0,0</AltClientRectangle>
          <BackColor>Transparent</BackColor>
          <ClientRectangle>0,0,580,320</ClientRectangle>
          <Columns isList="true" count="3">
            <Item6 Ref="7" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <DashboardInteraction Ref="8" type="Stimulsoft.Dashboard.Interactions.StiTableColumnDashboardInteraction" isKey="true">
                <DrillDownPageKey>6c33297aeb9c4886972a9bea5c94b407</DrillDownPageKey>
                <DrillDownParameters isList="true" count="1">
                  <Var1 Ref="9" type="Stimulsoft.Dashboard.Interactions.StiDashboardDrillDownParameter" isKey="true">
                    <Expression>{Row.CategoryID}</Expression>
                    <Name>Var1</Name>
                  </Var1>
                </DrillDownParameters>
                <OnClick>ShowDashboard</OnClick>
              </DashboardInteraction>
              <Expression>Sum(Categories.CategoryID)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>cd0ff9246ad84ddfa6623a8a48270eac</Key>
              <Label>CategoryID</Label>
              <TextFormat Ref="10" type="NumberFormat" isKey="true">
                <DecimalDigits>0</DecimalDigits>
                <DecimalSeparator>,</DecimalSeparator>
                <GroupSeparator> </GroupSeparator>
                <NegativePattern>1</NegativePattern>
                <UseLocalSetting>False</UseLocalSetting>
              </TextFormat>
            </Item6>
            <Item8 Ref="11" type="Stimulsoft.Dashboard.Components.Table.StiDimensionColumn" isKey="true">
              <Expression>Categories.CategoryName</Expression>
              <ForeColor>Transparent</ForeColor>
              <Key>7398ea47d8be485ea36be9261f3ef6ba</Key>
              <Label>CategoryName</Label>
              <Size Ref="12" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
            </Item8>
            <Item9 Ref="13" type="Stimulsoft.Dashboard.Components.Table.StiDimensionColumn" isKey="true">
              <Expression>Categories.Description</Expression>
              <ForeColor>Transparent</ForeColor>
              <Key>29083a0566dc4e119d35384af73f50ce</Key>
              <Label>Description</Label>
              <Size Ref="14" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
            </Item9>
          </Columns>
          <DataFilters isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Font>Arial,10</Font>
          <FooterFont>Arial,10</FooterFont>
          <FooterForeColor>Transparent</FooterForeColor>
          <ForeColor>Transparent</ForeColor>
          <Guid>6cac09f62ddf41d2be27b746f7f7fa01</Guid>
          <HeaderFont>Arial,10</HeaderFont>
          <HeaderForeColor>Transparent</HeaderForeColor>
          <Margin>3,3,3,3</Margin>
          <Name>TableCategories</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <TableConditions isList="true" count="0" />
          <Title Ref="15" type="Stimulsoft.Dashboard.Components.StiTitle" isKey="true">
            <BackColor>Transparent</BackColor>
            <Font>Arial,11</Font>
            <ForeColor>Transparent</ForeColor>
            <SizeMode>Fit</SizeMode>
            <Text>Categories</Text>
          </Title>
          <TransformActions isList="true" count="0" />
          <TransformFilters isList="true" count="0" />
          <TransformSorts isList="true" count="0" />
          <UserFilters isList="true" count="0" />
          <UserSorts isList="true" count="0" />
        </TableCategories>
      </Components>
      <Expressions isList="true" count="0" />
      <Guid>d65f824ab0ba40a095de223dbe992b41</Guid>
      <Name>Dashboard1</Name>
      <Report isRef="0" />
    </Dashboard1>
    <Dashboard2 Ref="16" type="Stimulsoft.Dashboard.Components.StiDashboard" isKey="true">
      <BackColor>Transparent</BackColor>
      <Components isList="true" count="1">
        <TableProducts Ref="17" type="Stimulsoft.Dashboard.Components.Table.StiTableElement" isKey="true">
          <AltClientRectangle>0,0,0,0</AltClientRectangle>
          <BackColor>Transparent</BackColor>
          <ClientRectangle>20,0,960,500</ClientRectangle>
          <Columns isList="true" count="10">
            <Item12 Ref="18" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <Expression>Sum(Products.CategoryID)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>acb49714524b4352a85e15ff49d073cf</Key>
              <Label>CategoryID</Label>
              <TextFormat isRef="10" />
            </Item12>
            <Item13 Ref="19" type="Stimulsoft.Dashboard.Components.Table.StiDimensionColumn" isKey="true">
              <Expression>Products.Discontinued</Expression>
              <ForeColor>Transparent</ForeColor>
              <Key>c7e0fee436284cfba0e4e5c72693816b</Key>
              <Label>Discontinued</Label>
              <Size Ref="20" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
              <TextFormat Ref="21" type="BooleanFormat" isKey="true">
                <NullDisplay> </NullDisplay>
                <StringFormat />
              </TextFormat>
            </Item13>
            <Item14 Ref="22" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <Expression>Sum(Products.ProductID)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>adc8084c9d0c4eb48ade187c226601a7</Key>
              <Label>ProductID</Label>
              <TextFormat isRef="10" />
            </Item14>
            <Item15 Ref="23" type="Stimulsoft.Dashboard.Components.Table.StiDimensionColumn" isKey="true">
              <Expression>Products.ProductName</Expression>
              <ForeColor>Transparent</ForeColor>
              <Key>aa9e63c1de37498c89462f93bb0bf846</Key>
              <Label>ProductName</Label>
              <Size Ref="24" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
            </Item15>
            <Item16 Ref="25" type="Stimulsoft.Dashboard.Components.Table.StiDimensionColumn" isKey="true">
              <Expression>Products.QuantityPerUnit</Expression>
              <ForeColor>Transparent</ForeColor>
              <Key>2b2ea24b276c4f9baa5cc240b23007e6</Key>
              <Label>QuantityPerUnit</Label>
              <Size Ref="26" type="Stimulsoft.Report.Dashboard.StiTableColumnSize" isKey="true" />
            </Item16>
            <Item17 Ref="27" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <Expression>Sum(Products.ReorderLevel)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>17b777434c454c6db62c277d0a414167</Key>
              <Label>ReorderLevel</Label>
              <TextFormat isRef="10" />
            </Item17>
            <Item18 Ref="28" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <Expression>Sum(Products.SupplierID)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>8ca8135752b3406f83f45c4db2dd0fdd</Key>
              <Label>SupplierID</Label>
              <TextFormat isRef="10" />
            </Item18>
            <Item19 Ref="29" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <Expression>Sum(Products.UnitPrice)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>75111e8952174c2b990c8ee132724253</Key>
              <Label>UnitPrice</Label>
              <TextFormat Ref="30" type="CurrencyFormat" isKey="true">
                <DecimalDigits>2</DecimalDigits>
                <DecimalSeparator>,</DecimalSeparator>
                <GroupSeparator> </GroupSeparator>
                <NegativePattern>8</NegativePattern>
                <PositivePattern>3</PositivePattern>
                <Symbol>₽</Symbol>
              </TextFormat>
            </Item19>
            <Item20 Ref="31" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <Expression>Sum(Products.UnitsInStock)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>7cdd4edad18b42fca7adca6b3c5b7b48</Key>
              <Label>UnitsInStock</Label>
              <TextFormat isRef="10" />
            </Item20>
            <Item21 Ref="32" type="Stimulsoft.Dashboard.Components.Table.StiMeasureColumn" isKey="true">
              <Expression>Sum(Products.UnitsOnOrder)</Expression>
              <ForeColor>Transparent</ForeColor>
              <HorAlignment>Right</HorAlignment>
              <Key>c9ebbd2279a64624a190d8531865364d</Key>
              <Label>UnitsOnOrder</Label>
              <TextFormat isRef="10" />
            </Item21>
          </Columns>
          <DataFilters isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Font>Arial,10</Font>
          <FooterFont>Arial,10</FooterFont>
          <FooterForeColor>Transparent</FooterForeColor>
          <ForeColor>Transparent</ForeColor>
          <Guid>d75bbb93eca04eac9eafeedcec7a8bd1</Guid>
          <HeaderFont>Arial,10</HeaderFont>
          <HeaderForeColor>Transparent</HeaderForeColor>
          <Margin>3,3,3,3</Margin>
          <Name>TableProducts</Name>
          <Page isRef="16" />
          <Parent isRef="16" />
          <TableConditions isList="true" count="0" />
          <Title Ref="33" type="Stimulsoft.Dashboard.Components.StiTitle" isKey="true">
            <BackColor>Transparent</BackColor>
            <Font>Arial,11</Font>
            <ForeColor>Transparent</ForeColor>
            <SizeMode>Fit</SizeMode>
            <Text>Products</Text>
          </Title>
          <TransformActions isList="true" count="0" />
          <TransformFilters isList="true" count="0" />
          <TransformSorts isList="true" count="0" />
          <UserFilters isList="true" count="0" />
          <UserSorts isList="true" count="0" />
        </TableProducts>
      </Components>
      <Expressions isList="true" count="0" />
      <Guid>6c33297aeb9c4886972a9bea5c94b407</Guid>
      <Name>Dashboard2</Name>
      <Report isRef="0" />
    </Dashboard2>
  </Pages>
  <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>3/18/2022 4:38:10 PM</ReportChanged>
  <ReportCreated>3/18/2022 4:21:07 PM</ReportCreated>
  <ReportFile>E:\DBSParam.mrt</ReportFile>
  <ReportGuid>429e8ea215854f69a6916c7496fcf87b</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2022.2.1.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;

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>