VUEWorksDB 1G7/oU8FMYHLTanY5CVlF9d29S5NS1Pdy0y5lOk9oF6CxPvLzE/T/Gxc/fRjdGU7kHD3q+Zdc8XiWqHEahilL9xwZYNWXdOpw1397Gg= VUEWorksDB 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 ProjectTitle,System.String ProjectGroup,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 EquipmentHours,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 EstimatedEquipmentHours,System.Decimal PointX,System.Decimal PointY,System.Decimal Latitude,System.Decimal Longitude,System.Decimal SpatialReference,System.Int32 30 WorkOrders VUEWorksDB select v.* from [reports].[WorkOrders] v inner join [reports].[WorkOrderUserSelectionSet] ul on v.ID = ul.ID where ul.UserID = {UserID} AND v.DepartmentName = 'Plannning' ,UserID,UserID,,System.Int32,_x0032_03,False,False,False,True ,ReportID,ReportID,,System.Int32,_x0034_33,False,False,False,True ,ProviderType,ProviderType,,System.Int32,_x0034_,False,False,False,True ,ReportName,ReportName,,System.String,PerformanceMeasures,False,False,False,True ,CategoryName,CategoryName,,System.String,,False,False,False,True ,UserName,UserName,,System.String,_x0020_,False,False,False,True ,LayerID,LayerID,,System.Int32,,False,False,False,True ,UseSelection,UseSelection,,System.String,True,False,False,False,True EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,7.42,10.22,0.3 All;[165:165:165];1;None;False;4;Black EmptyBrush 0.07,0.05,1.7,0.2 Arial,9 0,0,0,0 Text2 {PageNofM} [81:56:11] Center All;[165:165:165];1;None;False;4;Black EmptyBrush 8.36,0.05,1.8,0.2 Arial,9 Right 0,0,0,0 Text4 {Today} [81:56:11] MM/dd/yyyy Center PageFooterBand1 Transparent 0,0.2,10.22,0.4 Transparent 0,0,10.2,0.2 Arial,10,Bold Center 0,0,0,0 Text3 Planning Black Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 2.5,0.2,0.6,0.2 Arial,10 dd8a9758aafb773ba822612444257d1e Center 0,0,0,0 Text74 {Today.ToString("MMM")} {Year(Today)} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 3.1,0.2,0.6,0.2 Arial,10 2783df1847bc3f4ba056612444250fad Center 0,0,0,0 Text59 {Today.AddMonths(1).ToString("MMM")} {Year(Today.AddMonths(1))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 3.7,0.2,0.6,0.2 Arial,10 7583a3edd72a23dcbd9b612444254218 Center 0,0,0,0 Text61 {Today.AddMonths(2).ToString("MMM")} {Year(Today.AddMonths(2))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 4.3,0.2,0.6,0.2 Arial,10,Bold b71f0a3d3de496b7befb61244425b38b Center 0,0,0,0 Text62 {Today.AddMonths(3).ToString("MMM")} {Year(Today.AddMonths(3))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 4.9,0.2,0.6,0.2 Arial,10,Bold 026105db165723950c4d61244425c038 Center 0,0,0,0 Text63 {Today.AddMonths(4).ToString("MMM")} {Year(Today.AddMonths(4))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 5.5,0.2,0.6,0.2 Arial,10,Bold 70ff4db78d843e5e713161244425aab1 Center 0,0,0,0 Text64 {Today.AddMonths(5).ToString("MMM")} {Year(Today.AddMonths(5))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 6.1,0.2,0.7,0.2 Arial,10,Bold c45615ea470411ba25f3612444252a5f Center 0,0,0,0 Text65 {Today.AddMonths(6).ToString("MMM")} {Year(Today.AddMonths(6))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 6.8,0.2,0.6,0.2 Arial,10,Bold 404162ef71c438773cf961244425a93a Center 0,0,0,0 Text66 {Today.AddMonths(7).ToString("MMM")} {Year(Today.AddMonths(7))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 7.4,0.2,0.7,0.2 Arial,10,Bold 60bac19b800ec37959d46124442532ff Center 0,0,0,0 Text67 {Today.AddMonths(8).ToString("MMM")} {Year(Today.AddMonths(8))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 8.1,0.2,0.6,0.2 Arial,10,Bold d62928ee1a68e52c85a261244425127a Center 0,0,0,0 Text68 {Today.AddMonths(9).ToString("MMM")} {Year(Today.AddMonths(9))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 8.7,0.2,0.7,0.2 Arial,10,Bold e8496dc9dfb548e108bd61244425decf Center 0,0,0,0 Text69 {Today.AddMonths(10).ToString("MMM")} {Year(Today.AddMonths(10))} [81:56:11] Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 9.4,0.2,0.7,0.2 Arial,10,Bold 4a327d71f013800be5bb612444259517 Center 0,0,0,0 Text70 {Today.AddMonths(11).ToString("MMM")} {Year(Today.AddMonths(11))} [81:56:11] Expression Center {WorkOrders.DepartmentName} GroupHeaderBand2 Transparent 0,1,10.22,0.2 All;[140:140:140];1;Solid;False;4;Black Transparent 0,0,2.5,0.2 Arial,10 5c47ddeb83e44e1f29806123d1162093 0,0,0,0 Text60 True 8 {ToProperCase(WorkOrders.ActivityDescription)} [81:56:11] Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 2.5,0,0.6,0.2 Arial,10 508d397bcbb4a09ffbe56123d116aa40 True Center 0,0,0,0 Text1 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==Month(Today) && Year(WorkOrders.BeginDate) ==Year(Today))} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 3.1,0,0.6,0.2 Arial,10 6e81f827ab2ffde7fa696123d116f2b7 True Center 0,0,0,0 Text47 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==2)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 3.7,0,0.6,0.2 Arial,10 4ee0b8e0850362c8c3d06123d116e8be True Center 0,0,0,0 Text48 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==3)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 4.3,0,0.6,0.2 Arial,10 e13d7d65d09d9e3c57676123d116cdef True Center 0,0,0,0 Text49 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==4)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 4.9,0,0.6,0.2 Arial,10 c703790f8b133a124ef06123d1167028 True Center 0,0,0,0 Text50 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==5)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 5.5,0,0.6,0.2 Arial,10 3bddd3d7d6f86c0f54bf6123d1165240 True Center 0,0,0,0 Text51 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==6)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 6.1,0,0.7,0.2 Arial,10 98ca87bed9e7f5300bf16123d11621cf True Center 0,0,0,0 Text52 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==7)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 6.8,0,0.6,0.2 Arial,10 baaa24ec4a87eae6a7946123d116cea3 True Center 0,0,0,0 Text53 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==8)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 7.4,0,0.7,0.2 Arial,10 1a24c4f4671d79adffb96123d1162e73 True Center 0,0,0,0 Text54 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==9)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 8.1,0,0.6,0.2 Arial,10 7cdf5aa760017677b3fa6123d116ffab True Center 0,0,0,0 Text55 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==10)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 8.7,0,0.7,0.2 Arial,10 59de770faa3ff496b8cd6123d116d17d True Center 0,0,0,0 Text56 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==11)} [81:56:11] # Expression Center All;[140:140:140];1;Solid;False;4;Black Transparent 9.4,0,0.7,0.2 Arial,10 3792286a19b8f25d72d46123d1163b53 True Center 0,0,0,0 Text57 True 8 {CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==12)} [81:56:11] # Expression Center {WorkOrders.ActivityDescription} 312f69254b2f12ed689c6123d116d135 GroupHeaderBand1 Transparent True 0,1.6,10.22,0 WorkOrders DataBand1 Transparent 0,2,10.22,0 GroupFooterBand1 Transparent 0,2.4,10.22,0.2 All;Black;1;Solid;False;4;Black WhiteSmoke 2.5,0,0.6,0.2 Arial,10,Bold 47654285ac9cf69f43e86124708142fa True Center 0,0,0,0 Text88 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==1)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 3.1,0,0.6,0.2 Arial,10,Bold c700226be61af86cf72d61247081448a True Center 0,0,0,0 Text73 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==2)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 3.7,0,0.6,0.2 Arial,10,Bold 25dc18d55dc278b4f1e1612470819b38 True Center 0,0,0,0 Text75 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==3)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 4.3,0,0.6,0.2 Arial,10,Bold 48473ee041166f38740a61247081e1f9 True Center 0,0,0,0 Text76 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==4)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 4.9,0,0.6,0.2 Arial,10,Bold f2b0c7a2f8188faf91a661247081e8c5 True Center 0,0,0,0 Text77 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==5)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 5.5,0,0.6,0.2 Arial,10,Bold 337e1575d11e31b2651d61247081419b True Center 0,0,0,0 Text78 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==6)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 6.1,0,0.7,0.2 Arial,10,Bold 1a3b6c4e16ee30326ccd6124708122cd True Center 0,0,0,0 Text79 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==7)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 6.8,0,0.6,0.2 Arial,10,Bold e5e63fb85615c299f7c161247081c59f True Center 0,0,0,0 Text80 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==8)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 7.4,0,0.7,0.2 Arial,10,Bold 5a3f93f470f1bfe92121612470814f3e True Center 0,0,0,0 Text81 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==9)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 8.1,0,0.6,0.2 Arial,10,Bold 0d51f8fa62a4e8110db9612470813265 True Center 0,0,0,0 Text82 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==10)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 8.7,0,0.7,0.2 Arial,10,Bold 381a5f01000240cfe19261247081403c True Center 0,0,0,0 Text83 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==11)} [81:56:11] # Expression Center All;Black;1;Solid;False;4;Black WhiteSmoke 9.4,0,0.7,0.2 Arial,10,Bold 6394b6d4f90e1d7d4e24612470810911 True Center 0,0,0,0 Text84 True 8 {CountIf(DataBand1,Month(WorkOrders.BeginDate)==12)} [81:56:11] # Expression Center GroupFooterBand2 05a8f16eb3514473b97376fa295649a5 0.39,0.39,0.39,0.39 Page1 Landscape 8.5 11 Letter 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 PerformanceMeasures 4/26/2017 3:14:43 PM 9/11/2014 8:24:32 AM PerformanceMeasures.mrt d2dbfd94ea89697cb021ab5bb3175155 PerformanceMeasures Inches 2015.3.0 CSharp