﻿<?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>
        <Name>Demo</Name>
        <PathData>C:\Program Files (x86)\Stimulsoft Reports.Ultimate 2015.1 Trial\Bin\Data\Demo.xml</PathData>
        <PathSchema>C:\Program Files (x86)\Stimulsoft Reports.Ultimate 2015.1 Trial\Bin\Data\Demo.xsd</PathSchema>
      </Demo>
    </Databases>
    <DataSources isList="true" count="13">
      <Auto Ref="3" type="DataTableSource" isKey="true">
        <Alias>Auto</Alias>
        <Columns isList="true" count="5">
          <value>Rank,System.Double</value>
          <value>Country,System.String</value>
          <value>Year2009,System.Double</value>
          <value>Year2005,System.Double</value>
          <value>Year2000,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Auto</Name>
        <NameInSource>Demo.Auto</NameInSource>
      </Auto>
      <Categories Ref="4" type="DataTableSource" isKey="true">
        <Alias>Categories</Alias>
        <Columns isList="true" count="4">
          <value>CategoryID,System.Int32</value>
          <value>CategoryName,System.String</value>
          <value>Description,System.String</value>
          <value>Picture,System.Byte[]</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>Demo.Categories</NameInSource>
      </Categories>
      <Countries Ref="5" type="DataTableSource" isKey="true">
        <Alias>Countries</Alias>
        <Columns isList="true" count="3">
          <value>CountriesID,System.Int32</value>
          <value>Flag,System.Byte[]</value>
          <value>CountryName,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Countries</Name>
        <NameInSource>Demo.Countries</NameInSource>
      </Countries>
      <Customers Ref="6" type="DataTableSource" isKey="true">
        <Alias>Customers</Alias>
        <Columns isList="true" count="11">
          <value>CustomerID,System.String</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>Phone,System.String</value>
          <value>Fax,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Customers</Name>
        <NameInSource>Demo.Customers</NameInSource>
      </Customers>
      <Employees Ref="7" type="DataTableSource" isKey="true">
        <Alias>Employees</Alias>
        <Columns isList="true" count="17">
          <value>EmployeeID,System.Int32</value>
          <value>LastName,System.String</value>
          <value>FirstName,System.String</value>
          <value>Title,System.String</value>
          <value>TitleOfCourtesy,System.String</value>
          <value>BirthDate,System.DateTime</value>
          <value>HireDate,System.DateTime</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>HomePhone,System.String</value>
          <value>Extension,System.String</value>
          <value>Photo,System.Byte[]</value>
          <value>Notes,System.String</value>
          <value>ReportsTo,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>Demo.Employees</NameInSource>
      </Employees>
      <GlobalGrowth Ref="8" type="DataTableSource" isKey="true">
        <Alias>GlobalGrowth</Alias>
        <Columns isList="true" count="5">
          <value>Region,System.String</value>
          <value>Year2006,System.Double</value>
          <value>Year2007,System.Double</value>
          <value>Year2008,System.Double</value>
          <value>Year2009,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>GlobalGrowth</Name>
        <NameInSource>Demo.GlobalGrowth</NameInSource>
      </GlobalGrowth>
      <Opec Ref="9" type="DataTableSource" isKey="true">
        <Alias>Opec</Alias>
        <Columns isList="true" count="9">
          <value>Year,System.Double</value>
          <value>Iran,System.Double</value>
          <value>Iraq,System.Double</value>
          <value>Kuwait,System.Double</value>
          <value>Saudi_x0020_Arabia,System.Double</value>
          <value>UAE,System.Double</value>
          <value>Venezuela,System.Double</value>
          <value>Libya,System.Double</value>
          <value>Nigeria,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Opec</Name>
        <NameInSource>Demo.Opec</NameInSource>
      </Opec>
      <Order_x0020_Details Ref="10" type="DataTableSource" isKey="true">
        <Alias>Order Details</Alias>
        <Columns isList="true" count="5">
          <value>OrderID,System.Int32</value>
          <value>ProductID,System.Int32</value>
          <value>UnitPrice,System.Decimal</value>
          <value>Quantity,System.Int16</value>
          <value>Discount,System.Single</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Order Details</Name>
        <NameInSource>Demo.Order Details</NameInSource>
      </Order_x0020_Details>
      <Orders Ref="11" 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>
      <Products Ref="12" type="DataTableSource" isKey="true">
        <Alias>Products</Alias>
        <Columns isList="true" count="10">
          <value>ProductID,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>SupplierID,System.Int32</value>
          <value>CategoryID,System.Int32</value>
          <value>QuantityPerUnit,System.String</value>
          <value>UnitPrice,System.Decimal</value>
          <value>UnitsInStock,System.Int16</value>
          <value>UnitsOnOrder,System.Int16</value>
          <value>ReorderLevel,System.Int16</value>
          <value>Discontinued,System.Boolean</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>Demo.Products</NameInSource>
      </Products>
      <Shippers Ref="13" type="DataTableSource" isKey="true">
        <Alias>Shippers</Alias>
        <Columns isList="true" count="3">
          <value>ShipperID,System.Int32</value>
          <value>CompanyName,System.String</value>
          <value>Phone,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
        <NameInSource>Demo.Shippers</NameInSource>
      </Shippers>
      <States Ref="14" type="DataTableSource" isKey="true">
        <Alias>States</Alias>
        <Columns isList="true" count="4">
          <value>Name,System.String</value>
          <value>USPS,System.String</value>
          <value>Population,System.Int32</value>
          <value>Capital,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>States</Name>
        <NameInSource>Demo.States</NameInSource>
      </States>
      <Suppliers Ref="15" type="DataTableSource" isKey="true">
        <Alias>Suppliers</Alias>
        <Columns isList="true" count="12">
          <value>SupplierID,System.Int32</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>Phone,System.String</value>
          <value>Fax,System.String</value>
          <value>HomePage,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
        <NameInSource>Demo.Suppliers</NameInSource>
      </Suppliers>
    </DataSources>
    <Relations isList="true" count="1">
      <Categories Ref="16" type="DataRelation" isKey="true">
        <Alias>Categories</Alias>
        <ChildColumns isList="true" count="1">
          <value>CategoryID</value>
        </ChildColumns>
        <ChildSource isRef="12" />
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>Beziehung2</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CategoryID</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Categories>
    </Relations>
    <Report isRef="0" />
    <Variables isList="true" count="2">
      <value>,Monatstage,Monatstage,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x005F_x0037__x005F_x002F_1_x005F_x002F_2015_x005F_x0020_11:46:07_x005F_x0020_AM_x002C__x005F_x0037__x005F_x002F_31_x005F_x002F_2015_x005F_x0020_11:46:07_x005F_x0020_AM,False,False</value>
      <value>,Blau,Blau,Stimulsoft.Report.DateTimeRange,DateTime_x002C__x002C_,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="17" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <CrossTab1 Ref="18" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0,19,4.8</ClientRectangle>
          <Components isList="true" count="11">
            <CrossTab1_RowTotal1 Ref="19" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0,1.7,2.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>cd1887e358764704a9723e83a9452afa</Guid>
              <Margins>0,0,0,0</Margins>
              <MergeHeaders>False</MergeHeaders>
              <Name>CrossTab1_RowTotal1</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal1>
            <CrossTab1_Row1_Title Ref="20" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.45,2.4,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>d4f4057a88644019a2667c4657de8e4b</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1_Title</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>ProductName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row1</TypeOfComponent>
            </CrossTab1_Row1_Title>
            <CrossTab1_LeftTitle Ref="21" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0,2.4,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>667eb88247dd475287a9937c09b5bad9</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_LeftTitle</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Products</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>LeftTitle</TypeOfComponent>
            </CrossTab1_LeftTitle>
            <CrossTab1_ColTotal1 Ref="22" type="CrossColumnTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>4.45,0.45,0.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>e119ed5c3cd8472ebe550f2ae713a8f4</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_ColTotal1</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_ColTotal1>
            <CrossTab1_SumHeader1 Ref="23" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>2,0.9,0.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>ae326fc4a24e45029451522498b9bbd4</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader1</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>1</Text>
              <TextBrush>[105:105:105]</TextBrush>
            </CrossTab1_SumHeader1>
            <CrossTab1_SumHeader2 Ref="24" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>2,1.3,0.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>734970d4f4fb47a5b51ad7b9c663cc2d</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader2</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>2</Text>
              <TextBrush>[105:105:105]</TextBrush>
            </CrossTab1_SumHeader2>
            <CrossTab1_RightTitle Ref="25" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>2.45,0,2.8,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>da341d26c3be4a64a3b44476b6218623</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RightTitle</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>CategoryName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>RightTitle</TypeOfComponent>
            </CrossTab1_RightTitle>
            <CrossTab1_Row1 Ref="26" type="CrossRow" isKey="true">
              <Alias>ProductName</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.9,2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{Products.ProductName}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>845dee74307346f197c60769ff775f60</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>ProductName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>cd1887e358764704a9723e83a9452afa</TotalGuid>
              <Value>{Products.ProductName}</Value>
            </CrossTab1_Row1>
            <CrossTab1_Column1 Ref="27" type="CrossColumn" isKey="true">
              <Alias>CategoryName</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>2.45,0.45,2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{Products.Categories.CategoryName}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>3fa491a58199426a9b4caf5c58002afb</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Column1</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>CategoryName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>e119ed5c3cd8472ebe550f2ae713a8f4</TotalGuid>
              <Value>{Products.Categories.CategoryName}</Value>
            </CrossTab1_Column1>
            <CrossTab1_Sum1 Ref="28" type="CrossSummary" isKey="true">
              <Alias>UnitsInStock</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>2.45,0.9,2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>d02b8c3bfc20459ca0ab9ab6ff0f5c9a</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum1</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <Value>{Products.UnitsInStock}</Value>
            </CrossTab1_Sum1>
            <CrossTab1_Sum2 Ref="29" type="CrossSummary" isKey="true">
              <Alias>UnitPrice</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>2.45,1.3,2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>17298e27ab7e4dcc9d11c35a583e5ffd</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum2</Name>
              <Page isRef="17" />
              <Parent isRef="18" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <Value>{Products.UnitPrice}</Value>
            </CrossTab1_Sum2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>Products</DataSourceName>
          <EmptyValue />
          <Filters isList="true" count="0" />
          <Name>CrossTab1</Name>
          <Page isRef="17" />
          <Parent isRef="17" />
          <Sort isList="true" count="0" />
        </CrossTab1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>d42dd66331804ff595f0c693d72001d3</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="30" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="31" 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/19/2015 1:35:05 PM</ReportChanged>
  <ReportCreated>7/24/2015 11:49:05 AM</ReportCreated>
  <ReportFile>C:\Users\jomarten\Desktop\sample_crosstab_merge.mrt</ReportFile>
  <ReportGuid>6d134bae11d749d49731824f5605a369</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2015.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>