﻿<?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">
      <Connection1 Ref="2" type="Stimulsoft.Report.Dictionary.StiOleDbDatabase" isKey="true">
        <Alias>Connection1</Alias>
        <ConnectionStringEncrypted>4O7VCU5LS8j1TYCAckwln8L2U+PGVAEJRUHNXPcYpXvcOMEJWEDS9coG7Vj6WKAfkGpPaFZd64zhTCXcS3S1RuleaapNS8qM4kd5xMTY4EvoOOPCSFcx3WltnJj1BOQqi+5zy8V9qYDh</ConnectionStringEncrypted>
        <Name>Connection1</Name>
      </Connection1>
    </Databases>
    <DataSources isList="true" count="1">
      <tbl Ref="3" type="Stimulsoft.Report.Dictionary.StiOleDbSource" isKey="true">
        <Alias>tbl</Alias>
        <Columns isList="true" count="4">
          <value>f1,System.Double</value>
          <value>f2,System.Double</value>
          <value>f3,System.Double</value>
          <value>f4,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>tbl</Name>
        <NameInSource>Connection1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from [tbl1$]</SqlCommand>
      </tbl>
    </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="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <Datatbl Ref="5" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="4">
            <Datatbl_f1 Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,4.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Datatbl_f1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{tbl.f1}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datatbl_f1>
            <Datatbl_f2 Ref="7" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>4.8,0,4.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Datatbl_f2</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{tbl.f2}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datatbl_f2>
            <Datatbl_f3 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9.6,0,4.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Datatbl_f3</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{tbl.f3}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datatbl_f3>
            <Datatbl_f4 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>14.4,0,4.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Datatbl_f4</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{tbl.f4}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </Datatbl_f4>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>tbl</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>Datatbl</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </Datatbl>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>55d4ca275fe840b09cb36be1f7213929</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="10" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
    <Form1 Ref="11" type="Stimulsoft.Report.Dialogs.StiForm" isKey="true">
      <BackColor>Control</BackColor>
      <Components isList="true" count="3">
        <TextBoxControl1 Ref="12" type="Stimulsoft.Report.Dialogs.StiTextBoxControl" isKey="true">
          <BackColor>Window</BackColor>
          <ClientRectangle>16,16,248,20</ClientRectangle>
          <Components isList="true" count="0" />
          <Font>Microsoft Sans Serif,8</Font>
          <ForeColor>Black</ForeColor>
          <Location>16, 16</Location>
          <Name>TextBoxControl1</Name>
          <Page isRef="11" />
          <Parent isRef="11" />
          <Size>248, 20</Size>
          <Text>Text Box</Text>
        </TextBoxControl1>
        <ButtonControl1 Ref="13" type="Stimulsoft.Report.Dialogs.StiButtonControl" isKey="true">
          <ClickEvent>OpenFileDialog openFileDialog1 = new OpenFileDialog();
openFileDialog1.ShowReadOnly = true;

if (openFileDialog1.ShowDialog() == DialogResult.OK)
{
	string t = openFileDialog1.FileName;
	TextBoxControl1.Text = t;
	
	((Stimulsoft.Report.Dictionary.StiOleDbDatabase)this.Dictionary.Databases["Connection1"]).ConnectionString = 
		@"Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties='Excel 12.0 Xml;HDR=YES';Data Source=" + t;

}

</ClickEvent>
          <ClientRectangle>280,16,96,24</ClientRectangle>
          <Components isList="true" count="0" />
          <Font>Microsoft Sans Serif,8</Font>
          <ForeColor>Black</ForeColor>
          <Location>280, 16</Location>
          <Name>ButtonControl1</Name>
          <Page isRef="11" />
          <Parent isRef="11" />
          <Size>96, 24</Size>
          <Text>Browse</Text>
        </ButtonControl1>
        <ButtonControl2 Ref="14" type="Stimulsoft.Report.Dialogs.StiButtonControl" isKey="true">
          <ClientRectangle>280,160,96,24</ClientRectangle>
          <Components isList="true" count="0" />
          <DialogResult>OK</DialogResult>
          <Font>Microsoft Sans Serif,8</Font>
          <ForeColor>Black</ForeColor>
          <Location>280, 160</Location>
          <Name>ButtonControl2</Name>
          <Page isRef="11" />
          <Parent isRef="11" />
          <Size>96, 24</Size>
          <Text>Show</Text>
        </ButtonControl2>
      </Components>
      <Font>Microsoft Sans Serif,8</Font>
      <Guid>c3ec9edef74341a6969aa9c1aa6d1b75</Guid>
      <Location>0, 0</Location>
      <Name>Form1</Name>
      <Report isRef="0" />
      <Size>408, 224</Size>
      <Text>Form1</Text>
    </Form1>
  </Pages>
  <PrinterSettings Ref="15" 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>6/20/2014 2:13:58 PM</ReportChanged>
  <ReportCreated>6/20/2014 1:46:44 PM</ReportCreated>
  <ReportFile>E:\ReportSample.mrt</ReportFile>
  <ReportGuid>c6dec9aeb9f74083a15c4f2fb553680d</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2014.2.1904</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>