﻿<?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">
      <Data Ref="2" type="Stimulsoft.Report.Dictionary.StiExcelDatabase" isKey="true">
        <Alias>Data</Alias>
        <Key />
        <Name>Data</Name>
        <PathData>C:\Users\Ian_3\Downloads\Software\Stimulsoft\New folder\Data.xlsx</PathData>
      </Data>
    </Databases>
    <DataSources isList="true" count="3">
      <cols Ref="3" type="DataTableSource" isKey="true">
        <Alias>cols</Alias>
        <Columns isList="true" count="1">
          <value>Column,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>cols</Name>
        <NameInSource>Data.cols</NameInSource>
      </cols>
      <data Ref="4" type="DataTableSource" isKey="true">
        <Alias>data</Alias>
        <Columns isList="true" count="3">
          <value>Column,System.String</value>
          <value>Row,System.Double</value>
          <value>Data,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>data</Name>
        <NameInSource>Data.data</NameInSource>
      </data>
      <rows Ref="5" type="DataTableSource" isKey="true">
        <Alias>rows</Alias>
        <Columns isList="true" count="1">
          <value>Rows,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>rows</Name>
        <NameInSource>Data.rows</NameInSource>
      </rows>
    </DataSources>
    <Relations isList="true" count="1">
      <Name Ref="6" type="DataRelation" isKey="true">
        <Alias>Name</Alias>
        <ChildColumns isList="true" count="1">
          <value>Column</value>
        </ChildColumns>
        <ChildSource isRef="4" />
        <Dictionary isRef="1" />
        <Name>Name</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>Column</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </Name>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="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="7" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <Headerrows Ref="8" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.15,7.72,0.3</ClientRectangle>
          <Components isList="true" count="2">
            <CrossHeaderBand2 Ref="9" type="Stimulsoft.Report.Components.StiCrossHeaderBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,0.45,0.3</ClientRectangle>
              <Components isList="true" count="0" />
              <Conditions isList="true" count="0" />
              <Guid>e1d966b7515843f5a40db4ec9fdc33a0</Guid>
              <Name>CrossHeaderBand2</Name>
              <Page isRef="7" />
              <Parent isRef="8" />
            </CrossHeaderBand2>
            <CrossDataBand3 Ref="10" type="CrossDataBand" isKey="true">
              <Brush>Transparent</Brush>
              <BusinessObjectGuid isNull="true" />
              <ClientRectangle>0.45,0,0.4,0.3</ClientRectangle>
              <Components isList="true" count="1">
                <Text4 Ref="11" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,0.4,0.3</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>3039b1e74ea04d3994b44e6c00cb1f3a</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text4</Name>
                  <Page isRef="7" />
                  <Parent isRef="10" />
                  <Text>{cols.Column}</Text>
                  <TextBrush>[192:80:77]</TextBrush>
                  <Type>Expression</Type>
                </Text4>
              </Components>
              <Conditions isList="true" count="0" />
              <DataRelationName isNull="true" />
              <DataSourceName>cols</DataSourceName>
              <Filters isList="true" count="0" />
              <Guid>85c6e32c3e944292877ecbbf2dd5cffd</Guid>
              <Name>CrossDataBand3</Name>
              <Page isRef="7" />
              <Parent isRef="8" />
              <Sort isList="true" count="0" />
            </CrossDataBand3>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Headerrows</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
        </Headerrows>
        <Datarows Ref="12" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.75,7.72,0.3</ClientRectangle>
          <Components isList="true" count="3">
            <CrossHeaderBand1 Ref="13" type="Stimulsoft.Report.Components.StiCrossHeaderBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,0.45,0.3</ClientRectangle>
              <Components isList="true" count="1">
                <Text1 Ref="14" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,0.45,0.3</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text1</Name>
                  <Page isRef="7" />
                  <Parent isRef="13" />
                  <Text>{rows.Rows}</Text>
                  <TextBrush>[186:20:25]</TextBrush>
                  <Type>DataColumn</Type>
                </Text1>
              </Components>
              <Conditions isList="true" count="0" />
              <Name>CrossHeaderBand1</Name>
              <Page isRef="7" />
              <Parent isRef="12" />
            </CrossHeaderBand1>
            <CrossDataBand1 Ref="15" type="CrossDataBand" isKey="true">
              <Brush>Transparent</Brush>
              <BusinessObjectGuid isNull="true" />
              <ClientRectangle>0.45,0,0.4,0.3</ClientRectangle>
              <Components isList="true" count="1">
                <Text2 Ref="16" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,0.4,0.3</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text2</Name>
                  <Page isRef="7" />
                  <Parent isRef="15" />
                  <Text>{SumIf(CrossDataBand2, data.Data, data.Row == rows.Rows)}</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                </Text2>
              </Components>
              <Conditions isList="true" count="0" />
              <DataRelationName isNull="true" />
              <DataSourceName>cols</DataSourceName>
              <Filters isList="true" count="0" />
              <MasterComponent isRef="12" />
              <Name>CrossDataBand1</Name>
              <Page isRef="7" />
              <Parent isRef="12" />
              <Sort isList="true" count="0" />
            </CrossDataBand1>
            <CrossDataBand2 Ref="17" type="CrossDataBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.85,0,0.4,0.3</ClientRectangle>
              <Components isList="true" count="0" />
              <Conditions isList="true" count="0" />
              <DataRelationName>Relation</DataRelationName>
              <DataSourceName>data</DataSourceName>
              <Filters isList="true" count="0" />
              <MasterComponent isRef="15" />
              <Name>CrossDataBand2</Name>
              <Page isRef="7" />
              <Parent isRef="12" />
              <Sort isList="true" count="0" />
            </CrossDataBand2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>rows</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>Datarows</Name>
          <Page isRef="7" />
          <Parent isRef="7" />
          <Sort isList="true" count="0" />
        </Datarows>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>ba188ec9bc234628822f89cbc6cf2851</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="18" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="19" 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/27/2017 5:19:56 PM</ReportChanged>
  <ReportCreated>12/27/2017 5:11:25 PM</ReportCreated>
  <ReportFile />
  <ReportGuid>8e394fccd1bd452e84a50896c3188dcf</ReportGuid>
  <ReportImage isNull="true" />
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2018.1.1.0</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>