﻿<?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="0" />
    <DataSources isList="true" count="1">
      <DataSource2 Ref="2" type="Stimulsoft.Report.Dictionary.StiCsvSource" isKey="true">
        <Alias>DataSource2</Alias>
        <CodePage>65001</CodePage>
        <Columns isList="true" count="11">
          <value>emp_id,System.String</value>
          <value>code,System.String</value>
          <value>description,System.String</value>
          <value>amount,System.String</value>
          <value>glcode,System.String</value>
          <value>JobGroupGL,System.String</value>
          <value>JobGroup,System.String</value>
          <value>group_id,System.String</value>
          <value>GroupCode,System.String</value>
          <value>GroupDesc,System.String</value>
          <value>SortOrder,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>DataSource2</Name>
        <NameInSource>E:\data.csv</NameInSource>
        <Path>E:\data.csv</Path>
      </DataSource2>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="2">
      <value>,Sum1,Sum1,System.Decimal,_x0030_,False,False</value>
      <value>,Sum2,Sum2,System.Decimal,_x0030_,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="3" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <Data1 Ref="4" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,10.52,4.1</ClientRectangle>
          <Components isList="true" count="1">
            <Cross_Tab1 Ref="5" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,6.1,1.6</ClientRectangle>
              <Components isList="true" count="17">
                <Cross_Tab1_ColTotal1 Ref="6" type="CrossColumnTotal" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:229]</Brush>
                  <ClientRectangle>2.52,0.22,0.3,0.3</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>3f727f961f344a71a167f200a16de781</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_ColTotal1</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Tag>{DataSource2.group_id}</Tag>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </Cross_Tab1_ColTotal1>
                <CrossTab1_LeftTitle Ref="7" type="CrossTitle" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>0,0,1.9,0.2</ClientRectangle>
                  <Enabled>False</Enabled>
                  <Font>Arial,8</Font>
                  <Guid>a984f2b49df04de2a2dc5cd1e68a41f4</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_LeftTitle</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>DataSource2</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TypeOfComponent>LeftTitle</TypeOfComponent>
                </CrossTab1_LeftTitle>
                <Cross_Tab1_Row1_Title Ref="8" type="CrossTitle" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>0,0.22,0.5,0.3</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>fdfe6ea4ccf44452ad1c3a3556d19ac8</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Row1_Title</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>group</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TypeOfComponent>Row:Cross_Tab1_Row1</TypeOfComponent>
                </Cross_Tab1_Row1_Title>
                <Cross_Tab1_Row2_Title Ref="9" type="CrossTitle" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>0.5,0.22,0.5,0.3</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>8c6a4bda29a94c3ea33f02d415799625</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Row2_Title</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Gl Code</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TypeOfComponent>Row:Cross_Tab1_Row2</TypeOfComponent>
                </Cross_Tab1_Row2_Title>
                <Cross_Tab1_Row3_Title Ref="10" type="CrossTitle" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>1,0.22,0.3,0.3</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>66204b26cfe24740be7f15e93105094b</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Row3_Title</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Code</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TypeOfComponent>Row:Cross_Tab1_Row3</TypeOfComponent>
                </Cross_Tab1_Row3_Title>
                <Cross_Tab1_RowTotal1 Ref="11" type="CrossRowTotal" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>[192:255:255]</Brush>
                  <ClientRectangle>0,0.94,1.9,0.3</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>48cb6e7e0ce74db7aaeafeccfb956b27</Guid>
                  <Margins>10,0,10,0</Margins>
                  <Name>Cross_Tab1_RowTotal1</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <ProcessCellEvent>if (e.Cell.IsCrossSummary)
{
    e.Value = Sum2;
}
else
{
    e.Value = Sum1;
    Sum2 += Sum1;
    Sum1 = 0;
}
</ProcessCellEvent>
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total (Income - Expenses)</Text>
                  <TextBrush>Black</TextBrush>
                  <Type>Expression</Type>
                </Cross_Tab1_RowTotal1>
                <Cross_Tab1_Row4_Title Ref="12" type="CrossTitle" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>1.3,0.22,0.6,0.3</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>6ec04d7ccbae4951baad5f91700dfd35</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Row4_Title</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Description</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TypeOfComponent>Row:Cross_Tab1_Row4</TypeOfComponent>
                </Cross_Tab1_Row4_Title>
                <Cross_Tab1_RowTotal3 Ref="13" type="CrossRowTotal" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:229]</Brush>
                  <ClientRectangle>1,0.74,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>a090c548086b4f649dc049e48e8cfa4a</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_RowTotal3</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </Cross_Tab1_RowTotal3>
                <Cross_Tab1_RowTotal4 Ref="14" type="CrossRowTotal" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:229]</Brush>
                  <ClientRectangle>1.3,0.74,0,0</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>fbeda46fcb524094b04ab987f35b4c3a</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_RowTotal4</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </Cross_Tab1_RowTotal4>
                <Cross_Tab1_RowTotal2 Ref="15" type="CrossRowTotal" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:229]</Brush>
                  <ClientRectangle>0.5,0.74,1.4,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>309e730ba5ed45b1ba7886fd1b3ddd32</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_RowTotal2</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </Cross_Tab1_RowTotal2>
                <Cross_Tab1_Row1 Ref="16" type="CrossRow" isKey="true">
                  <Alias>group_id</Alias>
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>0,0.54,0.5,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{DataSource2.group_id}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>60c7fe13b3074254b735778205636542</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Row1</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <SortDirection>None</SortDirection>
                  <SortType>ByValue</SortType>
                  <Text>group_id</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TotalGuid>48cb6e7e0ce74db7aaeafeccfb956b27</TotalGuid>
                  <Value>{DataSource2.group_id}
