﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.0" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <testcon1 Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>testcon1</Alias>
        <ConnectionString>Initial Catalog=testdata;Integrated Security=False;Password=test;User ID=sa;Data Source=ICT12D330-0308;Persist Security Info=True</ConnectionString>
        <Name>testcon1</Name>
        <PromptUserNameAndPassword>False</PromptUserNameAndPassword>
      </testcon1>
    </Databases>
    <DataSources isList="true" count="1">
      <DataSource1 Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>DataSource1</Alias>
        <Columns isList="true" count="6">
          <value>id,System.String</value>
          <value>first_name,System.String</value>
          <value>last_name,System.String</value>
          <value>email,System.String</value>
          <value>country,System.String</value>
          <value>ip_address,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>DataSource1</Name>
        <NameInSource>testcon1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from Aleksey

where country IN ({vDomain})

order by last_name</SqlCommand>
      </DataSource1>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="1">
      <value>,vDomain,vDomain,System.String,,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <Page1 Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <ReportTitleBand1 Ref="5" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.96</ClientRectangle>
          <Components isList="true" count="1">
            <Text7 Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.4,0.2,5.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{vDomain}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text7>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ReportTitleBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </ReportTitleBand1>
        <DataBand1 Ref="7" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2.16,19,0.96</ClientRectangle>
          <Components isList="true" count="5">
            <Text1 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,0.24,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{DataSource1.id}</Text>
              <TextBrush>Black</TextBrush>
            </Text1>
            <Text2 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.8,0.24,3.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{DataSource1.first_name}</Text>
              <TextBrush>Black</TextBrush>
            </Text2>
            <Text3 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5.2,0.24,2.8,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{DataSource1.last_name}</Text>
              <TextBrush>Black</TextBrush>
            </Text3>
            <Text4 Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>8.6,0.24,3,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{DataSource1.country}</Text>
              <TextBrush>Black</TextBrush>
            </Text4>
            <Text5 Ref="12" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>12.2,0.24,4.2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{DataSource1.ip_address}</Text>
              <TextBrush>Black</TextBrush>
            </Text5>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>DataSource1</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>53d5499eefb34ecc8ce453d71d392e92</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <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>
    <Form1 Ref="14" type="Stimulsoft.Report.Dialogs.StiForm" isKey="true">
      <BackColor>Control</BackColor>
      <Components isList="true" count="3">
        <ButtonControl1 Ref="15" type="Stimulsoft.Report.Dialogs.StiButtonControl" isKey="true">
          <ClickEvent>vDomain       = (string)Switch(
domain.Text == "Ukraine", "'Ukraine'",
domain.Text == "China", "'China'",
domain.Text == "Ukraine-China", "'Ukraine', 'China'");</ClickEvent>
          <ClientRectangle>0,40,96,24</ClientRectangle>
          <Components isList="true" count="0" />
          <DialogResult>OK</DialogResult>
          <Font>Microsoft Sans Serif,8</Font>
          <ForeColor>Black</ForeColor>
          <Location>0, 40</Location>
          <Name>ButtonControl1</Name>
          <Page isRef="14" />
          <Parent isRef="14" />
          <Size>96, 24</Size>
          <Text>OK</Text>
        </ButtonControl1>
        <ButtonControl2 Ref="16" type="Stimulsoft.Report.Dialogs.StiButtonControl" isKey="true">
          <Cancel>True</Cancel>
          <ClientRectangle>104,40,96,24</ClientRectangle>
          <Components isList="true" count="0" />
          <DialogResult>Cancel</DialogResult>
          <Font>Microsoft Sans Serif,8</Font>
          <ForeColor>Black</ForeColor>
          <Location>104, 40</Location>
          <Name>ButtonControl2</Name>
          <Page isRef="14" />
          <Parent isRef="14" />
          <Size>96, 24</Size>
          <Text>Cancel</Text>
        </ButtonControl2>
        <domain Ref="17" type="Stimulsoft.Report.Dialogs.StiComboBoxControl" isKey="true">
          <BackColor>Window</BackColor>
          <ClientRectangle>48,8,96,20</ClientRectangle>
          <Components isList="true" count="0" />
          <Font>Microsoft Sans Serif,8</Font>
          <ForeColor>Black</ForeColor>
          <Items isList="true" count="3">
            <value>Ukraine</value>
            <value>China</value>
            <value>Ukraine-China</value>
          </Items>
          <Location>48, 8</Location>
          <Name>domain</Name>
          <Page isRef="14" />
          <Parent isRef="14" />
          <Size>96, 20</Size>
          <Text>Combo Box</Text>
        </domain>
      </Components>
      <Font>Microsoft Sans Serif,8</Font>
      <Guid>a969a4abe42a454e811f82c5184b001f</Guid>
      <Location>0, 0</Location>
      <Name>Form1</Name>
      <Report isRef="0" />
      <Size>208, 88</Size>
      <Text>Form1</Text>
    </Form1>
  </Pages>
  <PrinterSettings Ref="18" 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>12/10/2014 11:33:33 AM</ReportChanged>
  <ReportCreated>12/9/2014 9:27:02 AM</ReportCreated>
  <ReportFile>H:\TM2\Reporting\Reports\Test_for_Stimulsoft\Report.mrt</ReportFile>
  <ReportGuid>c27f0a6a613c4a5fb367ae4b0b9d5eb0</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2010.2.751</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>