﻿<?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>D:\Support\post-5179\CrossTabData.xml</PathData>
        <PathSchema>D:\Support\post-5179\CrossTabData.xsd</PathSchema>
      </Connection>
    </Databases>
    <DataSources isList="true" count="1">
      <Detail Ref="3" type="DataTableSource" isKey="true">
        <Alias>Detail</Alias>
        <Columns isList="true" count="4">
          <value>CompName,System.String</value>
          <value>ProdName,System.String</value>
          <value>UnitPrice,System.Decimal</value>
          <value>Quantity,System.UInt16</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Detail</Name>
        <NameInSource>Connection.Detail</NameInSource>
      </Detail>
    </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="1">
        <CrossTab1 Ref="5" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0.5,0.5,3.8,1.8</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,0.84,0.7,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>834a994af6f4498d9eb0156c302f311f</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <ProcessCellEvent>if (e.Cell.SummaryIndex == 2 &amp;&amp; e.Value &lt; 500)
{
	e.Text = "Poor: " + e.Value;
}
else if (e.Cell.SummaryIndex == 2 &amp;&amp; e.Value &lt; 750)
{
	e.Cell.Field.TextBrush = new Stimulsoft.Base.Drawing.StiSolidBrush(System.Drawing.Color.Blue);
	Stimulsoft.Report.Components.StiConditionHelper.ApplyFont(e.Cell.Field, new System.Drawing.Font("Arial", 8F, System.Drawing.FontStyle.Bold), Stimulsoft.Report.Components.StiConditionPermissions.All);
	e.Text = "Fair: " + e.Value;
}
else if (e.Cell.SummaryIndex == 2)
{
	e.Text = "Good: " + e.Value;
}</ProcessCellEvent>
              <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.22,0.7,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>9f38bf124e13479792f9387468e10e7c</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1_Title</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>CompName</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>1.12,0.22,0,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>d6f9a740e6164eaa90c37468795090a5</Guid>
              <HorAlignment>Center</HorAlignment>
              <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,0.7,0.2</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>ff68b2dab40a4e26b8afb5b814ebef16</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_LeftTitle</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Detail</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>0.72,0.42,0.3,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>9d5213b42c464c539b4ff4938b370f7b</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Unit Price</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.02,0.42,0.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>a9450941033b4fb19dbac917dcf98ae0</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader2</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Quantity</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.12,0.42,0.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>eddbb049194a41608fc774a9779871d4</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader3</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total Price</Text>
              <TextBrush>[105:105:105]</TextBrush>
            </CrossTab1_SumHeader3>
            <CrossTab1_Row1 Ref="13" type="CrossRow" isKey="true">
              <Alias>CompName</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.64,0.7,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{Detail.CompName}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>d4a005049cc24285bb1cfa3e34ae9c70</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>CompName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>834a994af6f4498d9eb0156c302f311f</TotalGuid>
              <Value>{Detail.CompName}</Value>
            </CrossTab1_Row1>
            <CrossTab1_Column1 Ref="14" type="CrossColumn" isKey="true">
              <Alias>ProdName</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0.72,0.22,0.5,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{Detail.ProdName}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>2828744563464ab588ffbd039d90f336</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Column1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>ProdName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>d6f9a740e6164eaa90c37468795090a5</TotalGuid>
              <Value>{Detail.ProdName}</Value>
            </CrossTab1_Column1>
            <CrossTab1_Sum1 Ref="15" type="CrossSummary" isKey="true">
              <Alias>UnitPrice</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0.72,0.64,0.3,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>6096a8fcc53d42a893c292beb26919a7</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>{Detail.UnitPrice}</Value>
            </CrossTab1_Sum1>
            <CrossTab1_Sum2 Ref="16" type="CrossSummary" isKey="true">
              <Alias>Quantity</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>1.02,0.64,0.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>0f720a17979946209a6a87ae13a5582d</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>{Detail.Quantity}</Value>
            </CrossTab1_Sum2>
            <CrossTab1_Sum3 Ref="17" type="CrossSummary" isKey="true">
              <Alias>Quantity</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>1.12,0.64,0.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>93b49746aae142dea4331bc1c59aa363</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum3</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <Value>{Detail.Quantity*Detail.UnitPrice}</Value>
            </CrossTab1_Sum3>
            <CrossTab1_RightTitle Ref="18" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0.72,0,0.5,0.2</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>0f0737b65c764fa7b1b7d8acd4f72c31</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RightTitle</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>ProdName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>RightTitle</TypeOfComponent>
            </CrossTab1_RightTitle>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName />
          <DataSourceName>Detail</DataSourceName>
          <EmptyValue />
          <Filters isList="true" count="0" />
          <Name>CrossTab1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
          <SummaryDirection>LeftToRight</SummaryDirection>
        </CrossTab1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>be293ac39b9143d2b0f4c8ef07f13fe6</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>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>9/8/2011 4:14:04 PM</ReportChanged>
  <ReportCreated>9/1/2011 6:44:39 AM</ReportCreated>
  <ReportFile>D:\Support\post-5179\CrossTab.mrt</ReportFile>
  <ReportGuid>7d155b2b756a41b4a41a26bb00c19923</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2011.2.1027</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>