﻿<?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">
      <Connection Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
        <Alias>Connection</Alias>
        <Name>Connection</Name>
        <PathData>E:\data.xml</PathData>
        <PathSchema />
      </Connection>
    </Databases>
    <DataSources isList="true" count="1">
      <Rec Ref="3" type="DataTableSource" isKey="true">
        <Alias>Rec</Alias>
        <Columns isList="true" count="3">
          <value>Left,System.Int32</value>
          <value>Right,System.Int32</value>
          <value>Sum,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Rec</Name>
        <NameInSource>Connection.Rec</NameInSource>
      </Rec>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="1">
      <value>,ind,ind,System.Int32,_x0030_,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="4" type="Page" isKey="true">
      <BeginRenderEvent>
System.Collections.Generic.SortedList&lt;int, int&gt; list = new System.Collections.Generic.SortedList&lt;int, int&gt;();
int ind = 0;
Rec.Connect();
foreach (Stimulsoft.Report.Dictionary.StiRow row in Rec.Rows)
{
	if (!list.ContainsValue(int.Parse(row["Left"].ToString())))
		list.Add(ind++, int.Parse(row["Left"].ToString()));
	if (!list.ContainsValue(int.Parse(row["Right"].ToString())))
		list.Add(ind++, int.Parse(row["Right"].ToString()));
}

Rec.Disconnect();
DataBand1.CountData = list.Count;