</Value>
                </Cross_Tab1_Row1>
                <Cross_Tab1_Row2 Ref="17" type="CrossRow" isKey="true">
                  <Alias>glcode</Alias>
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>0.5,0.54,0.5,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{DataSource2.glcode}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>b833851c7bbe4a07b4243ad601ddfe8c</Guid>
                  <Margins>0,0,0,0</Margins>
                  <MergeHeaders>False</MergeHeaders>
                  <Name>Cross_Tab1_Row2</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <SortDirection>None</SortDirection>
                  <SortType>ByValue</SortType>
                  <Text>glcode</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TotalGuid>309e730ba5ed45b1ba7886fd1b3ddd32</TotalGuid>
                  <Value>{DataSource2.SortOrder}{DataSource2.glcode}</Value>
                </Cross_Tab1_Row2>
                <Cross_Tab1_Row3 Ref="18" type="CrossRow" isKey="true">
                  <Alias>code</Alias>
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>1,0.54,0.3,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{DataSource2.code}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>e42d320160f7404791c94a82d127518e</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Row3</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <SortDirection>None</SortDirection>
                  <SortType>ByValue</SortType>
                  <Text>code</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TotalGuid>a090c548086b4f649dc049e48e8cfa4a</TotalGuid>
                  <Value>{DataSource2.code}</Value>
                </Cross_Tab1_Row3>
                <Cross_Tab1_Row4 Ref="19" type="CrossRow" isKey="true">
                  <Alias>description</Alias>
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>1.3,0.54,0.6,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{DataSource2.description}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>8df3db874400429ba59f19c712dd6096</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Row4</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <ShowTotal>False</ShowTotal>
                  <SortType>ByValue</SortType>
                  <Text>description</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TotalGuid>fbeda46fcb524094b04ab987f35b4c3a</TotalGuid>
                  <Value>{DataSource2.description}</Value>
                </Cross_Tab1_Row4>
                <Cross_Tab1_Column1 Ref="20" type="CrossColumn" isKey="true">
                  <Alias>JobGroup</Alias>
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>1.92,0.22,0.6,0.3</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{DataSource2.JobGroup}
{DataSource2.JobGroupGL}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>8e975d20a3ff465f8a007d5114c93b48</Guid>
                  <Margins>10,0,10,0</Margins>
                  <Name>Cross_Tab1_Column1</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <SortType>ByValue</SortType>
                  <Text>JobGroup</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=EllipsisWord, WordWrap=False, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
                  <TextQuality>Wysiwyg</TextQuality>
                  <TotalGuid>3f727f961f344a71a167f200a16de781</TotalGuid>
                  <Value>{DataSource2.JobGroupGL}</Value>
                </Cross_Tab1_Column1>
                <Cross_Tab1_Sum1 Ref="21" type="CrossSummary" isKey="true">
                  <Alias>amount</Alias>
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>1.92,0.54,0.6,0.2</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>834a252c2a8947e9a568c4b5cf58bfe5</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_Sum1</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <ProcessCellEvent>if ((string)e.Cell.TagValue == "Income")
{
    Sum1 += e.Value;
}
else
{
	if ((string)e.Cell.TagValue != "MISC")
    	{

Sum1 -= e.Value;
}
};
</ProcessCellEvent>
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Tag>{DataSource2.group_id}</Tag>
                  <Text>0</Text>
                  <TextBrush>Black</TextBrush>
                  <Value>{DataSource2.amount}</Value>
                </Cross_Tab1_Sum1>
                <Cross_Tab1_RightTitle Ref="22" type="CrossTitle" isKey="true">
                  <Border>All;[145:122:79];1;Solid;False;4;Black</Border>
                  <Brush>Wheat</Brush>
                  <ClientRectangle>1.92,0,0.9,0.2</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>ab981eb3e3674936a507868035e46cb3</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>Cross_Tab1_RightTitle</Name>
                  <Page isRef="3" />
                  <Parent isRef="5" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>JobGroup</Text>
                  <TextBrush>[95:72:29]</TextBrush>
                  <TypeOfComponent>RightTitle</TypeOfComponent>
                </Cross_Tab1_RightTitle>
              </Components>
              <Conditions isList="true" count="0" />
              <CrossTabStyleIndex>9</CrossTabStyleIndex>
              <DataRelationName />
              <DataSourceName>DataSource2</DataSourceName>
              <EmptyValue />
              <Filters isList="true" count="0" />
              <KeepCrossTabTogether>True</KeepCrossTabTogether>
              <Name>Cross_Tab1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Printable>False</Printable>
              <Sort isList="true" count="0" />
            </Cross_Tab1>
          </Components>
          <Conditions isList="true" count="0" />
          <CountData>1</CountData>
          <DataRelationName isNull="true" />
          <Filters isList="true" count="0" />
          <Name>Data1</Name>
          <Page isRef="3" />
          <Parent isRef="3" />
          <Sort isList="true" count="0" />
        </Data1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>de3f9cd56e62498ca496e0563c7289fb</Guid>
      <Margins>0.169,1,0.169,0.25</Margins>
      <Name>Page1</Name>
      <Orientation>Landscape</Orientation>
      <PageHeight>8.27</PageHeight>
      <PageWidth>11.69</PageWidth>
      <PaperSize>A4</PaperSize>
      <Report isRef="0" />
      <UnlimitedBreakable>False</UnlimitedBreakable>
      <UnlimitedHeight>True</UnlimitedHeight>
      <Watermark Ref="23" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="24" 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>10/20/2011 2:41:04 PM</ReportChanged>
  <ReportCreated>7/14/2011 3:33:43 PM</ReportCreated>
  <ReportFile>E:\CrossTabRep1.mrt</ReportFile>
  <ReportGuid>668c8074026f419ba8337166b4001c19</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2011.3.1104</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>