﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <Culture>en-US</Culture>
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <System1 Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>System1</Alias>
        <ConnectionStringEncrypted>+XTRCU97+vnhWu3semh3Y55g+YhhWXuBRU/RyWlcYEbEePvrzRh79WlGoazlhOB75HDPoURxe/X8S5z0aVjhDw==</ConnectionStringEncrypted>
        <Name>System1</Name>
      </System1>
    </Databases>
    <DataSources isList="true" count="1">
      <OrderData Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>OrderData</Alias>
        <Columns isList="true" count="2">
          <value>OrderDate,System.DateTime</value>
          <value>OrderName,System.String</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <IsCloud>False</IsCloud>
        <Name>OrderData</Name>
        <NameInSource>System1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT		YEAR(CONVERT(date,'01/11/2014',103)) 'OrderYear',
			MONTH(CONVERT(date,'01/11/2014',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'01/11/2014',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'01/11/2014',103) 'OrderDate',
			'Rodgers' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'02/11/2014',103)) 'OrderYear',
			MONTH(CONVERT(date,'02/11/2014',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'02/11/2014',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'02/11/2014',103) 'OrderDate',
			'Wiseman' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'03/12/2014',103)) 'OrderYear',
			MONTH(CONVERT(date,'03/12/2014',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'03/12/2014',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'03/12/2014',103) 'OrderDate',
			'Greene' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'30/12/2014',103)) 'OrderYear',
			MONTH(CONVERT(date,'30/12/2014',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'30/12/2014',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'30/12/2014',103) 'OrderDate',
			'Clark' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'04/01/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'04/01/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'04/01/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'04/01/2015',103) 'OrderDate',
			'Aspen' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'01/02/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'01/02/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'01/02/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'01/02/2015',103) 'OrderDate',
			'Smith' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'06/02/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'06/02/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'06/02/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'06/02/2015',103) 'OrderDate',
			'Bloggs' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'10/02/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'10/02/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'10/02/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'10/02/2015',103) 'OrderDate',
			'Zed' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'26/02/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'26/02/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'26/02/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'26/02/2015',103) 'OrderDate',
			'Maker' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'03/03/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'03/03/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'03/03/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'03/03/2015',103) 'OrderDate',
			'Jordan' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'24/02/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'24/02/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'24/02/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'24/02/2015',103) 'OrderDate',
			'Barry' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'25/02/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'25/02/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'25/02/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'25/02/2015',103) 'OrderDate',
			'McDonald' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'11/04/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'11/04/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'11/04/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'11/04/2015',103) 'OrderDate',
			'Roberts' 'OrderName'
UNION
SELECT		YEAR(CONVERT(date,'12/04/2015',103)) 'OrderYear',
			MONTH(CONVERT(date,'12/04/2015',103)) 'OrderMonth',
			DATENAME(m,DATEADD(m ,MONTH(CONVERT(date,'12/04/2015',103)) , 0 ) - 1 ) 'OrderMonthName',
			CONVERT(date,'12/02/2015',103) 'OrderDate',
			'Andrew' 'OrderName'
ORDER BY	'OrderYear' DESC, 
			'OrderMonth' DESC, 
			'OrderName'</SqlCommand>
      </OrderData>
    </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="2">
        <GroupHeaderBand1 Ref="5" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,1.4</ClientRectangle>
          <Components isList="true" count="3">
            <Text1 Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,7,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>{OrderData.OrderDate.ToString("MMMM yyyy")}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text1>
            <HeaderOrderData_OrderName Ref="7" type="Text" isKey="true">
              <Brush>[198:217:240]</Brush>
              <ClientRectangle>0,0.6,9.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderOrderData_OrderName</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>OrderName</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderOrderData_OrderName>
            <HeaderOrderData_OrderDate Ref="8" type="Text" isKey="true">
              <Brush>[198:217:240]</Brush>
              <ClientRectangle>9.6,0.6,9.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderOrderData_OrderDate</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>OrderDate</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </HeaderOrderData_OrderDate>
          </Components>
          <Condition>{OrderData.OrderDate.ToString("yyyyMM")}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <SortDirection>Descending</SortDirection>
        </GroupHeaderBand1>
        <DataOrderData Ref="9" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2.6,19,0.8</ClientRectangle>
          <Components isList="true" count="2">
            <DataOrderData_OrderName Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,9.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataOrderData_OrderName</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{OrderData.OrderName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataOrderData_OrderName>
            <DataOrderData_OrderDate Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9.6,0,9.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataOrderData_OrderDate</Name>
              <Page isRef="4" />
              <Parent isRef="9" />
              <Text>{OrderData.OrderDate}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataOrderData_OrderDate>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>OrderData</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataOrderData</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataOrderData>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>0e582438762b4453b1164798da40ee0c</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="12" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="13" 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/15/2015 1:34:25 PM</ReportChanged>
  <ReportCreated>4/15/2015 1:20:05 PM</ReportCreated>
  <ReportFile />
  <ReportGuid>b1d7255c2a314aeca5f795ab927674f9</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2015.1.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;

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>