l = new System.Collections.Generic.List&lt;int&gt;(list.Values);
l.Sort();</BeginRenderEvent>
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataBand1 Ref="5" type="DataBand" isKey="true">
          <AfterPrintEvent>ind++;</AfterPrintEvent>
          <Brush>Transparent</Brush>
          <CanShrink>True</CanShrink>
          <ClientRectangle>0,0.2,7.72,1.4</ClientRectangle>
          <Components isList="true" count="3">
            <Text1 Ref="6" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[255:194:14]</Brush>
              <ClientRectangle>0,0,7.7,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{l[ind]}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text1>
            <Panel1 Ref="7" type="Stimulsoft.Report.Components.StiPanel" isKey="true">
              <Brush>Transparent</Brush>
              <CanShrink>True</CanShrink>
              <ClientRectangle>0.1,0.2,3.7,1.2</ClientRectangle>
              <Components isList="true" count="2">
                <DataRec Ref="8" type="DataBand" isKey="true">
                  <Border>Top, Bottom;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <BusinessObjectGuid isNull="true" />
                  <ClientRectangle>0,0.2,3.7,0.3</ClientRectangle>
                  <Components isList="true" count="2">
                    <DataRec_Left Ref="9" type="Text" isKey="true">
                      <Brush>Transparent</Brush>
                      <CanGrow>True</CanGrow>
                      <ClientRectangle>0,0,1.8,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8</Font>
                      <Margins>0,0,0,0</Margins>
                      <Name>DataRec_Left</Name>
                      <Page isRef="4" />
                      <Parent isRef="8" />
                      <Text>{Rec.Left}</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>
                    </DataRec_Left>
                    <DataRec_Sum Ref="10" type="Text" isKey="true">
                      <Brush>Transparent</Brush>
                      <CanGrow>True</CanGrow>
                      <ClientRectangle>1.8,0,1.9,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8</Font>
                      <Margins>0,0,0,0</Margins>
                      <Name>DataRec_Sum</Name>
                      <Page isRef="4" />
                      <Parent isRef="8" />
                      <Text>{Rec.Sum}</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>
                    </DataRec_Sum>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <DataRelationName isNull="true" />
                  <DataSourceName>Rec</DataSourceName>
                  <Filters isList="true" count="1">
                    <value>_x007B_Rec.Right_x0020__x003D__x003D__x0020_l_x005B_ind_x005D__x007D_</value>
                  </Filters>
                  <Name>DataRec</Name>
                  <Page isRef="4" />
                  <Parent isRef="7" />
                  <Sort isList="true" count="0" />
                </DataRec>
                <FooterBand1 Ref="11" type="FooterBand" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.9,3.7,0.3</ClientRectangle>
                  <Components isList="true" count="1">
                    <Text2 Ref="12" type="Text" isKey="true">
                      <Border>Top;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanGrow>True</CanGrow>
                      <ClientRectangle>1.8,0,1.9,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8,Bold</Font>
                      <Guid>5f7d624b1eb04ccd9f4759d0aea42047</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text2</Name>
                      <Page isRef="4" />
                      <Parent isRef="11" />
                      <Text>{Sum(Rec.Sum)}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
                      <Type>Expression</Type>
                      <VertAlignment>Center</VertAlignment>
                    </Text2>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <Name>FooterBand1</Name>
                  <Page isRef="4" />
                  <Parent isRef="7" />
                </FooterBand1>
              </Components>
              <Conditions isList="true" count="0" />
              <Name>Panel1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
            </Panel1>
            <Panel2 Ref="13" type="Stimulsoft.Report.Components.StiPanel" isKey="true">
              <Brush>Transparent</Brush>
              <CanShrink>True</CanShrink>
              <ClientRectangle>3.9,0.2,3.7,1.2</ClientRectangle>
              <Components isList="true" count="2">
                <DataRec2 Ref="14" type="DataBand" isKey="true">
                  <Border>Top, Bottom;Black;1;Solid;False;4;Black</Border>
                  <Brush>Transparent</Brush>
                  <BusinessObjectGuid isNull="true" />
                  <ClientRectangle>0,0.2,3.7,0.3</ClientRectangle>
                  <Components isList="true" count="2">
                    <DataRec_Right Ref="15" type="Text" isKey="true">
                      <Brush>Transparent</Brush>
                      <CanGrow>True</CanGrow>
                      <ClientRectangle>0,0,1.8,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8</Font>
                      <Margins>0,0,0,0</Margins>
                      <Name>DataRec_Right</Name>
                      <Page isRef="4" />
                      <Parent isRef="14" />
                      <Text>{Rec.Right}</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>
                    </DataRec_Right>
                    <DataRec_Sum2 Ref="16" type="Text" isKey="true">
                      <Brush>Transparent</Brush>
                      <CanGrow>True</CanGrow>
                      <ClientRectangle>1.8,0,1.9,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8</Font>
                      <Margins>0,0,0,0</Margins>
                      <Name>DataRec_Sum2</Name>
                      <Page isRef="4" />
                      <Parent isRef="14" />
                      <Text>{Rec.Sum}</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>
                    </DataRec_Sum2>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <DataRelationName isNull="true" />
                  <DataSourceName>Rec</DataSourceName>
                  <Filters isList="true" count="1">
                    <value>_x007B_Rec.Left_x0020__x003D__x003D__x0020_l_x005B_ind_x005D__x007D_</value>
                  </Filters>
                  <Name>DataRec2</Name>
                  <Page isRef="4" />
                  <Parent isRef="13" />
                  <Sort isList="true" count="0" />
                </DataRec2>
                <FooterBand2 Ref="17" type="FooterBand" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.9,3.7,0.3</ClientRectangle>
                  <Components isList="true" count="1">
                    <Text3 Ref="18" type="Text" isKey="true">
                      <Border>Top;Black;1;Solid;False;4;Black</Border>
                      <Brush>Transparent</Brush>
                      <CanGrow>True</CanGrow>
                      <ClientRectangle>1.8,0,1.9,0.3</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8,Bold</Font>
                      <Guid>1a063d5a3d7c4ddd936c023c075c17f7</Guid>
                      <Margins>0,0,0,0</Margins>
                      <Name>Text3</Name>
                      <Page isRef="4" />
                      <Parent isRef="17" />
                      <Text>{Sum(Rec.Sum)}</Text>
                      <TextBrush>Black</TextBrush>
                      <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
                      <Type>Expression</Type>
                      <VertAlignment>Center</VertAlignment>
                    </Text3>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <Guid>f8258e5bfbee41f58e2239dfe8a89d56</Guid>
                  <Name>FooterBand2</Name>
                  <Page isRef="4" />
                  <Parent isRef="13" />
                </FooterBand2>
              </Components>
              <Conditions isList="true" count="0" />
              <Guid>ba53496e80724094b5b234686a678b98</Guid>
              <Name>Panel2</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
            </Panel2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <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>fc0a7db249a74b9988449f1310758948</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="19" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="20" 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>
  <RenderingEvent>
</RenderingEvent>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>8/25/2011 9:33:59 AM</ReportChanged>
  <ReportCreated>8/24/2011 3:03:11 PM</ReportCreated>
  <ReportFile>E:\Report.mrt</ReportFile>
  <ReportGuid>0c657bd3a8bd48338be490c385924b86</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2011.2.1025</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;
using System.Collections;

namespace Reports
{
	public class Report : Stimulsoft.Report.StiReport
	{
		public Report()        {
			this.InitializeComponent();
		}

	
		SortedList list = new SortedList();
		System.Collections.Generic.List&lt;int&gt; l;
		
		#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>