﻿<?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="2">
      <TestData Ref="2" type="Stimulsoft.Report.Dictionary.StiCsvSource" isKey="true">
        <Alias>TestData</Alias>
        <CodePage>65001</CodePage>
        <Columns isList="true" count="10">
          <value>ID,System.String</value>
          <value>UserID,System.String</value>
          <value>PreferredName,System.String</value>
          <value>OperatorID,System.String</value>
          <value>SubscriptionID,System.String</value>
          <value>UserTokenID,System.String</value>
          <value>DeviceID,System.String</value>
          <value>WasAuthorised,System.String</value>
          <value>AuthorisedAt,System.String</value>
          <value>Inserted,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>TestData</Name>
        <NameInSource>D:\Support\post-6101\report-data.csv</NameInSource>
        <Path>D:\Support\post-6101\report-data.csv</Path>
      </TestData>
      <DataSource1 Ref="3" type="Stimulsoft.Report.Dictionary.StiVirtualSource" isKey="true">
        <Alias>DataSource1</Alias>
        <Columns isList="true" count="2">
          <value>Inserted,System.String</value>
          <value>Count1,System.Int64</value>
        </Columns>
        <Dictionary isRef="1" />
        <Filters isList="true" count="0" />
        <GroupColumns isList="true" count="1">
          <value>Inserted</value>
        </GroupColumns>
        <Name>DataSource1</Name>
        <NameInSource>TestData</NameInSource>
        <Results isList="true" count="3">
          <value>ID</value>
          <value>Count</value>
          <value>Count1</value>
        </Results>
        <Sort isList="true" count="0" />
      </DataSource1>
    </DataSources>
    <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="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="6">
        <ReportTitleBand1 Ref="5" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,2.4</ClientRectangle>
          <Components isList="true" count="1">
            <Text1 Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.2,0.6,13,1.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,20</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>Venue Report</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text1>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ReportTitleBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </ReportTitleBand1>
        <ColumnHeaderBand1 Ref="7" type="Stimulsoft.Report.Components.StiColumnHeaderBand" isKey="true">
          <Brush>[191:191:191]</Brush>
          <ClientRectangle>0,3.6,19,0.6</ClientRectangle>
          <Components isList="true" count="3">
            <Text3 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,4.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>PreferredName</Text>
              <TextBrush>Black</TextBrush>
            </Text3>
            <Text6 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>4.8,0,3.6,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>Time</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text6>
            <Text8 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>13.8,0,3.8,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>Result</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text8>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ColumnHeaderBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </ColumnHeaderBand1>
        <GroupHeaderBand1 Ref="11" type="GroupHeaderBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>[34:177:76]</Brush>
          <ClientRectangle>0,5,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text9 Ref="12" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>4.4,0,9,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text9</Name>
              <Page isRef="4" />
              <Parent isRef="11" />
              <Text>{Format("{0:dd MMM yyyy}", this.ParseDateTime(TestData.Inserted))}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text9>
          </Components>
          <Condition>{Format("{0:dd MMM yyyy}", this.ParseDateTime(TestData.Inserted))}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupHeaderBand1>
        <DataBand1 Ref="13" type="DataBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,6.4,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text2 Ref="14" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,5.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="4" />
              <Parent isRef="13" />
              <Text>{TestData.PreferredName}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text2>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>TestData</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataBand1>
        <GroupFooterBand1 Ref="15" type="GroupFooterBand" isKey="true">
          <Brush>[34:177:76]</Brush>
          <ClientRectangle>0,7.8,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text5 Ref="16" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>15.2,0,3.8,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="4" />
              <Parent isRef="15" />
              <Text>TOTAL: {Count()}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text5>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>GroupFooterBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupFooterBand1>
        <FooterBand1 Ref="17" type="FooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,9.2,19,8</ClientRectangle>
          <Components isList="true" count="1">
            <Chart1 Ref="18" type="Stimulsoft.Report.Chart.StiChart" isKey="true">
              <Area Ref="19" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" isKey="true">
                <BorderColor>95, 95, 95</BorderColor>
                <Brush>GradientBrush,[255:255:255],[255:255:255],90</Brush>
                <Chart isRef="18" />
                <GridLinesHor Ref="20" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
                  <Area isRef="19" />
                  <Color>100, 95, 95, 95</Color>
                  <MinorColor>100, 95, 95, 95</MinorColor>
                </GridLinesHor>
                <GridLinesHorRight Ref="21" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
                  <Area isRef="19" />
                  <Color>Silver</Color>
                  <MinorColor>Gainsboro</MinorColor>
                  <Visible>False</Visible>
                </GridLinesHorRight>
                <GridLinesVert Ref="22" type="Stimulsoft.Report.Chart.StiGridLinesVert" isKey="true">
                  <Area isRef="19" />
                  <Color>100, 95, 95, 95</Color>
                  <MinorColor>100, 95, 95, 95</MinorColor>
                </GridLinesVert>
                <InterlacingHor Ref="23" type="Stimulsoft.Report.Chart.StiInterlacingHor" isKey="true">
                  <Area isRef="19" />
                  <InterlacedBrush>[10:145:145:145]</InterlacedBrush>
                </InterlacingHor>
                <InterlacingVert Ref="24" type="Stimulsoft.Report.Chart.StiInterlacingVert" isKey="true">
                  <Area isRef="19" />
                  <InterlacedBrush>[10:145:145:145]</InterlacedBrush>
                </InterlacingVert>
                <XAxis Ref="25" type="Stimulsoft.Report.Chart.StiXBottomAxis" isKey="true">
                  <Area isRef="19" />
                  <Interaction Ref="26" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="27" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>95, 95, 95</LineColor>
                  <Range Ref="28" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
                  <Ticks Ref="29" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="30" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Direction>LeftToRight</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </XAxis>
                <XTopAxis Ref="31" type="Stimulsoft.Report.Chart.StiXTopAxis" isKey="true">
                  <Area isRef="19" />
                  <Interaction Ref="32" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="33" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>95, 95, 95</LineColor>
                  <Ticks Ref="34" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="35" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Direction>LeftToRight</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </XTopAxis>
                <YAxis Ref="36" type="Stimulsoft.Report.Chart.StiYLeftAxis" isKey="true">
                  <Area isRef="19" />
                  <Interaction Ref="37" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="38" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>95, 95, 95</LineColor>
                  <Range Ref="39" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
                  <Ticks Ref="40" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="41" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Direction>BottomToTop</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YAxis>
                <YRightAxis Ref="42" type="Stimulsoft.Report.Chart.StiYRightAxis" isKey="true">
                  <Area isRef="19" />
                  <Interaction Ref="43" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="44" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Font>Tahoma,8</Font>
                    <TextAlignment>Left</TextAlignment>
                  </Labels>
                  <LineColor>95, 95, 95</LineColor>
                  <Range Ref="45" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
                  <Ticks Ref="46" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="47" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>95, 95, 95</Color>
                    <Direction>TopToBottom</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YRightAxis>
              </Area>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0.6,0.4,18,7.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <ConstantLines isList="true" count="0" />
              <CustomStyleName />
              <Filters isList="true" count="0" />
              <Legend Ref="48" type="Stimulsoft.Report.Chart.StiLegend" isKey="true">
                <BorderColor>95, 95, 95</BorderColor>
                <Brush>GradientBrush,[255:255:255],[255:255:255],90</Brush>
                <Chart isRef="18" />
                <Font>Arial,8</Font>
                <LabelsColor>95, 95, 95</LabelsColor>
                <MarkerSize>10, 10</MarkerSize>
                <TitleColor>95, 95, 95</TitleColor>
                <TitleFont>Arial,14,Bold</TitleFont>
              </Legend>
              <Name>Chart1</Name>
              <Page isRef="4" />
              <Parent isRef="17" />
              <Series isList="true" count="1">
                <Item18 Ref="49" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" isKey="true">
                  <ArgumentDataColumn>DataSource1.Inserted</ArgumentDataColumn>
                  <BorderColor>28, 45, 65</BorderColor>
                  <Brush>GlareBrush,[128:145:165],[178:195:215],0,0.5,1</Brush>
                  <BrushNegative>Firebrick</BrushNegative>
                  <Chart isRef="18" />
                  <Conditions isList="true" count="0" />
                  <Filters isList="true" count="0" />
                  <Format isNull="true" />
                  <SeriesLabels Ref="50" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
                    <BorderColor>95, 95, 95</BorderColor>
                    <Brush>WhiteSmoke</Brush>
                    <Chart isRef="18" />
                    <Font>Arial,7</Font>
                    <LabelColor>95, 95, 95</LabelColor>
                    <MarkerSize>8, 6</MarkerSize>
                    <ValueTypeSeparator>-</ValueTypeSeparator>
                  </SeriesLabels>
                  <Title>Series 1</Title>
                  <ValueDataColumn>DataSource1.Count1</ValueDataColumn>
                </Item18>
              </Series>
              <SeriesLabels Ref="51" type="Stimulsoft.Report.Chart.StiNoneLabels" isKey="true">
                <Chart isRef="18" />
                <MarkerSize>8, 6</MarkerSize>
                <ValueTypeSeparator>-</ValueTypeSeparator>
              </SeriesLabels>
              <SeriesLabelsConditions isList="true" count="0" />
              <Sort isList="true" count="0" />
              <Strips isList="true" count="0" />
              <Style Ref="52" type="Stimulsoft.Report.Chart.StiStyle02" isKey="true" />
              <Title Ref="53" type="Stimulsoft.Report.Chart.StiChartTitle" isKey="true">
                <Brush>[95:95:95]</Brush>
                <Font>Tahoma,12,Bold</Font>
              </Title>
            </Chart1>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>FooterBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </FooterBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>71fcca86b77a4bd0a7d0d5f4fb0ac0d3</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <PaperSize>A4</PaperSize>
      <Report isRef="0" />
      <Watermark Ref="54" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="55" 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>4/6/2012 2:28:38 PM</ReportChanged>
  <ReportCreated>4/4/2012 4:25:14 PM</ReportCreated>
  <ReportFile>D:\Support\post-6101\TestReport.mrt</ReportFile>
  <ReportGuid>d4da6c81205448328175daa796dcaf3d</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2012.1.1300</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
		
		public DateTime MyParseDateTime(string dateTimeStr)
		{
			return DateTime.Parse(dateTimeStr.Trim('"'));	
		}
    }
}
</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>