﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <BeginRenderEvent>//Chart1.Series["S1"].Values = "1;2;3;4;5"</BeginRenderEvent>
  <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>1G7/oU8FMYHLTanY5CVlF9d29S5NS1Pdy0y5lOk9oF6CxPvLzE/T/Gxc/fRjdGU7kHD3q+Zdc8XiWqHEahilL9xwZYNWXdOpw1397Gg=</ConnectionStringEncrypted>
        <Name>VUEWorksDB</Name>
      </VUEWorksDB>
    </Databases>
    <DataSources isList="true" count="1">
      <WorkOrders Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>WorkOrders</Alias>
        <Columns isList="true" count="67">
          <value>ID,System.Int32</value>
          <value>WorkOrderID,System.String</value>
          <value>LoggedDate,System.DateTime</value>
          <value>LoggedByID,System.Int32</value>
          <value>LoggedByName,System.String</value>
          <value>BeginDate,System.DateTime</value>
          <value>EndDate,System.DateTime</value>
          <value>AssignedDate,System.DateTime</value>
          <value>AssignedToID,System.Int32</value>
          <value>AssignedToName,System.String</value>
          <value>AssignedByID,System.Int32</value>
          <value>AssignedByName,System.String</value>
          <value>TypeID,System.Int32</value>
          <value>TypeName,System.String</value>
          <value>DepartmentID,System.Int32</value>
          <value>DepartmentName,System.String</value>
          <value>GroupID,System.Int32</value>
          <value>GroupName,System.String</value>
          <value>ActivityDescriptionID,System.Int32</value>
          <value>ActivityDescription,System.String</value>
          <value>Location,System.String</value>
          <value>Description,System.String</value>
          <value>Priority,System.Int32</value>
          <value>Status,System.String</value>
          <value>StatusName,System.String</value>
          <value>IsRecurringTemplate,System.Boolean</value>
          <value>ClosureDate,System.DateTime</value>
          <value>ClosedByID,System.Int32</value>
          <value>ClosedByName,System.String</value>
          <value>ParentWorkOrderID,System.Int32</value>
          <value>ParentServiceRequestID,System.Int32</value>
          <value>ParentID,System.String</value>
          <value>ProjectTitle,System.String</value>
          <value>ProjectGroup,System.String</value>
          <value>LaborCost,System.Decimal</value>
          <value>EquipmentCost,System.Decimal</value>
          <value>InventoryCost,System.Decimal</value>
          <value>VendorCost,System.Decimal</value>
          <value>OtherCost,System.Decimal</value>
          <value>TotalCost,System.Decimal</value>
          <value>LaborCostDescription,System.String</value>
          <value>EquipmentCostDescription,System.String</value>
          <value>InventoryCostDescription,System.String</value>
          <value>VendorCostDescription,System.String</value>
          <value>OtherCostDescription,System.String</value>
          <value>LaborHours,System.Decimal</value>
          <value>VendorHours,System.Decimal</value>
          <value>EquipmentHours,System.Decimal</value>
          <value>EstimatedLaborCost,System.Decimal</value>
          <value>EstimatedEquipmentCost,System.Decimal</value>
          <value>EstimatedInventoryCost,System.Decimal</value>
          <value>EstimatedVendorCost,System.Decimal</value>
          <value>EstimatedOtherCost,System.Decimal</value>
          <value>EstimatedTotalCost,System.Decimal</value>
          <value>EstimatedLaborCostDescription,System.String</value>
          <value>EstimatedEquipmentCostDescription,System.String</value>
          <value>EstimatedInventoryCostDescription,System.String</value>
          <value>EstimatedVendorCostDescription,System.String</value>
          <value>EstimatedOtherCostDescription,System.String</value>
          <value>EstimatedLaborHours,System.Decimal</value>
          <value>EstimatedVendorHours,System.Decimal</value>
          <value>EstimatedEquipmentHours,System.Decimal</value>
          <value>PointX,System.Decimal</value>
          <value>PointY,System.Decimal</value>
          <value>Latitude,System.Decimal</value>
          <value>Longitude,System.Decimal</value>
          <value>SpatialReference,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>WorkOrders</Name>
        <NameInSource>VUEWorksDB</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select v.* from [reports].[WorkOrders] v</SqlCommand>
      </WorkOrders>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="10">
      <value>,UserID,UserID,,System.Int32,_x0032_03,False,False,False,True</value>
      <value>,UserName,UserName,,System.String,Administrator,False,False,False,True</value>
      <value>,ReportID,ReportID,,System.Int32,_x0034_85,False,False,False,True</value>
      <value>,ProviderType,ProviderType,,System.Int32,_x0031_,False,False,False,True</value>
      <value>,ReportName,ReportName,,System.String,DynamicChart,False,False,False,True</value>
      <value>,CategoryName,CategoryName,,System.String,For_VUEWorks,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>
      <value>,varChartColumn,Choose_x0020_a_x0020_Chart_x0020_Column:,,System.String,,False,False,True,False,_x003C__x003F_xml_x0020_version_x003D__x0022_1.0_x0022__x0020_encoding_x003D__x0022_utf-16_x0022__x0020_standalone_x003D__x0022_yes_x0022__x003F__x003E__x003C_StiSerializer_x0020_version_x003D__x0022_1.02_x0022__x0020_type_x003D__x0022_Net_x0022__x0020_application_x003D__x0022_State_x0022__x003E__x003C_BindingVariable_x0020_isNull_x003D__x0022_true_x0022__x0020__x002F__x003E__x003C_AllowUserValues_x003E_False_x003C__x002F_AllowUserValues_x003E__x003C_Keys_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_3_x0022__x003E__x003C_value_x003E_DepartmentID_x003C__x002F_value_x003E__x003C_value_x003E_GroupID_x003C__x002F_value_x003E__x003C_value_x003E_ActivityDescriptionID_x003C__x002F_value_x003E__x003C__x002F_Keys_x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_3_x0022__x003E__x003C_value_x003E_DepartmentID_x003C__x002F_value_x003E__x003C_value_x003E_GroupID_x003C__x002F_value_x003E__x003C_value_x003E_ActivityDescriptionID_x003C__x002F_value_x003E__x003C__x002F_Values_x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_</value>
      <value>,myVal,myVal,,System.String,GroupID,False,False,False,False</value>
    </Variables>
  </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="1">
        <Chart1 Ref="5" type="Stimulsoft.Report.Chart.StiChart" isKey="true">
          <Area Ref="6" type="Stimulsoft.Report.Chart.StiClusteredColumnArea" isKey="true">
            <BorderColor>171, 172, 173</BorderColor>
            <Brush>White</Brush>
            <Chart isRef="5" />
            <GridLinesHor Ref="7" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
              <Area isRef="6" />
              <Color>100, 105, 105, 105</Color>
              <MinorColor>100, 105, 105, 105</MinorColor>
            </GridLinesHor>
            <GridLinesHorRight Ref="8" type="Stimulsoft.Report.Chart.StiGridLinesHor" isKey="true">
              <Area isRef="6" />
              <Color>Silver</Color>
              <MinorColor>Gainsboro</MinorColor>
              <Visible>False</Visible>
            </GridLinesHorRight>
            <GridLinesVert Ref="9" type="Stimulsoft.Report.Chart.StiGridLinesVert" isKey="true">
              <Area isRef="6" />
              <Color>100, 105, 105, 105</Color>
              <MinorColor>100, 105, 105, 105</MinorColor>
            </GridLinesVert>
            <InterlacingHor Ref="10" type="Stimulsoft.Report.Chart.StiInterlacingHor" isKey="true">
              <Area isRef="6" />
              <InterlacedBrush>[10:155:155:155]</InterlacedBrush>
            </InterlacingHor>
            <InterlacingVert Ref="11" type="Stimulsoft.Report.Chart.StiInterlacingVert" isKey="true">
              <Area isRef="6" />
              <InterlacedBrush>[10:155:155:155]</InterlacedBrush>
            </InterlacingVert>
            <XAxis Ref="12" type="Stimulsoft.Report.Chart.StiXBottomAxis" isKey="true">
              <Area isRef="6" />
              <DateTimeStep Ref="13" type="Stimulsoft.Report.Chart.StiAxisDateTimeStep" isKey="true" />
              <Interaction Ref="14" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
              <Labels Ref="15" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                <Color>140, 140, 140</Color>
                <Font>Tahoma,8</Font>
              </Labels>
              <LineColor>140, 140, 140</LineColor>
              <Range Ref="16" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
              <Ticks Ref="17" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
              <Title Ref="18" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                <Color>140, 140, 140</Color>
                <Font>Tahoma,12,Bold</Font>
              </Title>
            </XAxis>
            <XTopAxis Ref="19" type="Stimulsoft.Report.Chart.StiXTopAxis" isKey="true">
              <Area isRef="6" />
              <Interaction Ref="20" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
              <Labels Ref="21" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                <Color>140, 140, 140</Color>
                <Font>Tahoma,8</Font>
              </Labels>
              <LineColor>140, 140, 140</LineColor>
              <Ticks Ref="22" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
              <Title Ref="23" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                <Color>140, 140, 140</Color>
                <Font>Tahoma,12,Bold</Font>
              </Title>
            </XTopAxis>
            <YAxis Ref="24" type="Stimulsoft.Report.Chart.StiYLeftAxis" isKey="true">
              <Area isRef="6" />
              <Interaction Ref="25" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
              <Labels Ref="26" type="Stimulsoft.Report.Chart.StiAxisLabels" isKey="true">
                <Color>140, 140, 140</Color>
                <Font>Tahoma,8</Font>
              </Labels>
              <LineColor>140, 140, 140</LineColor>
              <Range Ref="27" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
              <Ticks Ref="28" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
              <Title Ref="29" type="Stimulsoft.Report.Chart.StiAxisTitle" isKey="true">
                <Color>140, 140, 140</Color>
                <Direction>BottomToTop</Direction>
                <Font>Tahoma,12,Bold</Font>
              </Title>
            </YAxis>
            <YRightAxis Ref="30" type="Stimulsoft.Report.Chart.StiYRightAxis" isKey="true">
              <Area isRef="6" />
              <Interaction Ref="31" type="Stimulsoft.Report.Chart.StiAxisInteraction" isKey="true" />
              <Labels Ref="32" 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="33" type="Stimulsoft.Report.Chart.StiAxisRange" isKey="true" />
              <Ticks Ref="34" type="Stimulsoft.Report.Chart.StiAxisTicks" isKey="true" />
              <Title Ref="35" 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.5,0.4,6.8,3.5</ClientRectangle>
          <Conditions isList="true" count="0" />
          <ConstantLines isList="true" count="0" />
          <CustomStyleName />
          <DataRelationName isNull="true" />
          <Filters isList="true" count="0" />
          <Legend Ref="36" type="Stimulsoft.Report.Chart.StiLegend" isKey="true">
            <BorderColor>225, 225, 225</BorderColor>
            <Brush>[255:255:255]</Brush>
            <Chart isRef="5" />
            <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>
          <Name>Chart1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Series isList="true" count="1">
            <Item5 Ref="37" type="Stimulsoft.Report.Chart.StiClusteredColumnSeries" isKey="true">
              <Argument>{WorkOrders.BeginDate}</Argument>
              <BorderColor>255, 255, 255</BorderColor>
              <Brush>[112:173:71]</Brush>
              <BrushNegative>Firebrick</BrushNegative>
              <Chart isRef="5" />
              <Conditions isList="true" count="0" />
              <Filters isList="true" count="0" />
              <SeriesLabels Ref="38" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
                <BorderColor>Transparent</BorderColor>
                <Brush>Transparent</Brush>
                <Chart isRef="5" />
                <Font>Arial,10</Font>
                <LabelColor>51, 71, 91</LabelColor>
                <MarkerSize>8, 6</MarkerSize>
                <ValueTypeSeparator>-</ValueTypeSeparator>
                <Width>0</Width>
              </SeriesLabels>
              <ShowShadow>False</ShowShadow>
              <Title>S1</Title>
              <TopN Ref="39" type="Stimulsoft.Report.Chart.StiSeriesTopN" isKey="true" />
              <TrendLine Ref="40" type="Stimulsoft.Report.Chart.StiTrendLineNone" isKey="true">
                <LineColor>105, 105, 105</LineColor>
                <ShowShadow>False</ShowShadow>
              </TrendLine>
              <Value>{WorkOrders[varChartColumn]}</Value>
            </Item5>
          </Series>
          <SeriesLabels Ref="41" type="Stimulsoft.Report.Chart.StiCenterAxisLabels" isKey="true">
            <BorderColor>Transparent</BorderColor>
            <Brush>Transparent</Brush>
            <Chart isRef="5" />
            <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="42" type="Stimulsoft.Report.Chart.StiStyle25" isKey="true">
            <Conditions isList="true" count="0" />
            <Name />
          </Style>
          <Table Ref="43" type="Stimulsoft.Report.Chart.StiChartTable" isKey="true">
            <DataCells Ref="44" 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="45" type="Stimulsoft.Report.Chart.StiChartTableHeader" isKey="true">
              <Brush>White</Brush>
              <Font>Arial,8</Font>
              <TextColor>DarkGray</TextColor>
            </Header>
          </Table>
          <Title Ref="46" 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" />
      <Guid>bd91a60f492e41559f741b7ca6556b4e</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="47" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="48" 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>DynamicChart</ReportAlias>
  <ReportAuthor>Administrator</ReportAuthor>
  <ReportChanged>6/6/2017 3:13:02 AM</ReportChanged>
  <ReportCreated>6/5/2017 12:20:23 PM</ReportCreated>
  <ReportFile>C:\Users\Eduard\Downloads\Stimulsoft\1\Carl\sample\DynamicChart2.mrt</ReportFile>
  <ReportGuid>05756dd049cc41e9b6a55ba788c5ddab</ReportGuid>
  <ReportImage isNull="true" />
  <ReportName>DynamicChart</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2017.1.4.0</ReportVersion>
  <RequestParameters>True</RequestParameters>
  <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 DynamicChart : Stimulsoft.Report.StiReport
    {
        public DynamicChart()        {
            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>