VUEWorksDB 1FJpicddAYFgCKnYymzrZ8Nas2DvWnk5Qlu5vWVEoi/DcM2hTVlLiHpJ2Z3kTDISi8j5KWUD05XHbaXYwynkL+TIzSM= VUEWorksDB CornwallGIS 1FKVoe9ZAZVgWKnMy2x3F8N2gSNGS6ld+Vu5gWREbWbReruhTxir8GkVfQhleDLbwnD3I2UFu51iSYS9z1z0L8XI+6JPXPs= CornwallGIS 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 30 False WorkOrders VUEWorksDB select v.* from [reports].[WorkOrders] v HydrantData OBJECTID,System.Int32 AncillaryRole,System.Int16 Enabled,System.Int16 FacilityID,System.String InstallDate,System.DateTime LocationDescription,System.String Rotation,System.Decimal LifecycleStatus,System.String Manufacturer,System.String Hydrant_ID,System.String AssetLabel,System.String Function_,System.String Street,System.String Zone_,System.String Model,System.String Type,System.String OpeningDir,System.String Diameter,System.Int32 YrManufact,System.Int32 NumTurns,System.Int32 SourceID,System.String cadfile,System.String Pressure,System.String FCODE,System.String ID,System.Int32 AssetID,System.Int32 FireFlowRating,System.String FireRating,System.String FireRatingValue,System.String Easting,System.Int32 Northing,System.Int32 ProvAssetID,System.String Shape,System.Object DD_Lat,System.Decimal DD_Long,System.Decimal 30 False HydrantData CornwallGIS select * from dbo.wHydrant ,UserID,UserID,System.Int32,_x002D_1,False,False ,UserName,UserName,System.String,_x0020_,False,False ,ReportID,ReportID,System.Int32,_x0031_25,False,False ,ProviderType,ProviderType,System.Int32,_x0031_,False,False ,ReportName,ReportName,System.String,HydrantTest,False,False ,CategoryName,CategoryName,System.String,Water,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.72,0.2 Transparent 1.1,0,0.6,0.2 Arial,10 0,0,0,0 Text1 {HydrantData.LocationDescription} Black Transparent 0,0,1.1,0.2 Arial,10 0,0,0,0 Text2 LocationDescription Black HydrantData DataBand1 b884601c96e2402ea3e5680b01729084 0.39,0.39,0.39,0.39 Page1 11 8.5 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 HydrantTest 4/8/2016 12:11:33 PM 4/8/2016 11:08:05 AM HydrantTest.mrt a47ce46707c913d62a40f66c5c5219e4 HydrantTest Inches 2014.3.0 CSharp