﻿<?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.StiSqlDatabase" isKey="true">
        <Alias>Connection</Alias>
        <ConnectionStringEncrypted />
        <Name>Connection</Name>
      </Connection>
    </Databases>
    <DataSources isList="true" count="2">
      <TTT Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>TTT</Alias>
        <Columns isList="true" count="8">
          <value>CATEGORY_ID,System.String</value>
          <value>C_ID,System.Int64</value>
          <value>PRODUCT_ID,System.Int32</value>
          <value>UNIT_PRICE,System.String</value>
          <value>DISCOUNT,System.String</value>
          <value>SEGMENT,System.String</value>
          <value>M_NAME,System.String</value>
          <value>BREAK,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>TTT</Name>
        <NameInSource>Connection</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT TTT.CATEGORY_ID, TTT.C_ID, TTT.PRODUCT_ID, TTT.UNIT_PRICE, TTT.DISCOUNT,
  TTT.SEGMENT, TTT.M_NAME, TTT.[BREAK]
FROM TTT</SqlCommand>
      </TTT>
      <C Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>C</Alias>
        <Columns isList="true" count="2">
          <value>C_ID,System.Int64</value>
          <value>C_NAME,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>C</Name>
        <NameInSource>Connection</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT DISTINCT TTT.C_ID, TTT.C_NAME
