﻿<?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="1">
      <VUEWorksDB Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>VUEWorksDB</Alias>
        <ConnectionStringEncrypted>9FafC+8J84VGW+3YZ1zhm9FA3ajGXeKBYhUlyelwsX/fcMECxQPTgXp78YRiPaQ/+XDBKU1Lk4FpSbkEZEl3h8NW+StFBUv5RnTVZOn4bXvX0IGDyRhbmeJr/azDmOM/wlb5z04FWpliS9VsaEz2L9VU0S1IbQEJ7UZN8A==</ConnectionStringEncrypted>
        <Name>VUEWorksDB</Name>
      </VUEWorksDB>
    </Databases>
    <DataSources isList="true" count="2">
      <DataSource1 Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>DataSource1</Alias>
        <Columns isList="true" count="5">
          <value>OpenedYMD,System.DateTime</value>
          <value>OpenedMonth,System.Int32</value>
          <value>OpenedYear,System.Int32</value>
          <value>Complaint,System.String</value>
          <value>ComplaintCount,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>DataSource1</Name>
        <NameInSource>VUEWorksDB</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT    Convert(Date, OpenedDate,120) as OpenedYMD, MONTH(OpenedDate) AS OpenedMonth, YEAR(OpenedDate) AS OpenedYear,
	 Complaint, COUNT(CASE WHEN Month(OpenedDate) &gt; 0 THEN 1 END) AS ComplaintCount
FROM         reports.ServiceRequests
WHERE     (Complaint NOT LIKE '')
GROUP BY Complaint, Convert(Date, OpenedDate,120), MONTH(OpenedDate), YEAR(OpenedDate)</SqlCommand>
      </DataSource1>
      <GroupYear Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>GroupYear</Alias>
        <Columns isList="true" count="1">
          <value>OpenedYEAR,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>GroupYear</Name>
        <NameInSource>VUEWorksDB</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT    YEAR(OpenedDate) AS OpenedYEAR
