TestDB 1G5poU9dMeXLTanY5CVlF9dw2S5NWVOBy0y5lOpcrF7D8vfLzQMx/GxJ/YRjXGU7i3aNC09Pc8XiTaGIYhinG99gzevFWVuFbls1hA== TestDB WorkOrders ID,System.Int32 WorkOrderID,System.String LoggedDate,System.DateTime LoggedByID,System.Int32 LoggedByName,System.String BeginDate,System.DateTime EndDate,System.DateTime AssignedDate,System.DateTime AssignedToID,System.Int32 AssignedToName,System.String AssignedByID,System.Int32 AssignedByName,System.String TypeID,System.Int32 TypeName,System.String DepartmentID,System.Int32 DepartmentName,System.String GroupID,System.Int32 GroupName,System.String ActivityDescriptionID,System.Int32 ActivityDescription,System.String Location,System.String Description,System.String Priority,System.Int32 Status,System.String StatusName,System.String IsRecurringTemplate,System.Boolean ClosureDate,System.DateTime ClosedByID,System.Int32 ClosedByName,System.String ParentWorkOrderID,System.Int32 ParentServiceRequestID,System.Int32 ParentID,System.String LaborCost,System.Decimal EquipmentCost,System.Decimal InventoryCost,System.Decimal VendorCost,System.Decimal OtherCost,System.Decimal TotalCost,System.Decimal LaborCostDescription,System.String EquipmentCostDescription,System.String InventoryCostDescription,System.String VendorCostDescription,System.String OtherCostDescription,System.String LaborHours,System.Decimal VendorHours,System.Decimal EstimatedLaborCost,System.Decimal EstimatedEquipmentCost,System.Decimal EstimatedInventoryCost,System.Decimal EstimatedVendorCost,System.Decimal EstimatedOtherCost,System.Decimal EstimatedTotalCost,System.Decimal EstimatedLaborCostDescription,System.String EstimatedEquipmentCostDescription,System.String EstimatedInventoryCostDescription,System.String EstimatedVendorCostDescription,System.String EstimatedOtherCostDescription,System.String EstimatedLaborHours,System.Decimal EstimatedVendorHours,System.Decimal PointX,System.Decimal PointY,System.Decimal Latitude,System.Decimal Longitude,System.Decimal SpatialReference,System.Int32 LoggedYear,System.Int32 30 False WorkOrders TestDB Select *, Year(LoggedDate) as LoggedYear from WorkOrders UniqueYears LoggedYear,System.Int32 30 False UniqueYears TestDB Select distinct Year(LoggedDate) as LoggedYear from WorkOrders WorkOrderTasks ID,System.Int32 Position,System.Int32 Description,System.String Notes,System.String DateCompleted,System.DateTime IsCompleted,System.Int32 30 False WorkOrderTasks TestDB Select * from Tasks Relation1 LoggedYear Relation1 Relation1 LoggedYear TasksWorkOrdersRelation ID TasksWorkOrdersRelation TasksWorkOrdersRelation ID WorkOrdersTasksRelation ID WorkOrdersTasksRelation WorkOrdersTasksRelation ID ,UserID,UserID,System.Int32,_x0032_03,False,False ,UserName,UserName,System.String,Administrator,False,False ,ReportID,ReportID,System.Int32,_x0032_43,False,False ,ProviderType,ProviderType,System.Int32,_x0031_,False,False ,ReportName,ReportName,System.String,WorkOrderTaskReport,False,False ,CategoryName,CategoryName,System.String,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent True True 0,0.2,7.72,0.6 Transparent 0,0.3,7.7,0.3 SubReport1 d7c8ead12933e4175b46475eadb716af Transparent 0,0.1,7.7,0.2 Arial,10,Bold Center 0,0,0,0 Text2 {UniqueYears.LoggedYear} Black DataColumn UniqueYears DataBand1 ef213ae0fee3488cbb39f8b74b530734 0.39,0.39,0.39,0.39 Page1 11 8.5 Letter Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.7,0.2 Transparent 0,0,2.1,0.2 Arial,10 0,0,0,0 Text1 {WorkOrders.ActivityDescription} Black DataColumn Transparent 2.6,0,1.4,0.2 Arial,10 0,0,0,0 Text4 Count: {Count(GroupHeaderBand1)} Black Expression {WorkOrders.ActivityDescription} GroupHeaderBand1 Transparent 0,0.8,7.7,0.1 Transparent 0,0,7.7,0.1 SubReport2 b89935c4d57d539c8751476f3bc4756b Relation1 WorkOrders DataBand2 d7c8ead12933e4175b46475eadb716af 0.39,0.39,0.39,0.39 Page_SubReport1 11.69 8.48 Arial,100 [50:0:0:0] None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.7,0.2 Transparent 1.3,0,4.1,0.2 Arial,10 0,0,0,0 Text3 {WorkOrderTasks.Description} Black DataColumn Transparent 5.7,0,1.9,0.2 Arial,10 0,0,0,0 Text5 Count: {Count(GroupHeaderBand2)} Black Expression {WorkOrderTasks.Description} GroupHeaderBand2 Transparent 0,0.8,7.7,0 WorkOrdersTasksRelation WorkOrderTasks DataBand3 b89935c4d57d539c8751476f3bc4756b 0.39,0.39,0.39,0.39 Page_SubReport2 11.69 8.48 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll WorkOrderTaskReport Administrator 10/8/2015 1:12:15 PM 10/8/2015 8:58:25 AM C:\inetpub\wwwroot\VUEWorks\\Custom\Stratford\Reports\WorkOrder\WorkOrderTaskReport.mrt 3a65ab0e1d8ebcd5e54d4838bc9e9e59 WorkOrderTaskReport Inches 2014.3.0 CSharp