﻿<?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="1">
      <Clients Ref="2" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
        <Alias>Clients</Alias>
        <BusinessObjects isList="true" count="1">
          <Qualities Ref="3" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
            <Alias>Qualities</Alias>
            <BusinessObjects isList="true" count="1">
              <PName Ref="4" type="Stimulsoft.Report.Dictionary.StiBusinessObject" isKey="true">
                <Alias>PName</Alias>
                <BusinessObjects isList="true" count="0" />
                <Category />
                <Columns isList="true" count="1">
                  <value>Name,System.String</value>
                </Columns>
                <Dictionary isRef="1" />
                <Guid>b1fa9a7d8b684b6091dd226049041d78</Guid>
                <Name>PName</Name>
              </PName>
            </BusinessObjects>
            <Category />
            <Columns isList="true" count="2">
              <value>Value,System.Int32</value>
              <value>Number,System.Int32</value>
            </Columns>
            <Dictionary isRef="1" />
            <Guid>a1a591317a774ad298bfbe50e52a0972</Guid>
            <Name>Qualities</Name>
          </Qualities>
        </BusinessObjects>
        <Category />
        <Columns isList="true" count="2">
          <value>Id,System.Int32</value>
          <value>Name,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Guid>1ddc239c4abe43be99c7947678000d9d</Guid>
        <Name>Clients</Name>
      </Clients>
    </BusinessObjects>
    <Databases isList="true" count="0" />
    <DataSources isList="true" count="0" />
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="1">
      <value>,columnCount,columnCount,System.Int32,_x0033_,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <NumberOfPass>DoublePass</NumberOfPass>
  <Pages isList="true" count="1">
    <Page3 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <HeaderBand1 Ref="6" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <CanShrink>True</CanShrink>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="3">
            <Text4 Ref="7" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[216:216:216]</Brush>
              <ClientRectangle>0,0,0.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>ID</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text4>
            <Text5 Ref="8" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[216:216:216]</Brush>
              <ClientRectangle>0.8,0,1.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Name</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text5>
            <Text10 Ref="9" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[216:216:216]</Brush>
              <ClientRectangle>17.4,0,1.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text10</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Total</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text10>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </HeaderBand1>
        <DataBand1 Ref="10" type="DataBand" isKey="true">
          <AfterPrintEvent>if (IsFirstPass)
{
    for (int i = 1; i &lt;= columnCount; i++)
    {
        string pageColumn = "p" + PageNumber.ToString() + "c" + i.ToString();
        if (!colValues.ContainsKey(pageColumn))
            colValues.Add(pageColumn, decimal.Parse(htCurrValue[i].ToString()));
        else
            colValues[pageColumn] += decimal.Parse(htCurrValue[i].ToString());
    }
}
</AfterPrintEvent>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid>1ddc239c4abe43be99c7947678000d9d</BusinessObjectGuid>
          <CanShrink>True</CanShrink>
          <ClientRectangle>0,2,19,2.8</ClientRectangle>
          <Components isList="true" count="4">
            <Panel1 Ref="11" type="Stimulsoft.Report.Components.StiPanel" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>2.6,0,9.6,1.8</ClientRectangle>
              <Components isList="true" count="1">
                <DataBand2 Ref="12" type="DataBand" isKey="true">
                  <Brush>Transparent</Brush>
                  <BusinessObjectGuid>a1a591317a774ad298bfbe50e52a0972</BusinessObjectGuid>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>0,0.4,9.6,0.6</ClientRectangle>
                  <Columns>4</Columns>
                  <Components isList="true" count="1">
                    <Text3 Ref="13" type="Text" isKey="true">
                      <AfterPrintEvent>if (IsFirstPass)
{
	htCurrValue[Column] = Clients.Qualities.Value;
}</AfterPrintEvent>
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>[0:255:255:255]</Brush>
                      <ClientRectangle>0,0,1.6,0.6</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8</Font>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,3,0,0</Margins>
                      <Name>Text3</Name>
                      <Page isRef="5" />
                      <Parent isRef="12" />
                      <Text>{Clients.Qualities.Value}</Text>
                      <TextBrush>[0:0:0]</TextBrush>
                      <Type>Expression</Type>
                      <VertAlignment>Center</VertAlignment>
                    </Text3>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <DataRelationName isNull="true" />
                  <DataSourceName isNull="true" />
                  <FilterOn>False</FilterOn>
                  <Filters isList="true" count="0" />
                  <Guid>4f648d48d344439792161352e2dd7135</Guid>
                  <MasterComponent isRef="10" />
                  <Name>DataBand2</Name>
                  <Page isRef="5" />
                  <Parent isRef="11" />
                  <Sort isList="true" count="0" />
                </DataBand2>
              </Components>
              <Conditions isList="true" count="0" />
              <Guid>1c60ec241a014cab8fef801eece27c82</Guid>
              <Name>Panel1</Name>
              <Page isRef="5" />
              <Parent isRef="10" />
              <ShiftMode>IncreasingSize, DecreasingSize</ShiftMode>
            </Panel1>
            <Text1 Ref="14" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[0:255:255:255]</Brush>
              <ClientRectangle>0.8,0,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>3,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="5" />
              <Parent isRef="10" />
              <Text>{Clients.Name}</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <VertAlignment>Center</VertAlignment>
            </Text1>
            <Text2 Ref="15" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[0:255:255:255]</Brush>
              <ClientRectangle>0,0,0.8,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="5" />
              <Parent isRef="10" />
              <Text>{GetId()}</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text2>
            <Text11 Ref="16" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[0:255:255:255]</Brush>
              <ClientRectangle>17.4,0,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>6cc62b82a85b4b32994df61d8f9539dd</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,3,0,0</Margins>
              <Name>Text11</Name>
              <Page isRef="5" />
              <Parent isRef="10" />
              <Text>{Totals.Sum(DataBand2,Clients.Qualities.Value)}</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text11>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName isNull="true" />
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <PrintIfDetailEmpty>True</PrintIfDetailEmpty>
          <Sort isList="true" count="0" />
        </DataBand1>
        <FooterBand1 Ref="17" type="FooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <CanShrink>True</CanShrink>
          <ClientRectangle>0,5.6,19,1.4</ClientRectangle>
          <Components isList="true" count="3">
            <Text18 Ref="18" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[0:255:255:255]</Brush>
              <ClientRectangle>17.4,0.2,1.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>82037a077fb94e7dbad048790af4d29a</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,3,0,0</Margins>
              <Name>Text18</Name>
              <Page isRef="5" />
              <Parent isRef="17" />
              <Text>{cSum(Clients.Qualities.Value)}</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <Type>Totals</Type>
              <VertAlignment>Center</VertAlignment>
            </Text18>
            <Text12 Ref="19" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>[216:216:216]</Brush>
              <ClientRectangle>0,0.2,2.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>6780ce4bc20b4370957e562b5f9a6d36</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text12</Name>
              <Page isRef="5" />
              <Parent isRef="17" />
              <Text>Total on this page:</Text>
              <TextBrush>[0:0:0]</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text12>
            <Panel2 Ref="20" type="Stimulsoft.Report.Components.StiPanel" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <CanShrink>True</CanShrink>
              <ClientRectangle>2.6,0.2,9.6,1.2</ClientRectangle>
              <Components isList="true" count="1">
                <DataBand3 Ref="21" type="DataBand" isKey="true">
                  <Brush>Transparent</Brush>
                  <BusinessObjectGuid>a1a591317a774ad298bfbe50e52a0972</BusinessObjectGuid>
                  <CanShrink>True</CanShrink>
                  <ClientRectangle>0,0.4,9.6,0.6</ClientRectangle>
                  <Columns>4</Columns>
                  <Components isList="true" count="1">
                    <Text14 Ref="22" type="Text" isKey="true">
                      <Border>All;Black;1;Solid;False;4;Black</Border>
                      <Brush>[0:255:255:255]</Brush>
                      <ClientRectangle>0,0,1.6,0.6</ClientRectangle>
                      <Conditions isList="true" count="0" />
                      <Font>Arial,8</Font>
                      <Guid>7a77e310a6eb4e5da324a669a60a299a</Guid>
                      <HorAlignment>Right</HorAlignment>
                      <Margins>0,3,0,0</Margins>
                      <Name>Text14</Name>
                      <Page isRef="5" />
                      <Parent isRef="21" />
                      <Text>{GetSum(PageNumber, Column)}</Text>
                      <TextBrush>[0:0:0]</TextBrush>
                      <Type>Expression</Type>
                      <VertAlignment>Center</VertAlignment>
                    </Text14>
                  </Components>
                  <Conditions isList="true" count="0" />
                  <DataRelationName isNull="true" />
                  <DataSourceName isNull="true" />
                  <FilterOn>False</FilterOn>
                  <Filters isList="true" count="0" />
                  <Guid>3659be5bdad04835aa215bcac50ed689</Guid>
                  <Name>DataBand3</Name>
                  <Page isRef="5" />
                  <Parent isRef="20" />
                  <Sort isList="true" count="0" />
                </DataBand3>
              </Components>
              <Conditions isList="true" count="0" />
              <Name>Panel2</Name>
              <Page isRef="5" />
              <Parent isRef="17" />
            </Panel2>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>FooterBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <PrintOnAllPages>True</PrintOnAllPages>
        </FooterBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>ae1196201992469391b85029b4d7715a</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page3</Name>
      <PageHeight>28</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="23" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <Text>adsasdasd</Text>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page3>
  </Pages>
  <PrinterSettings Ref="24" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
  <ReferencedAssemblies isList="true" count="9">
    <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>
    <value>System.Core</value>
  </ReferencedAssemblies>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>6/28/2013 4:02:20 PM</ReportChanged>
  <ReportCreated>8/28/2012 9:20:13 AM</ReportCreated>
  <ReportFile>E:\Report_modified3.mrt</ReportFile>
  <ReportGuid>6895f154401b4dd4b11a95cfe0ef513b</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</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;
using System.Linq;
using System.Collections.Generic;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
	private int id;

	public System.Collections.Hashtable htCurrValue= new System.Collections.Hashtable();
	
	public Dictionary&lt;string, decimal&gt; colValues = new Dictionary&lt;string, decimal&gt;();

	public Report()        
	{
		this.InitializeComponent();
		id = 1;
	}

	private int GetId()
	{
		if (IsFirstPass)
			return 0;
		return id++;
	}

	private decimal GetSum(int pageNumber, int column)
	{
		if (!IsFirstPass)
		{
			return colValues["p" + pageNumber.ToString() + "c" + column.ToString()];
		}

		return 0m;
	}

        #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>