FROM         reports.ServiceRequests
WHERE     (Complaint NOT LIKE '')
GROUP BY YEAR(OpenedDate)</SqlCommand>
      </GroupYear>
    </DataSources>
    <Relations isList="true" count="1">
      <Name Ref="5" type="DataRelation" isKey="true">
        <Alias>Name</Alias>
        <ChildColumns isList="true" count="1">
          <value>OpenedYear</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>Name</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>OpenedYEAR</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Name>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="8">
      <value>,UserID,UserID,,System.Int32,_x0032_03,False,False,False,True</value>
      <value>,UserName,UserName,,System.String,_x0020_,False,False,False,True</value>
      <value>,ReportID,ReportID,,System.Int32,_x0033_90,False,False,False,True</value>
      <value>,ProviderType,ProviderType,,System.Int32,_x0034_,False,False,False,True</value>
      <value>,ReportName,ReportName,,System.String,BarGraphTest,False,False,False,True</value>
      <value>,CategoryName,CategoryName,,System.String,,False,False,False,True</value>
      <value>,LayerID,LayerID,,System.Int32,_x002D_1,False,False,False,True</value>
      <value>,UseSelection,UseSelection,,System.String,False,False,False,False,True</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="6" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataGroupYear Ref="7" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.2,7.72,2.5</ClientRectangle>
          <Components isList="true" count="2">
            <Text1 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.6,0,2.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>Graph for : {GroupYear.OpenedYEAR}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text1>
            <Chart1 Ref="9" type="Stimulsoft.Report.Chart.StiChart" isKey="true">
              <Area Ref="10" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" isKey="true">
                <BorderColor>171, 172, 173</BorderColor>
                <Brush>White</Brush>
                <Chart isRef="9" />
                <GridLinesHor Ref="11" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
                  <Area isRef="10" />
                  <Color>100, 105, 105, 105</Color>
                  <MinorColor>100, 105, 105, 105</MinorColor>
                </GridLinesHor>
                <GridLinesHorRight Ref="12" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
                  <Area isRef="10" />
                  <Color>Silver</Color>
                  <MinorColor>Gainsboro</MinorColor>
                  <Visible>False</Visible>
                </GridLinesHorRight>
                <GridLinesVert Ref="13" type="Stimulsoft.Report.Chart.StiGridLinesVert" isKey="true">
                  <Area isRef="10" />
                  <Color>100, 105, 105, 105</Color>
                  <MinorColor>100, 105, 105, 105</MinorColor>
                </GridLinesVert>
                <InterlacingHor Ref="14" type="Stimulsoft.Report.Chart.StiInterlacingHor" isKey="true">
                  <Area isRef="10" />
                  <InterlacedBrush>[10:155:155:155]</InterlacedBrush>
                </InterlacingHor>
                <InterlacingVert Ref="15" type="Stimulsoft.Report.Chart.StiInterlacingVert" isKey="true">
                  <Area isRef="10" />
                  <InterlacedBrush>[10:155:155:155]</InterlacedBrush>
                </InterlacingVert>
                <XAxis Ref="16" type="Stimulsoft.Report.Chart.StiXBottomAxis" isKey="true">
                  <Area isRef="10" />
                  <DateTimeStep Ref="17" type="Stimulsoft.Report.Chart.StiAxisDateTimeStep" isKey="true">
                    <Interpolation>True</Interpolation>
                  </DateTimeStep>
                  <Interaction Ref="18" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="19" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Angle>45</Angle>
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,8</Font>
                    <Format>MMM yyyy</Format>
                  </Labels>
                  <LineColor>140, 140, 140</LineColor>
                  <Range Ref="20" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
                  <Ticks Ref="21" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="22" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </XAxis>
                <XTopAxis Ref="23" type="Stimulsoft.Report.Chart.StiXTopAxis" isKey="true">
                  <Area isRef="10" />
                  <Interaction Ref="24" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="25" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>140, 140, 140</LineColor>
                  <Ticks Ref="26" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="27" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </XTopAxis>
                <YAxis Ref="28" type="Stimulsoft.Report.Chart.StiYLeftAxis" isKey="true">
                  <Area isRef="10" />
                  <Interaction Ref="29" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="30" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,8</Font>
                  </Labels>
                  <LineColor>140, 140, 140</LineColor>
                  <Range Ref="31" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
                  <Ticks Ref="32" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="33" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Direction>BottomToTop</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YAxis>
                <YRightAxis Ref="34" type="Stimulsoft.Report.Chart.StiYRightAxis" isKey="true">
                  <Area isRef="10" />
                  <Interaction Ref="35" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
                  <Labels Ref="36" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Font>Tahoma,8</Font>
                    <TextAlignment>Left</TextAlignment>
                  </Labels>
                  <LineColor>140, 140, 140</LineColor>
                  <Range Ref="37" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
                  <Ticks Ref="38" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
                  <Title Ref="39" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                    <Color>140, 140, 140</Color>
                    <Direction>TopToBottom</Direction>
                    <Font>Tahoma,12,Bold</Font>
                  </Title>
                </YRightAxis>
              </Area>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0.7,0.3,6.2,2.1</ClientRectangle>
              <Conditions isList="true" count="0" />
              <ConstantLines isList="true" count="0" />
              <CustomStyleName />
              <DataRelationName>Relation</DataRelationName>
              <DataSourceName>DataSource1</DataSourceName>
              <Filters isList="true" count="0" />
              <Legend Ref="40" type="Stimulsoft.Report.Chart.StiLegend" isKey="true">
                <BorderColor>225, 225, 225</BorderColor>
                <Brush>[255:255:255]</Brush>
                <Chart isRef="9" />
                <Font>Arial,8</Font>
                <LabelsColor>140, 140, 140</LabelsColor>
                <MarkerSize>10, 10</MarkerSize>
                <ShowShadow>False</ShowShadow>
                <TitleColor>105, 105, 105</TitleColor>
                <TitleFont>Arial,14,Bold</TitleFont>
              </Legend>
              <MasterComponent isRef="7" />
              <Name>Chart1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Series isList="true" count="1">
                <Item9 Ref="41" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" isKey="true">
                  <Argument>{DataSource1.OpenedYMD}</Argument>
                  <ArgumentDataColumn>DataSource1.OpenedYMD</ArgumentDataColumn>
                  <BorderColor>255, 255, 255</BorderColor>
                  <Brush>[112:173:71]</Brush>
                  <BrushNegative>Firebrick</BrushNegative>
                  <Chart isRef="9" />
                  <Conditions isList="true" count="0" />
                  <Filters isList="true" count="0" />
                  <SeriesLabels Ref="42" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
                    <BorderColor>Transparent</BorderColor>
                    <Brush>Transparent</Brush>
                    <Chart isRef="9" />
                    <Font>Arial,10</Font>
                    <LabelColor>51, 71, 91</LabelColor>
                    <MarkerSize>8, 6</MarkerSize>
                    <MarkerVisible>True</MarkerVisible>
                    <ValueTypeSeparator>-</ValueTypeSeparator>
                    <Width>0</Width>
                  </SeriesLabels>
                  <ShowShadow>False</ShowShadow>
                  <Title>Series 1</Title>
                  <TopN Ref="43" type="Stimulsoft.Report.Chart.StiSeriesTopN" isKey="true" />
                  <TrendLine Ref="44" type="Stimulsoft.Report.Chart.StiTrendLineNone" isKey="true">
                    <LineColor>105, 105, 105</LineColor>
                    <ShowShadow>False</ShowShadow>
                  </TrendLine>
                  <ValueDataColumn>DataSource1.ComplaintCount</ValueDataColumn>
                </Item9>
              </Series>
              <SeriesLabels Ref="45" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
                <BorderColor>Transparent</BorderColor>
                <Brush>Transparent</Brush>
                <Chart isRef="9" />
                <Font>Arial,10</Font>
                <LabelColor>51, 71, 91</LabelColor>
                <MarkerSize>8, 6</MarkerSize>
                <ValueTypeSeparator>-</ValueTypeSeparator>
                <Width>0</Width>
              </SeriesLabels>
              <SeriesLabelsConditions isList="true" count="0" />
              <Sort isList="true" count="0" />
              <Strips isList="true" count="0" />
              <Style Ref="46" type="Stimulsoft.Report.Chart.StiStyle25" isKey="true">
                <Conditions isList="true" count="0" />
                <Name />
              </Style>
              <Table Ref="47" type="Stimulsoft.Report.Chart.StiChartTable" isKey="true">
                <DataCells Ref="48" type="Stimulsoft.Report.Chart.StiChartTableDataCells" isKey="true">
                  <Font>Tahoma,8</Font>
                  <ShrinkFontToFit>False</ShrinkFontToFit>
                  <TextColor>140, 140, 140</TextColor>
                </DataCells>
                <GridLineColor>225, 225, 225</GridLineColor>
                <Header Ref="49" type="Stimulsoft.Report.Chart.StiChartTableHeader" isKey="true">
                  <Brush>White</Brush>
                  <Font>Arial,8</Font>
                  <TextColor>DarkGray</TextColor>
                </Header>
              </Table>
              <Title Ref="50" type="Stimulsoft.Report.Chart.StiChartTitle" isKey="true">
                <Brush>[140:140:140]</Brush>
                <Font>Tahoma,12,Bold</Font>
              </Title>
            </Chart1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>GroupYear</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataGroupYear</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </DataGroupYear>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>89ddf5f60ec940ee96929c3276e3455c</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <PageHeight>11</PageHeight>
      <PageWidth>8.5</PageWidth>
      <PaperSize>Letter</PaperSize>
      <Report isRef="0" />
      <Watermark Ref="51" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="52" 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>BarGraphTest</ReportAlias>
  <ReportChanged>1/27/2017 4:35:33 PM</ReportChanged>
  <ReportCreated>1/25/2017 3:19:43 PM</ReportCreated>
  <ReportFile>D:\BarGraphTest_1.mrt</ReportFile>
  <ReportGuid>96c24160a1eb4ca6af47e3c00a79c3ac</ReportGuid>
  <ReportImage isNull="true" />
  <ReportName>BarGraphTest</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2016.3.5</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 BarGraphTest : Stimulsoft.Report.StiReport
    {
        public BarGraphTest()        {
            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>