﻿<?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">
      <MS_x0020_SQL Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>MS SQL</Alias>
        <ConnectionStringEncrypted>+Xr7iUZR+pnzE+gAY1zyKt4gjc/FWUsJYkn1hGQsNeOQbpspYlHqbelHJYDpACU3gcjZz01bk0XtY4SESxhlKtF4zwLGMtP1anuc3GicqF7YyFPCS0xzfEZf2VhjHKwvgXD7CclW8gXLR+iA9w==</ConnectionStringEncrypted>
        <Key>99eecfda97ee475b96197913e2ca3d40</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>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" />
        <Key>8fc548a2a2984cfcac5772c356e6a31a</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>cb8fd8d55dbf4e34a91814243a370002</Key>
        <Name>Products</Name>
        <NameInSource>MS SQL</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from Products
where CategoryID in {(var1.Count == 0 ? "('')" : "(" + var1.ToQueryString("'") + ")")}</SqlCommand>
      </Products>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="1">
      <value>,var1,var1,,Stimulsoft.Report.StringList,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_Categories.CategoryID_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_Categories.CategoryName_x003C__x002F_ValuesColumn_x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_CheckedStates_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_,c11464f7b9044f3c9cd9f8aa89e9afd9</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>22a6fbc946c64db9ba3a5a44db86c87e</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <Text1 Ref="6" type="Text" isKey="true">
          <Border>All;[105:105:105];1;Solid;False;4;[105:105:105]</Border>
          <Brush>[255:255:0]</Brush>
          <ClientRectangle>1.8,-0.8,10,0.6</ClientRectangle>
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Font>Arial,10,Bold</Font>
          <Margins>0,0,0,0</Margins>
          <Name>Text1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Text>{var1}</Text>
          <TextBrush>Black</TextBrush>
        </Text1>
        <DataProducts Ref="7" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <DataProducts_CategoryID Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_CategoryID</Name>
              <Page isRef="5" />
              <Parent isRef="7" />
              <Text>{Products.CategoryID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_CategoryID>
            <DataProducts_ProductID Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>6.4,0,6.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ProductID</Name>
              <Page isRef="5" />
              <Parent isRef="7" />
              <Text>{Products.ProductID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductID>
            <DataProducts_ProductName Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>12.8,0,6.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataProducts_ProductName</Name>
              <Page isRef="5" />
              <Parent isRef="7" />
              <Text>{Products.ProductName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductName>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>Products</DataSourceName>
          <Expressions isList="true" count="0" />
          <Filters isList="true" count="0" />
          <Name>DataProducts</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="0" />
        </DataProducts>
      </Components>
      <Conditions isList="true" count="0" />
      <Expressions isList="true" count="0" />
      <Guid>b39a1edb487e47ec926b555df9e40434</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
    </Page1>
  </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/7/2022 11:12:41 PM</ReportChanged>
  <ReportCreated>12/19/2013 1:41:24 PM</ReportCreated>
  <ReportFile>E:\ReportsForTests\ListInQueryStringMySQL.mrt</ReportFile>
  <ReportGuid>cd75367397e44653a971b1ef684999d0</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2022.2.1.0</ReportVersion>
  <RequestParameters>True</RequestParameters>
  <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>