﻿<?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>4O7ZCWFLwylrEhmYcoRiD8I4s2DGGPKB403N8fpxJT/FQvUM2VRDgfkIqcR/WPVG3CKNCWFAe7x5TYT0xFDie+NemyvvGqn9bE35xOUl4EvZ9uPCSFdJgWsVoEzxXKBqgWqZg11LyojsSeg=</ConnectionStringEncrypted>
        <Name>Connection1</Name>
      </Connection1>
    </Databases>
    <DataSources isList="true" count="1">
      <Sheet1_x0024_ Ref="3" type="Stimulsoft.Report.Dictionary.StiOleDbSource" isKey="true">
        <Alias>Sheet1$</Alias>
        <Columns isList="true" count="9">
          <value>_x0025__x0020_of_x0020_Cost,System.Double</value>
          <value>Cost,System.Decimal</value>
          <value>F9,System.String</value>
          <value>Length,System.String</value>
          <value>Quentity,System.Double</value>
          <value>Size,System.String</value>
          <value>Type,System.String</value>
          <value>Unite_x0020_Price,System.Decimal</value>
          <value>Weight,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>Sheet1$</Name>
        <NameInSource>Connection1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from [Sheet1$]</SqlCommand>
      </Sheet1_x0024_>
    </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="1">
    <Page1 Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="5">
        <GroupHeaderBand1 Ref="5" type="GroupHeaderBand" isKey="true">
          <Border>Bottom;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,1.2</ClientRectangle>
          <Components isList="true" count="1">
            <Text1 Ref="6" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0.6,5.2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{Sheet1_.Type}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text1>
          </Components>
          <Condition>{Sheet1_.Type}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupHeaderBand1>
        <GroupHeaderBand2 Ref="7" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,2.4,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Condition>{Sheet1_.Type}{Sheet1_.Size}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand2</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupHeaderBand2>
        <DataSheet1_x0024_ Ref="8" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,3.2,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <DataSourceName>Sheet1$</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataSheet1$</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataSheet1_x0024_>
        <GroupFooterBand1 Ref="9" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,4,19,0.6</ClientRectangle>
          <Components isList="true" count="7">
            <Text2 Ref="10" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sheet1_.Type}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text2>
            <Text3 Ref="11" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>2.4,0,2.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sheet1_.Size}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text3>
            <Text4 Ref="12" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>6.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sum(Sheet1_.Quentity)}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text4>
            <Text5 Ref="13" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>8.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sum( Double.Parse( Sheet1_.Length.Trim("'".ToCharArray()) ))} '</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text5>
            <Text6 Ref="14" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>10.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sum( Double.Parse( Sheet1_.Weight.Trim("lb".ToCharArray()) ))} lb</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text6>
            <Text7 Ref="15" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>12.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>$ {Sum(Sheet1_.Cost)}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text7>
            <Text8 Ref="16" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>14.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{Sum(Sheet1_.__of_Cost)*100} %</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text8>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>GroupFooterBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupFooterBand1>
        <GroupFooterBand2 Ref="17" type="GroupFooterBand" isKey="true">
          <Border>Top;Black;1;Solid;False;4;Black</Border>
          <Brush>Yellow</Brush>
          <ClientRectangle>0,5.4,19,0.6</ClientRectangle>
          <Components isList="true" count="7">
            <Text9 Ref="18" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Guid>7299face57504a079f3e7e015258611d</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text9</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Text>{Sheet1_.Type}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text9>
            <Text10 Ref="19" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>2.4,0,2.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Guid>fe6692011d9d442f898668b69e197e6d</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text10</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Text>{Sheet1_.Size}</Text>
              <TextBrush>Black</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text10>
            <Text11 Ref="20" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>6.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Guid>823c63bf58e0414ab78e120d07290800</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text11</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Text>{Sum(Sheet1_.Quentity)}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text11>
            <Text12 Ref="21" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>8.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Guid>0210f5ba02f14b059753a64c9a7da7a2</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text12</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Text>{Sum( Double.Parse( Sheet1_.Length.Trim("'".ToCharArray()) ))} '</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text12>
            <Text13 Ref="22" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>10.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Guid>a65dc0fac1a748288af7bb8328b38714</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text13</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Text>{Sum( Double.Parse( Sheet1_.Weight.Trim("lb".ToCharArray()) ))} lb</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text13>
            <Text14 Ref="23" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>12.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Guid>e6a3de0db15f4cb99fd9595965a72ae9</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text14</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Text>$ {Sum(Sheet1_.Cost)}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text14>
            <Text15 Ref="24" type="Text" isKey="true">
              <Border>None;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>14.6,0,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Verdana,9,Bold</Font>
              <Guid>ce852b58f1ec4205a9ece822045b4f44</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text15</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Text>{Sum(Sheet1_.__of_Cost)*100} %</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text15>
          </Components>
          <Conditions isList="true" count="0" />
          <Guid>2355f134ae2944818f0abd24fc09df9b</Guid>
          <Name>GroupFooterBand2</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupFooterBand2>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>39e34edf23864e3fac0f8f2664c9df17</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="25" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="26" 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>8/6/2014 9:50:04 AM</ReportChanged>
  <ReportCreated>8/6/2014 9:40:48 AM</ReportCreated>
  <ReportFile>E:\SampleReport.mrt</ReportFile>
  <ReportGuid>791604e2c5b249f88179bfd36315291a</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2014.2.1917</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>