﻿<?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">
      <MSSQL1 Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>MSSQL1</Alias>
        <ConnectionStringEncrypted>+XTLSU9ZARXhbKHsYZjjY57ygSthezGkfEO5BGFYYxfVVGkJVkzjnWtEodxkdONj0Xj7idUY+83iXL3MwxwlE8lU98nI</ConnectionStringEncrypted>
        <Name>MSSQL1</Name>
      </MSSQL1>
    </Databases>
    <DataSources isList="true" count="2">
      <Tasks Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>Tasks</Alias>
        <Columns isList="true" count="6">
          <value>ID,System.Int32</value>
          <value>Position,System.Int32</value>
          <value>Description,System.String</value>
          <value>Notes,System.String</value>
          <value>DateCompleted,System.DateTime</value>
          <value>IsCompleted,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>Tasks</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from Tasks</SqlCommand>
      </Tasks>
      <WorkOrders Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>WorkOrders</Alias>
        <Columns isList="true" count="63">
          <value>ID,System.Int32</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>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>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>PointX,System.Decimal</value>
          <value>PointY,System.Decimal</value>
          <value>Latitude,System.Decimal</value>
          <value>Longitude,System.Decimal</value>
          <value>SpatialReference,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>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>WorkOrders</Name>
        <NameInSource>MSSQL1</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from WorkOrders</SqlCommand>
      </WorkOrders>
    </DataSources>
    <Relations isList="true" count="1">
      <Orders Ref="5" type="DataRelation" isKey="true">
        <Alias>Orders</Alias>
        <ChildColumns isList="true" count="1">
          <value>ID</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ID</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Orders>
    </Relations>
    <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="6" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="4">
        <GroupHeaderBand1 Ref="7" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text2 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,19,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Text>{Year(Tasks.Orders.LoggedDate)}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text2>
          </Components>
          <Condition>{Year(Tasks.Orders.LoggedDate)}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
        </GroupHeaderBand1>
        <GroupHeaderBand2 Ref="9" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.8,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text3 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,19,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="6" />
              <Parent isRef="9" />
              <Text>{Tasks.Orders.ActivityDescription}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text3>
          </Components>
          <Condition>{Tasks.Orders.ActivityDescription}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand2</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
        </GroupHeaderBand2>
        <GroupHeaderBand3 Ref="11" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.2,19,0.6</ClientRectangle>
          <Components isList="true" count="1">
            <Text1 Ref="12" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,19,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="6" />
              <Parent isRef="11" />
              <Text>{Tasks.Description}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text1>
          </Components>
          <Condition>{Tasks.Description}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand3</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
        </GroupHeaderBand3>
        <DataTasks Ref="13" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,4.6,19,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <DataSourceName>Tasks</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataTasks</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </DataTasks>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>b7a82cbd8a1d46b392335b485bed64a2</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="14" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="15" 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>10/9/2015 2:44:13 PM</ReportChanged>
  <ReportCreated>10/9/2015 1:23:55 PM</ReportCreated>
  <ReportFile>F:\Support\Report.mrt</ReportFile>
  <ReportGuid>617593f4b363489490e96424802f9fac</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2015.2.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>