﻿<?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">
      <Demo Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
        <Alias>Demo</Alias>
        <Key />
        <Name>Demo</Name>
        <PathData>D:\Stimulsoft.Reports\Reports\Demo.xml</PathData>
        <PathSchema>D:\Stimulsoft.Reports\Reports\Demo.xsd</PathSchema>
      </Demo>
    </Databases>
    <DataSources isList="true" count="1">
      <Orders Ref="3" type="DataTableSource" isKey="true">
        <Alias>Orders</Alias>
        <Columns isList="true" count="14">
          <value>OrderID,System.Int32</value>
          <value>CustomerID,System.String</value>
          <value>EmployeeID,System.Int32</value>
          <value>OrderDate,System.DateTime</value>
          <value>RequiredDate,System.DateTime</value>
          <value>ShippedDate,System.DateTime</value>
          <value>ShipVia,System.Int32</value>
          <value>Freight,System.Decimal</value>
          <value>ShipName,System.String</value>
          <value>ShipAddress,System.String</value>
          <value>ShipCity,System.String</value>
          <value>ShipRegion,System.String</value>
          <value>ShipPostalCode,System.String</value>
          <value>ShipCountry,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <NameInSource>Demo.Orders</NameInSource>
      </Orders>
    </DataSources>
    <Relations isList="true" count="0" />
    <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="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <CrossTab1 Ref="5" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0,19,5.4</ClientRectangle>
          <Components isList="true" count="13">
            <CrossTab1_RowTotal1 Ref="6" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0,2.1,2,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>0670794ba57f45ef91aea2192f9bf941</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal1>
            <CrossTab1_Row1_Title Ref="7" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.45,2,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>481e01334ca749729dcd1b3910a839c8</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1_Title</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>CustomerID</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row1</TypeOfComponent>
            </CrossTab1_Row1_Title>
            <CrossTab1_ColTotal1 Ref="8" type="CrossColumnTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>3.85,0.45,0.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>dd9a8ea354b74df6a4c25e035ce4dc3f</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_ColTotal1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_ColTotal1>
            <CrossTab1_LeftTitle Ref="9" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0,2,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>f8a31221911142c0a22ab35d09994e0f</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_LeftTitle</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Orders</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>LeftTitle</TypeOfComponent>
            </CrossTab1_LeftTitle>
            <CrossTab1_SumHeader1 Ref="10" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>1.6,0.9,0.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>4fef165f0f7e42f49af7a0c534b7f128</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>1</Text>
              <TextBrush>[105:105:105]</TextBrush>
            </CrossTab1_SumHeader1>
            <CrossTab1_SumHeader2 Ref="11" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>1.6,1.3,0.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>daabfa96608646ff9a49935f843b5423</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader2</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>2</Text>
              <TextBrush>[105:105:105]</TextBrush>
            </CrossTab1_SumHeader2>
            <CrossTab1_SumHeader3 Ref="12" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>1.6,1.7,0.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>dd281cc778e3427495784a7cb79f347d</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader3</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>3</Text>
              <TextBrush>[105:105:105]</TextBrush>
            </CrossTab1_SumHeader3>
            <CrossTab1_RightTitle Ref="13" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>2.05,0,2.6,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>8cd4670ec71f4900abcbd4b0a61de59f</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RightTitle</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>EmployeeID</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>RightTitle</TypeOfComponent>
            </CrossTab1_RightTitle>
            <CrossTab1_Row1 Ref="14" type="CrossRow" isKey="true">
              <Alias>CustomerID</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.9,1.6,1.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{Orders.CustomerID}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>65baedf52cba4674b2ad0cb7bf94bae0</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>CustomerID</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>0670794ba57f45ef91aea2192f9bf941</TotalGuid>
              <Value>{Orders.CustomerID}</Value>
            </CrossTab1_Row1>
            <CrossTab1_Column1 Ref="15" type="CrossColumn" isKey="true">
              <Alias>EmployeeID</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>2.05,0.45,1.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{Orders.EmployeeID}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>d14972bf0e6e4e6c9130754910e1f1ce</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Column1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>EmployeeID</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>dd9a8ea354b74df6a4c25e035ce4dc3f</TotalGuid>
              <Value>{Orders.EmployeeID}</Value>
            </CrossTab1_Column1>
            <CrossTab1_Sum1 Ref="16" type="CrossSummary" isKey="true">
              <Alias>Freight</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>2.05,0.9,1.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>74d15ae049854a85954953e7289185d8</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <Value>{Orders.Freight*2}</Value>
            </CrossTab1_Sum1>
            <CrossTab1_Sum2 Ref="17" type="CrossSummary" isKey="true">
              <Alias>Freight</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>2.05,1.3,1.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>00258234e05240d6a3c00eeb89086ff8</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum2</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <Value>{Orders.Freight}</Value>
            </CrossTab1_Sum2>
            <CrossTab1_Sum3 Ref="18" type="CrossSummary" isKey="true">
              <Alias>Freight</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>2.05,1.7,1.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>415ebc94f5de474cac0a9f3961a8ac4f</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum3</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <ProcessCellEvent>if (Cells[0,-1]&gt; 0)
e.Value = Cells[0,-2] / Cells[0, -1];
else
e.Text = "NONE";
</ProcessCellEvent>
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <Value>{Orders.Freight}</Value>
            </CrossTab1_Sum3>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>Orders</DataSourceName>
          <EmptyValue />
          <Filters isList="true" count="0" />
          <Name>CrossTab1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </CrossTab1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>3b7c35a6ac5748e8b641e604720c972a</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <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>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>11/23/2017 1:22:35 PM</ReportChanged>
  <ReportCreated>11/23/2017 1:16:35 PM</ReportCreated>
  <ReportFile />
  <ReportGuid>08a38627e1944b36899bb046a23f3c79</ReportGuid>
  <ReportImage isNull="true" />
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2017.2.4.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>