FROM TTT</SqlCommand>
      </C>
    </DataSources>
    <Relations isList="true" count="1">
      <Name Ref="5" type="DataRelation" isKey="true">
        <Alias>Name</Alias>
        <ChildColumns isList="true" count="1">
          <value>C_ID</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>Name</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>C_ID</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Name>
    </Relations>
    <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="6" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <DataBand3 Ref="7" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.2,7.72,0.3</ClientRectangle>
          <Components isList="true" count="1">
            <Text1 Ref="8" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,1.5,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>{C.C_NAME}</Text>
              <TextBrush>Black</TextBrush>
            </Text1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>C</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand3</Name>
          <NewPageAfter>True</NewPageAfter>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </DataBand3>
        <DataBand1 Ref="9" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.9,7.72,2.2</ClientRectangle>
          <Components isList="true" count="1">
            <CrossTab1 Ref="10" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0.2,4.4,1.6</ClientRectangle>
              <Components isList="true" count="14">
                <CrossTab1_ColTotal1 Ref="11" type="CrossColumnTotal" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>1.92,0.22,0,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>143fd191c7f34937aa664b07e25acede</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_ColTotal1</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab1_ColTotal1>
                <CrossTab1_RowTotal1 Ref="12" type="CrossRowTotal" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>0.3,0.84,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>9614febb6aba49d8b4953ba93b7ea4ab</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_RowTotal1</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab1_RowTotal1>
                <CrossTab1_Row1_Title Ref="13" 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.2</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>488b916cdd82450ea4ff280e1fd33ada</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Row1_Title</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>DISCOUNT</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TypeOfComponent>Row:CrossTab1_Row1</TypeOfComponent>
                </CrossTab1_Row1_Title>
                <CrossTab1_LeftTitle Ref="14" type="CrossTitle" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>0,0,1.8,0.2</ClientRectangle>
                  <Enabled>False</Enabled>
                  <Font>Arial,8</Font>
                  <Guid>b9090063109f43cea956cfd41f155d1e</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_LeftTitle</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>TTT</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TypeOfComponent>LeftTitle</TypeOfComponent>
                </CrossTab1_LeftTitle>
                <CrossTab1_RowTotal2 Ref="15" type="CrossRowTotal" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>1,0.84,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>9fd4a51a788641e48f76d1c6b58b0870</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_RowTotal2</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab1_RowTotal2>
                <CrossTab1_Row2_Title Ref="16" type="CrossTitle" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>0.7,0.22,1.1,0.2</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>b40d2f12ecb746ae85e46443a1cd7162</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Row2_Title</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>BREAK</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TypeOfComponent>Row:CrossTab1_Row2</TypeOfComponent>
                </CrossTab1_Row2_Title>
                <CrossTab1_SumHeader1 Ref="17" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>1.7,0.44,0.1,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Enabled>False</Enabled>
                  <Font>Arial,8</Font>
                  <Guid>bb3720b2b2b144d397d050c108b9dca3</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_SumHeader1</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>1</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                </CrossTab1_SumHeader1>
                <CrossTab1_SumHeader2 Ref="18" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>1.7,0.64,0.1,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Enabled>False</Enabled>
                  <Font>Arial,8</Font>
                  <Guid>6bac4c9f185f4e5ca8f0d90c4afafc93</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_SumHeader2</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>2</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                </CrossTab1_SumHeader2>
                <CrossTab1_RightTitle Ref="19" type="CrossTitle" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>1.82,0,0.6,0.2</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>6ec7f3fde82748f8a0675ce005390967</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_RightTitle</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>SEGMENT</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TypeOfComponent>RightTitle</TypeOfComponent>
                </CrossTab1_RightTitle>
                <CrossTab1_Row1 Ref="20" type="CrossRow" isKey="true">
                  <Alias>DISCOUNT</Alias>
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>0,0.44,0.7,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{TTT.DISCOUNT}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>f8823cd8725b41a298865ccab660e7c8</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Row1</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>DISCOUNT</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TotalGuid>9614febb6aba49d8b4953ba93b7ea4ab</TotalGuid>
                  <Value>{TTT.DISCOUNT}</Value>
                </CrossTab1_Row1>
                <CrossTab1_Row2 Ref="21" type="CrossRow" isKey="true">
                  <Alias>BREAK</Alias>
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>0.7,0.44,1,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{TTT.BREAK}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>de2fb6ae3201464d9cf2e7aad27f6a07</Guid>
                  <Margins>0,0,0,0</Margins>
                  <MinSize>1,0</MinSize>
                  <Name>CrossTab1_Row2</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>BREAK</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TotalGuid>9fd4a51a788641e48f76d1c6b58b0870</TotalGuid>
                  <Value>{TTT.BREAK}</Value>
                </CrossTab1_Row2>
                <CrossTab1_Column1 Ref="22" type="CrossColumn" isKey="true">
                  <Alias>SEGMENT</Alias>
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>1.82,0.22,0.6,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{TTT.SEGMENT}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>e24bfac74b6145499d5e4a156c14301e</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Column1</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <Text>SEGMENT</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TotalGuid>143fd191c7f34937aa664b07e25acede</TotalGuid>
                  <Value>{TTT.SEGMENT}</Value>
                </CrossTab1_Column1>
                <CrossTab1_Sum1 Ref="23" type="CrossSummary" isKey="true">
                  <Alias>UNIT_PRICE</Alias>
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>1.82,0.44,0.6,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>3d041cc90653414a8acdb7fe50df8042</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Sum1</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Summary>None</Summary>
                  <Text>0</Text>
                  <TextBrush>Black</TextBrush>
                  <Value>{TTT.UNIT_PRICE}</Value>
                </CrossTab1_Sum1>
                <CrossTab1_Sum2 Ref="24" type="CrossSummary" isKey="true">
                  <Alias>M_NAME</Alias>
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>1.82,0.64,0.6,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>f84226879cab48078568b58fbf9d98f2</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Sum2</Name>
                  <Page isRef="6" />
                  <Parent isRef="10" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Summary>None</Summary>
                  <Text>0</Text>
                  <TextBrush>Black</TextBrush>
                  <Value>{TTT.M_NAME}</Value>
                </CrossTab1_Sum2>
              </Components>
              <Conditions isList="true" count="0" />
              <DataRelationName />
              <DataSourceName>TTT</DataSourceName>
              <EmptyValue />
              <FilterOn>False</FilterOn>
              <Filters isList="true" count="0" />
              <Name>CrossTab1</Name>
              <Page isRef="6" />
              <Parent isRef="9" />
              <Sort isList="true" count="0" />
            </CrossTab1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName>Relation</DataRelationName>
          <DataSourceName>TTT</DataSourceName>
          <FilterOn>False</FilterOn>
          <Filters isList="true" count="0" />
          <MasterComponent isRef="7" />
          <Name>DataBand1</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </DataBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>db2d1be38d9c4a9b8dd97c25644e5ef5</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="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/1/2013 10:01:26 PM</ReportChanged>
  <ReportCreated>7/3/2013 8:40:12 PM</ReportCreated>
  <ReportFile>C:\Users\Administrator.RND14\Downloads\SampleReport.mrt</ReportFile>
  <ReportGuid>767a542962e74ad5aff351b6ce379eb1</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2013.1.1600</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>