﻿<?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="2">
      <Data Ref="2" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
        <Alias>Data</Alias>
        <BusinessObjects isList="true" count="1">
          <Results Ref="3" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
            <Alias>Results</Alias>
            <BusinessObjects isList="true" count="1">
              <TimeKeys Ref="4" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
                <Alias>TimeKeys</Alias>
                <BusinessObjects isList="true" count="0" />
                <Category />
                <Columns isList="true" count="0" />
                <Dictionary isRef="1" />
                <Guid>b63363f93c72460db259d5b2257de905</Guid>
                <Name>TimeKeys</Name>
              </TimeKeys>
            </BusinessObjects>
            <Category />
            <Columns isList="true" count="6">
              <value>LedgerKey,System.Int32</value>
              <value>ORIGINAL,Average_x0020_Balance,AverageBalance,AverageBalance,System.Nullable`1[System.Double]</value>
              <value>PlanningCenterKey,System.Nullable`1[System.Int32]</value>
              <value>ScenarioKey,System.Nullable`1[System.Int16]</value>
              <value>ORIGINAL,Ending_x0020_Balance,EndingBalance,EndingBalance,System.Nullable`1[System.Double]</value>
              <value>ForecastTimeKey,System.Nullable`1[System.Int32]</value>
            </Columns>
            <Dictionary isRef="1" />
            <Guid>febc934a457f48c3a7266f7884f0fd72</Guid>
            <Name>Results</Name>
          </Results>
        </BusinessObjects>
        <Category>Data</Category>
        <Columns isList="true" count="0" />
        <Dictionary isRef="1" />
        <Guid>97597d1d42c744cba668236130e021be</Guid>
        <Name>Data</Name>
      </Data>
      <StimulsoftBalanceSheetViewModel Ref="5" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
        <Alias>StimulsoftBalanceSheetViewModel</Alias>
        <BusinessObjects isList="true" count="1">
          <Balances Ref="6" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
            <Alias>Balances</Alias>
            <BusinessObjects isList="true" count="0" />
            <Category />
            <Columns isList="true" count="5">
              <value>AverageBalanceACT,System.Nullable`1[System.Double]</value>
              <value>EndingBalance,System.Nullable`1[System.Double]</value>
              <value>HorizonMonth,System.String</value>
              <value>AverageBalanceCP,System.Nullable`1[System.Double]</value>
              <value>AverageBalanceNB,System.Nullable`1[System.Double]</value>
            </Columns>
            <Dictionary isRef="1" />
            <Guid>70ce45915c6a4bd496bb8bffc0687885</Guid>
            <Name>Balances</Name>
          </Balances>
        </BusinessObjects>
        <Category />
        <Columns isList="true" count="0" />
        <Dictionary isRef="1" />
        <Guid>fc7e63f5bd2c49f6b0722a078916c9e6</Guid>
        <Name>StimulsoftBalanceSheetViewModel</Name>
      </StimulsoftBalanceSheetViewModel>
    </BusinessObjects>
    <Databases isList="true" count="1">
      <Connection Ref="7" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>Connection</Alias>
        <ConnectionStringEncrypted>+WzVSVZZ00HiR+XM6kxpe97IywvGVgFZ+QC53E1csS/TavmJxVfjGWFJuYBhXOsbxXTbwk1B+5nLSf3MenBsD9FaU0lPUZOBRUZh3Gd4YA7EWg==</ConnectionStringEncrypted>
        <Name>Connection</Name>
      </Connection>
    </Databases>
    <DataSources isList="true" count="0" />
    <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="8" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <PageHeaderBand1 Ref="9" type="PageHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,10.91,0.3</ClientRectangle>
          <Components isList="true" count="1">
            <ReportName Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,0.1,1.6,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Editable>True</Editable>
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>ReportName</Name>
              <Page isRef="8" />
              <Parent isRef="9" />
              <Text>Balance Sheet Report</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </ReportName>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>PageHeaderBand1</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
        </PageHeaderBand1>
        <HeaderBand1 Ref="11" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.9,10.91,0.3</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <Name>HeaderBand1</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
        </HeaderBand1>
        <CrossTab1 Ref="12" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid>70ce45915c6a4bd496bb8bffc0687885</BusinessObjectGuid>
          <ClientRectangle>0,1.4,10.6,1.3</ClientRectangle>
          <Components isList="true" count="12">
            <CrossTab1_SumHeader1 Ref="13" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>SkyBlue</Brush>
              <ClientRectangle>0.1,0.24,1.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>2ee62cdb01874b599606dd5474e6fbff</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader1</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Average Balance - ACT</Text>
              <TextBrush>[0:56:85]</TextBrush>
            </CrossTab1_SumHeader1>
            <CrossTab1_SumHeader2 Ref="14" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>SkyBlue</Brush>
              <ClientRectangle>0.1,0.44,1.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>4cdd45056bc842ecb01647048f73c694</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader2</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Average Balance - CP</Text>
              <TextBrush>[0:56:85]</TextBrush>
            </CrossTab1_SumHeader2>
            <CrossTab1_SumHeader3 Ref="15" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>SkyBlue</Brush>
              <ClientRectangle>0.1,0.64,1.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>bdc9aa490a29415c9ed0c02e3a96de6c</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader3</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Average Balance - NB</Text>
              <TextBrush>[0:56:85]</TextBrush>
            </CrossTab1_SumHeader3>
            <CrossTab1_SumHeader4 Ref="16" type="Stimulsoft.Report.CrossTab.StiCrossSummaryHeader" isKey="true">
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>SkyBlue</Brush>
              <ClientRectangle>0.1,0.84,1.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>481dd55dd7464937908dd067e707eff2</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SumHeader4</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Ending Balance</Text>
              <TextBrush>[0:56:85]</TextBrush>
            </CrossTab1_SumHeader4>
            <CrossTab1_SummaryTitle Ref="17" type="CrossTitle" isKey="true">
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>SkyBlue</Brush>
              <ClientRectangle>0,0.24,0.1,0.8</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>fc3006b8347d4144b969e77fae797a1a</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_SummaryTitle</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <TextBrush>[0:56:85]</TextBrush>
              <TypeOfComponent>SummaryTitle</TypeOfComponent>
            </CrossTab1_SummaryTitle>
            <CrossTab1_ColTotal1 Ref="18" type="CrossColumnTotal" isKey="true">
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>[185:255:255]</Brush>
              <ClientRectangle>2.12,0.02,0.3,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>76368fcae2aa4cba910585eab99abc18</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_ColTotal1</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_ColTotal1>
            <CrossTab1_Column1 Ref="19" type="CrossColumn" isKey="true">
              <Alias>HorizonMonth</Alias>
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>SkyBlue</Brush>
              <ClientRectangle>1.32,0.02,0.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{StimulsoftBalanceSheetViewModel.Balances.HorizonMonth}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>2d1fde8d67ca4dcdb0700b07e325314e</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Column1</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>HorizonMonth</Text>
              <TextBrush>[0:56:85]</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <TotalGuid>76368fcae2aa4cba910585eab99abc18</TotalGuid>
              <Value>{StimulsoftBalanceSheetViewModel.Balances.AverageBalance}{StimulsoftBalanceSheetViewModel.Balances.HorizonMonth}</Value>
            </CrossTab1_Column1>
            <CrossTab1_Sum1 Ref="20" type="CrossSummary" isKey="true">
              <Alias>AverageBalanceACT</Alias>
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>[235:255:255]</Brush>
              <ClientRectangle>1.32,0.24,0.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>8a46759f815f42f29f00dde0678d8444</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum1</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>[0:56:85]</TextBrush>
              <Value>{StimulsoftBalanceSheetViewModel.Balances.AverageBalanceACT}</Value>
            </CrossTab1_Sum1>
            <CrossTab1_Sum2 Ref="21" type="CrossSummary" isKey="true">
              <Alias>AverageBalanceNB</Alias>
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>[235:255:255]</Brush>
              <ClientRectangle>1.32,0.44,0.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>d512154f25694f04855f9fbe5dab3c67</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum2</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>[0:56:85]</TextBrush>
              <Value>{StimulsoftBalanceSheetViewModel.Balances.AverageBalanceNB}</Value>
            </CrossTab1_Sum2>
            <CrossTab1_Sum3 Ref="22" type="CrossSummary" isKey="true">
              <Alias>AverageBalanceCP</Alias>
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>[235:255:255]</Brush>
              <ClientRectangle>1.32,0.64,0.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>3658377181e84de19d5c60d4e9a7df16</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum3</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>[0:56:85]</TextBrush>
              <Value>{StimulsoftBalanceSheetViewModel.Balances.AverageBalanceCP}</Value>
            </CrossTab1_Sum3>
            <CrossTab1_Sum4 Ref="23" type="CrossSummary" isKey="true">
              <Alias>EndingBalance</Alias>
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>[235:255:255]</Brush>
              <ClientRectangle>1.32,0.84,0.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>0d2840eb923646d1ad808b1b19605555</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum4</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>0</Text>
              <TextBrush>[0:56:85]</TextBrush>
              <Value>{StimulsoftBalanceSheetViewModel.Balances.EndingBalance}</Value>
            </CrossTab1_Sum4>
            <CrossTab1_Column1_Title Ref="24" type="CrossTitle" isKey="true">
              <Border>All;[35:106:135];1;Solid;False;4;Black</Border>
              <Brush>SkyBlue</Brush>
              <ClientRectangle>0,0.02,2.1,0.2</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>ebf93de3cad6419e899cd046b3800762</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Column1_Title</Name>
              <Page isRef="8" />
              <Parent isRef="12" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>HorizonMonth</Text>
              <TextBrush>[0:56:85]</TextBrush>
              <TypeOfComponent>Col:CrossTab1_Column1</TypeOfComponent>
            </CrossTab1_Column1_Title>
          </Components>
          <Conditions isList="true" count="0" />
          <CrossTabStyleIndex>5</CrossTabStyleIndex>
          <DataRelationName />
          <DataSourceName />
          <EmptyValue />
          <Filters isList="true" count="0" />
          <Name>CrossTab1</Name>
          <Page isRef="8" />
          <Parent isRef="8" />
          <Sort isList="true" count="0" />
        </CrossTab1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>4d8a899790cc4607872ef62529f09f36</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <Orientation>Landscape</Orientation>
      <PageHeight>8.27</PageHeight>
      <PageWidth>11.69</PageWidth>
      <PaperSize>A4</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>BalanceSheetReport</ReportAlias>
  <ReportChanged>12/26/2012 1:48:29 PM</ReportChanged>
  <ReportCreated>9/18/2012 11:13:07 AM</ReportCreated>
  <ReportFile>C:\Trunk\BudgetAndPlanning\Budgeting\BalanceSheetReport.mrt</ReportFile>
  <ReportGuid>dce8b2f5d1c844378eee98d2c31c6f4e</ReportGuid>
  <ReportName>BalanceSheetReport</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2012.3.1500</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  : Stimulsoft.Report.StiReport
    {
        public ()        {
            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="1">
    <HeaderBand1Style Ref="27" type="Stimulsoft.Report.StiStyle" isKey="true">
      <Border>All;Black;1;Solid;False;4;Black</Border>
      <Brush>White</Brush>
      <Conditions isList="true" count="0" />
      <Description>Style based on formating of 'HeaderBand1' component</Description>
      <Font>Arial,8</Font>
      <Name>HeaderBand1Style</Name>
      <TextBrush>GlareBrush,Black,White,0,0.5,1</TextBrush>
    </HeaderBand1Style>
  </Styles>
</StiSerializer>