﻿<?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">
      <DataSource1 Ref="2" type="Stimulsoft.Report.Dictionary.StiCsvSource" isKey="true">
        <Alias>DataSource1</Alias>
        <CodePage>0</CodePage>
        <Columns isList="true" count="4">
          <value>Pupil_Name,System.String</value>
          <value>Average,System.Int32</value>
          <value>Coloumn,System.Int32</value>
          <value>Score,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>ea7e42edabb74a309855eed7b1a4299a</Key>
        <Name>DataSource1</Name>
        <NameInSource>D:\temp\2\ExampleReport\example1.csv</NameInSource>
        <Path>D:\temp\2\ExampleReport\example1.csv</Path>
        <Separator />
      </DataSource1>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>989e0bd6c70b46ea87e2af5287c5e7cf</Key>
  <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">
        <CrossTab1 Ref="4" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0.4,0.2,8.4,4.6</ClientRectangle>
          <Components isList="true" count="11">
            <CrossTab1_RowTotal1 Ref="5" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0,1.7,3,0</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Enabled>False</Enabled>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>ce7af133101b46a1b4ef54fb1c6f0cfe</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal1>
            <CrossTab1_Row1_Title Ref="6" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.45,1.8,0.4</ClientRectangle>
              <Enabled>False</Enabled>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>5a8230265a1e4334a469656032bf9e9c</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1_Title</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Pupil_Name</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row1</TypeOfComponent>
            </CrossTab1_Row1_Title>
            <CrossTab1_RowTotal2 Ref="7" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>1.8,1.3,1.2,0</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Enabled>False</Enabled>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>49da90f9f324447da1b75d8a482a78fe</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal2</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal2>
            <CrossTab1_Row2_Title Ref="8" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>1.8,0.45,1.2,0.4</ClientRectangle>
              <Enabled>False</Enabled>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>6cd3dbf49bdb4a04b2e18b481aa8b046</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row2_Title</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Average</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row2</TypeOfComponent>
            </CrossTab1_Row2_Title>
            <CrossTab1_ColTotal1 Ref="9" type="CrossColumnTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>4.45,0.45,0,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>1412fdb2aa404036901292f0ab7ecbca</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_ColTotal1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_ColTotal1>
            <CrossTab1_LeftTitle Ref="10" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0,3,0.4</ClientRectangle>
              <Enabled>False</Enabled>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>d9714b47994c44d2a3f6ed18b733b6c6</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_LeftTitle</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>DataSource1</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>LeftTitle</TypeOfComponent>
            </CrossTab1_LeftTitle>
            <CrossTab1_RightTitle Ref="11" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>3.05,0,1.4,1E-13</ClientRectangle>
              <Enabled>False</Enabled>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>5416c80981f349b093d300bc3ff79644</Guid>
              <Margins>0,0,0,0</Margins>
              <MaxSize>0,1E-13</MaxSize>
              <Name>CrossTab1_RightTitle</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Coloumn</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>RightTitle</TypeOfComponent>
            </CrossTab1_RightTitle>
            <CrossTab1_Row1 Ref="12" type="CrossRow" isKey="true">
              <Alias>Pupil_Name</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.9,1.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{DataSource1.Pupil_Name}</DisplayValue>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>393ab394b482424ca43825d73fd1ce38</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>Pupil_Name</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>ce7af133101b46a1b4ef54fb1c6f0cfe</TotalGuid>
              <Value>{DataSource1.Pupil_Name}</Value>
            </CrossTab1_Row1>
            <CrossTab1_Row2 Ref="13" type="CrossRow" isKey="true">
              <Alias>Average</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>1.8,0.9,1.2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{DataSource1.Average}</DisplayValue>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>6be1bceacb944db8aa7892594c885a78</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row2</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>Average</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>49da90f9f324447da1b75d8a482a78fe</TotalGuid>
              <Value>{DataSource1.Average}</Value>
            </CrossTab1_Row2>
            <CrossTab1_Column1 Ref="14" type="CrossColumn" isKey="true">
              <Alias>Coloumn</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>3.05,0.45,1.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>5c8c8237511543d6910872e7d38727e6</Guid>
              <Margins>0,0,0,0</Margins>
              <MaxSize>0,0.4</MaxSize>
              <MinSize>0,0.4</MinSize>
              <Name>CrossTab1_Column1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>Coloumn</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>1412fdb2aa404036901292f0ab7ecbca</TotalGuid>
              <Value>{DataSource1.Coloumn}</Value>
            </CrossTab1_Column1>
            <CrossTab1_Sum1 Ref="15" type="CrossSummary" isKey="true">
              <Alias>Score</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>3.05,0.9,1.4,0.4</ClientRectangle>
              <Conditions isList="true" count="3">
                <value>_x007B_tag_x003D__x003D__x0022_8_x0022__x007D_,Red,Red,Arial_x002C_8,True,False,,,None,BackColor</value>
                <value>_x007B_tag_x003D__x003D__x0022_6_x0022__x007D_,Red,Yellow,Arial_x002C_8,True,False,,,None,BackColor</value>
                <value>_x007B_tag_x003D__x003D__x0022_4_x0022__x007D_,Red,Green,Arial_x002C_8,True,False,,,None,BackColor</value>
              </Conditions>
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>b06854eee53b4571819295609bd4f527</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum1</Name>
              <Page isRef="3" />
              <Parent isRef="4" />
              <ProcessCellEvent>/*StiSolidBrush b = new StiSolidBrush();

// Insert Calculated Colour if Statement Here
if (Average[DataSource1.Pupil_Name] == 8)
    b.Color = Color.Red;
if (Average[DataSource1.Pupil_Name] == 4)
    b.Color = Color.Green;
if (Average[DataSource1.Pupil_Name] == 6)
    b.Color = Color.Yellow;
else
    b.Color = Color.Transparent;

((StiSolidBrush)((StiCrossField)sender).Brush).Color = b.Color;*/</ProcessCellEvent>
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Tag>{DataSource1.Average}</Tag>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <Value>{DataSource1.Score}</Value>
            </CrossTab1_Sum1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName />
          <DataSourceName>DataSource1</DataSourceName>
          <EmptyValue />
          <Expressions isList="true" count="0" />
          <Filters isList="true" count="0" />
          <Name>CrossTab1</Name>
          <Page isRef="3" />
          <Parent isRef="3" />
          <Sort isList="true" count="0" />
        </CrossTab1>
      </Components>
      <Conditions isList="true" count="0" />
      <Expressions isList="true" count="0" />
      <Guid>a46e6c02de214fe996f60c3ffa0786cf</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
    </Page1>
  </Pages>
  <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>6/14/2021 3:09:15 PM</ReportChanged>
  <ReportCreated>5/23/2013 6:27:06 PM</ReportCreated>
  <ReportFile>D:\temp\2\ExampleReport\ExampleReport_modified.mrt</ReportFile>
  <ReportGuid>6e079157fdf04e9fa734adaddc792162</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2021.2.4.0</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.Collections.Generic;
using Stimulsoft.Report.CrossTab;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
		Dictionary&lt;string, int&gt; Average = new Dictionary&lt;string, int&gt;();
		
		public void populateDic()
		{
			Average.Add("Ben", 8);
			Average.Add("Lisa", 4);
			Average.Add("Josh", 6);			
		}
		
        public Report()        {
            this.InitializeComponent();
			populateDic();
        }

        #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>