VUEWorksDB 1BT5oU1QQvVhe+XMaACgF4tUZeNbBVGRa1u5kOpE6yrRcPtJyAV7hWlcsPD7Jec/w3Cr6c1d2Z3pCP296Zjlatl40evJFXuB VUEWorksDB GIS_Data_Connection 1Na3ie9dAYnjSbXAYWykZ4BU2wBnXfukywjtxGoc4xvEWMHCxgWjBelJtdxhEOFu08hpy8QF083DTO3J4Q== GIS_Data_Connection WorkOrderDocuments ID,System.Int32 Url,System.String Document,System.String 240 WorkOrderDocuments VUEWorksDB select ID,Url,Document from [reports].[WorkOrderDocuments] WorkOrders ID,System.Int32 WorkOrderID,System.String LoggedByName,System.String LoggedDate,System.DateTime ParentServiceRequestID,System.Int32 TypeName,System.String DepartmentName,System.String GroupName,System.String AssignedToName,System.String ActivityDescription,System.String Location,System.String Description,System.String StatusName,System.String Priority,System.Int32 BeginDate,System.DateTime EndDate,System.DateTime ProjectGroup,System.String ProjectTitle,System.String ClosedByName,System.String ClosureDate,System.DateTime 30 WorkOrders VUEWorksDB select v.ID,v.WorkOrderID,v.LoggedByName,v.LoggedDate,v.ParentServiceRequestID,v.TypeName,v.DepartmentName,v.GroupName,v.AssignedToName,v.ActivityDescription,v.Location,v.Description,v.StatusName,v.Priority,v.BeginDate,v.EndDate,v.ProjectGroup,v.ProjectTitle,v.ClosedByName,v.ClosureDate from [reports].[WorkOrders] v inner join [reports].[WorkOrderUserSelectionSet] ul on v.ID = ul.ID where ul.UserID = {UserID} Unique_InspectionAreas InspectionArea,System.String 240 Unique_InspectionAreas GIS_Data_Connection Select distinct t.IArea as InspectionArea from (select UPPER(LEFT(Name,1)) + Lower(RIGHT(Name,LEN(Name) - 1)) as IArea from NPDES_InspectionAreas) t UNION select 'Rural' as InspectionArea UNION select '' as InspectionArea StormwaterGISData AssetID,System.String InspectionArea,System.String Layer_Name,System.String 240 StormwaterGISData GIS_Data_Connection Select AssetID,InspectionArea, 'CatchBasins' as Layer_Name from dbo.Catchbasins UNION Select AssetID,InspectionArea, 'PipesDitchesSwales' as Layer_Name from dbo.PipesDitchesSwales UNION Select AssetID,InspectionArea, 'Ponds' as Layer_Name from dbo.Ponds WorkOrderAssets ID,System.Int32 LayerID,System.Int32 Layer_Name,System.String AssetID,System.String 240 WorkOrderAssets VUEWorksDB select woa.ID, woa.LayerID, lyr.Layer_Name, woa.AssetID from reports.WorkOrderAssets woa INNER JOIN dbo.tbl_Layers lyr on lyr.Layer_ID = woa.LayerID WorkOrderDetails_OLd ID,System.Int32 Inspection_x0020_Cycle,System.String Inspection_x0020_Status,System.String Notes,System.String NPDES_x0020_Area_x002A_,System.String Ownership,System.String Reason,System.String 30 WorkOrderDetails_OLd VUEWorksDB Select * from reports.WorkOrderForm_SWCommercialInspection WorkOrderDetails ID,System.Int32 Air_x0020_Temperature_x0020__x0028_F_x0029_,System.Decimal Comments,System.String Correction_x002F_Elimination_x0020_Method_x0020__x0028_Select_x0020_All_x0020_That_x0020_Apply_x0029_,System.String Correction-Elimination_x0020_Method_x0020_-_x0020_Select_x0020_All_x0020_That_x0020_Apply,System.String Enforcement_x0020_-_x0020_Select_x0020_All_x0020_That_x0020_Apply,System.String Enforcement_x0020__x0028_Select_x0020_All_x0020_That_x0020_Apply_x0029_,System.String ERTS_x0020_Id,System.String G3,System.String Illicit_x0020_Connection,System.String Incident_x0020_Date,System.String Indicator_x0020_Testing_x0020_-_x0020_Select_x0020_All_x0020_That_x0020_Apply,System.String Indicator_x0020_Testing_x0020__x0028_Select_x0020_All_x0020_That_x0020_Apply_x0029_,System.String Quantity_x0020_-_x0020_Liquids,System.Decimal Quantity_x0020_-_x0020_Solids,System.Decimal Rainfall_x0020__x0028_last_x0020_24_x0020_hours_x0029_,System.Decimal Rainfall_x0020__x0028_last_x0020_48_x0020_hours_x0029_,System.Decimal Rainfall_x0020_In_x0020_Forecast,System.String Reporting_x0020_Source,System.String Source_x0020_Tracing_x0020_Methods_x0020_-_x0020_Select_x0020_All_x0020_That_x0020_Apply,System.String Source_x0020_Tracing_x0020_Methods_x0020__x0028_Select_x0020_All_x0020_That_x0020_Apply_x0029_,System.String Spill_x0020_Frequency,System.String Spill_x0020_Material,System.String Spill_x0020_Material_x0020_-_x0020_Select_x0020_All_x0020_That_x0020_Apply,System.String Spill_x0020_Material_x0020__x0028_Select_x0020_All_x0020_That_x0020_Apply_x0029_,System.String Spill_x0020_Material_x0020_Comments,System.String Spill_x0020_Source,System.String Spill_x0020_Source_x0020_-_x0020_Select_x0020_All_x0020_That_x0020_Apply,System.String Spill_x0020_Source_x0020__x0028_Select_x0020_All_x0020_That_x0020_Apply_x0029_,System.String Spill_x0020_Source_x0020_Comments,System.String 30 WorkOrderDetails VUEWorksDB select * from reports.WorkOrderForm_SDSpillResponse Documents_WorkOrders_Relation ID Documents_WorkOrders_Relation Documents_WorkOrders_Relation ID WorkOrders_Documents_Relation ID WorkOrders_Documents_Relation WorkOrders_Documents_Relation ID wo_woa_rel ID wo_woa_rel wo_woa_rel ID woa_wo_rel ID woa_wo_rel woa_wo_rel ID woa_GIS_Rel Layer_Name AssetID woa_GIS_Rel woa_GIS_Rel Layer_Name AssetID GIS_woa_Rel AssetID Layer_Name GIS_woa_Rel GIS_woa_Rel AssetID Layer_Name wo_wod_Rel ID wo_wod_Rel wo_wod_Rel ID ,UserID,UserID,,System.Int32,_x0032_50,False,False,False,True ,UserName,UserName,,System.String,VUEWorks,False,False,False,True ,ReportID,ReportID,,System.Int32,_x0032_70,False,False,False,True ,ProviderType,ProviderType,,System.Int32,_x0034_,False,False,False,True ,ReportName,ReportName,,System.String,NPDES_x0020_Work_x0020_Orders_x0020_Commercial_x0020_Inspection,False,False,False,True ,CategoryName,CategoryName,,System.String,,False,False,False,True ,LayerID,LayerID,,System.Int32,_x002D_1,False,False,False,True ,UseSelection,UseSelection,,System.String,False,False,False,False,True ,rptInspectionArea,Select_x0020_an_x0020_Inspection_x0020_Area:,,Stimulsoft.Report.StringList,,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_ItemsInitializationType_x003E_Columns_x003C__x002F_ItemsInitializationType_x003E__x003C_KeysColumn_x003E_Unique_InspectionAreas.InspectionArea_x003C__x002F_KeysColumn_x003E__x003C_ValuesColumn_x003E_Unique_InspectionAreas.InspectionArea_x003C__x002F_ValuesColumn_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_0_x0022__x0020__x002F__x003E__x003C_Values_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C_ValuesBinding_x0020_isList_x003D__x0022_true_x0022__x0020_count_x003D__x0022_0_x0022__x0020__x002F__x003E__x003C__x002F_StiSerializer_x003E_ ,rptStartDate,Select_x0020_a_x0020_Report_x0020_Start_x0020_Date:,,System.DateTime,Today,False,True,True,True ,rptEndDate,Select_x0020_a_x0020_Report_x0020_End_x0020_Date:,,System.DateTime,Today,False,True,True,True EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.72,1.1 Transparent 0,0,7.7,0.3 Arial,16,Bold Center 0,0,0,0 Text39 NPDES Work Orders Black Expression Center Transparent 0,0.3,7.7,0.2 Arial,12 Center 0,0,0,0 Text44 Spill Response Black Expression Center Transparent 0,0.8,7.7,0.2 Arial,10 Center 0,0,0,0 Text41 {rptStartDate.ToString("MMMM dd, yyyy")} - {rptEndDate.ToString("MMMM dd, yyyy")} Black Expression Transparent 0,0.5,7.7,0.3 Arial,10 Center 0,0,0,0 Text57 Areas: {rptInspectionArea.ToQueryString()} Black Expression Center ReportTitleBand1 Transparent True 0,1.7,7.72,0.3 Transparent True 0,0.1,7.7,0.2 Arial,9,Bold| Underline Center 0,0,0,0 Text43 {Length(WorkOrders.woa_wo_rel.GIS_woa_Rel.InspectionArea) == 0 ? 'NA' : 'OK')} Black Expression {WorkOrders.woa_wo_rel.GIS_woa_Rel.InspectionArea} True GroupHeaderBand1 None;[230:230:230];2;Solid;False;4;Black Transparent True 0,2.4,7.72,2.5 All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,0.2,1.4,0.2 Arial,10 0,0,0,0 Text4 ID Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,0.6,1.4,0.2 Arial,10 0,0,0,0 Text2 Logged Date Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,0.4,1.4,0.2 Arial,10 0,0,0,0 Text6 Logged By Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,0.8,1.4,0.2 Arial,10 0,0,0,0 Text8 Service Request ID Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,1,1.4,0.2 Arial,10 0,0,0,0 Text10 Type Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,1.2,1.4,0.2 Arial,10 0,0,0,0 Text12 Department Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,1.4,1.4,0.2 Arial,10 0,0,0,0 Text14 Group Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,1.6,1.4,0.2 Arial,10 0,0,0,0 Text16 Assigned To Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,1.8,1.4,0.2 Arial,10 0,0,0,0 Text18 Activity Description Black Expression All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,2,1.4,0.2 Arial,10 0,0,0,0 Text20 Location Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 0,2.2,1.4,0.2 Arial,10 0,0,0,0 Text22 Description Black All;Black;1;Solid;False;4;Black Transparent True 5.8,0.2,1.9,0.2 Arial,10 0,0,0,0 Text23 {WorkOrders.StatusName} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,0.2,1,0.2 Arial,10 0,0,0,0 Text24 Status Black Expression All;Black;1;Solid;False;4;Black Transparent True 5.8,0.4,1.9,0.2 Arial,10 0,0,0,0 Text25 {WorkOrders.Priority} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,0.4,1,0.2 Arial,10 0,0,0,0 Text26 Priority Black All;Black;1;Solid;False;4;Black Transparent True 5.8,0.6,1.9,0.2 Arial,10 0,0,0,0 Text27 {WorkOrders.BeginDate} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,0.6,1,0.2 Arial,10 0,0,0,0 Text28 Begin Date Black Expression All;Black;1;Solid;False;4;Black Transparent True 5.8,0.8,1.9,0.2 Arial,10 0,0,0,0 Text29 {WorkOrders.EndDate} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,0.8,1,0.2 Arial,10 0,0,0,0 Text30 End Date Black Expression All;Black;1;Solid;False;4;Black Transparent True 5.8,1,1.9,0.2 Arial,10 0,0,0,0 Text31 {WorkOrders.ProjectGroup} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,1,1,0.2 Arial,10 0,0,0,0 Text32 Project Group Black Expression All;Black;1;Solid;False;4;Black Transparent True 5.8,1.2,1.9,0.2 Arial,10 0,0,0,0 Text33 {WorkOrders.ProjectTitle} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,1.2,1,0.2 Arial,10 0,0,0,0 Text34 Project Title Black Expression All;Black;1;Solid;False;4;Black Transparent True 5.8,1.4,1.9,0.2 Arial,10 0,0,0,0 Text35 {WorkOrders.ClosedByName} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,1.4,1,0.2 Arial,10 0,0,0,0 Text36 Closed By Black Expression All;Black;1;Solid;False;4;Black Transparent True 5.8,1.6,1.9,0.2 Arial,10 0,0,0,0 Text37 {WorkOrders.ClosureDate} Black All;[230:230:230];2;Solid;False;4;Black AntiqueWhite True 4.8,1.6,1,0.2 Arial,10 0,0,0,0 Text38 Date Closed Black Expression All;Black;1;Solid;False;4;Black Transparent True 1.4,0.2,3.4,0.2 Arial,10 0,0,0,0 Text3 {WorkOrders.WorkOrderID} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,0.6,3.4,0.2 Arial,10 0,0,0,0 Text1 {WorkOrders.LoggedDate} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,0.4,3.4,0.2 Arial,10 0,0,0,0 Text5 {WorkOrders.LoggedByName} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,0.8,3.4,0.2 Arial,10 0,0,0,0 Text7 {WorkOrders.ParentServiceRequestID} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,1,3.4,0.2 Arial,10 0,0,0,0 Text9 {WorkOrders.TypeName} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,1.2,3.4,0.2 Arial,10 0,0,0,0 Text11 {WorkOrders.DepartmentName} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,1.4,3.4,0.2 Arial,10 0,0,0,0 Text13 {WorkOrders.GroupName} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,1.6,3.4,0.2 Arial,10 0,0,0,0 Text15 {WorkOrders.AssignedToName} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,1.8,6.3,0.2 Arial,10 0,0,0,0 Text17 {WorkOrders.ActivityDescription} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,2,6.3,0.2 Arial,10 0,0,0,0 Text19 {WorkOrders.Location} Black All;Black;1;Solid;False;4;Black Transparent True 1.4,2.2,6.3,0.2 Arial,10 0,0,0,0 Text21 {WorkOrders.Description} Black WorkOrders _x007B_WorkOrders.LoggedDate_x0020__x003E__x003D__x0020_rptStartDate.AddDays_x0028_-1_x0029__x0020__x0026__x0026__x0020_WorkOrders.LoggedDate_x0020__x003C__x003D__x0020_rptEndDate.AddDays_x0028_1_x0029__x007D_ _x007B_rptInspectionArea.Contains_x0028_WorkOrders.woa_wo_rel.GIS_woa_Rel.InspectionArea_x0029__x007D_ DataBand1 True ASC woa_wo_rel GIS_woa_Rel InspectionArea ASC LoggedDate WhiteSmoke True 0,5.3,7.72,4.8 AdvBlack;1;None;Black;1;Solid;Black;1;None;Black;1;None;False;4;Black Transparent True 0,0,7.7,0.2 Arial,12 Center 0,0,0,0 Text56 Section 1 - Weather Details Black Expression Transparent True 1.3,0.2,0.3,0.2 Arial,10 0,0,0,0 Text45 {WorkOrderDetails.Rainfall_In_Forecast} Black Transparent True 0,0.2,1.3,0.2 Arial,10,Bold 0,0,0,0 Text46 Rainfall In Forecast: Black Expression Transparent True 3.2,0.2,0.4,0.2 Arial,10 0,0,0,0 Text47 {WorkOrderDetails.Air_Temperature__F_} Black 1 1 False Transparent True 1.8,0.2,1.4,0.2 Arial,10,Bold 0,0,0,0 Text48 Air Temperature (F): Black Expression Transparent True 5.3,0.2,0.3,0.2 Arial,10 0,0,0,0 Text49 {WorkOrderDetails.Rainfall__last_24_hours_} (in.) Black , 1 Expression Transparent True 3.8,0.2,1.5,0.2 Arial,10,Bold 0,0,0,0 Text50 Rainfall (last 24 hours): Black Expression Transparent True 7.3,0.2,0.3,0.2 Arial,10 0,0,0,0 Text51 {WorkOrderDetails.Rainfall__last_48_hours_} (in.) Black , 1 Expression Transparent True 5.8,0.2,1.5,0.2 Arial,10,Bold 0,0,0,0 Text52 Rainfall (last 48 hours): Black Expression AdvBlack;1;None;Black;1;Solid;Black;1;None;Black;1;None;False;4;Black Transparent True 0,0.5,7.7,0.2 Arial,12 e1539303cb33262135f3a3b514847f53 Center 0,0,0,0 Text58 Section 2 - Reporting Black Expression Transparent True 0.3,0.7,0.3,0.2 Arial,10 0,0,0,0 Text54 {WorkOrderDetails.G3} Black Transparent True 0,0.7,0.3,0.2 Arial,10,Bold 0,0,0,0 Text59 G3: Black Expression Transparent True 1.5,0.7,1,0.2 Arial,10 0,0,0,0 Text60 {WorkOrderDetails.ERTS_Id} Black Transparent True 0.9,0.7,0.6,0.2 Arial,10,Bold 0,0,0,0 Text61 ERTS Id: Black Expression Transparent True 3.8,0.7,0.8,0.2 Arial,10 0,0,0,0 Text62 {WorkOrderDetails.Incident_Date} Black Transparent True 2.8,0.7,1,0.2 Arial,10,Bold 0,0,0,0 Text63 Incident Date: Black Expression Transparent True 6.2,0.7,1,0.2 Arial,10 0,0,0,0 Text64 {WorkOrderDetails.Reporting_Source} Black Transparent True 5,0.7,1.2,0.2 Arial,10,Bold 0,0,0,0 Text65 Reporting Source: Black Expression AdvBlack;1;None;Black;1;Solid;Black;1;None;Black;1;None;False;4;Black Transparent True 0,1,7.7,0.2 Arial,12 84bb47c0d0cae9830eaaa3b72b9b68c2 Center 0,0,0,0 Text67 Section 3 - Spill Details Black Expression Transparent True 0.1,1.5,3.4,0.2 Arial,10 0,0,0,0 Text66 {WorkOrderDetails.Spill_Frequency} Black Transparent True 0.1,1.3,1.1,0.2 Arial,10,Bold 0,0,0,0 Text68 Spill Frequency: Black Expression Transparent True 4.2,1.5,3.4,0.2 Arial,10 0,0,0,0 Text69 {WorkOrderDetails.Illicit_Connection} Black Transparent True 4.2,1.3,1.2,0.2 Arial,10,Bold 0,0,0,0 Text70 Illicit Connection: Black Expression Transparent True 0.1,2,3.4,0.2 Arial,10 0,0,0,0 Text71 {WorkOrderDetails.Source_Tracing_Methods___Select_All_That_Apply} Black Transparent True 0.1,1.8,3.4,0.2 Arial,10,Bold 0,0,0,0 Text72 Source Tracing Methods: Black Expression Transparent True 4.2,2,3.4,0.2 Arial,10 0,0,0,0 Text73 {WorkOrderDetails.Indicator_Testing___Select_All_That_Apply} Black Transparent True 4.2,1.8,3.4,0.2 Arial,10,Bold 0,0,0,0 Text74 Indicator Testing: Black Expression Transparent True 0.1,2.5,3.4,0.2 Arial,10 0,0,0,0 Text75 {WorkOrderDetails.Spill_Source___Select_All_That_Apply} Black Transparent True 0.1,2.3,3.4,0.2 Arial,10,Bold 0,0,0,0 Text76 Spill Source: Black Expression Transparent True 4.2,2.5,3.4,0.2 Arial,10 0,0,0,0 Text77 {WorkOrderDetails.Spill_Material___Select_All_That_Apply} Black Transparent True 4.2,2.3,3.4,0.2 Arial,10,Bold 0,0,0,0 Text78 Spill Material: Black Expression Transparent True True 0.1,3,3.4,0.2 Arial,10 0,0,0,0 Text79 {WorkOrderDetails.Spill_Source_Comments} Black ,,,,WordWrap=True,A=0 Transparent True 0.1,2.8,1.6,0.2 Arial,10,Bold 0,0,0,0 Text80 Spill Source Comments: Black Expression Transparent True True 4.2,3,3.4,0.2 Arial,10 0,0,0,0 Text81 {WorkOrderDetails.Spill_Material_Comments} Black ,,,,WordWrap=True,A=0 Transparent True 4.2,2.8,1.7,0.2 Arial,10,Bold 0,0,0,0 Text82 Spill Material Comments: Black Expression Transparent True 0.1,3.5,1.5,0.2 Arial,10 0,0,0,0 Text83 {WorkOrderDetails.Quantity___Liquids} Gallons Black Expression Transparent True 0.1,3.3,1.2,0.2 Arial,10,Bold 0,0,0,0 Text84 Quantity - Liquids: Black Expression Transparent True 2.1,3.5,1.5,0.2 Arial,10 cea07c079117fd48d8c9a3c925b5ff16 0,0,0,0 Text85 {WorkOrderDetails.Quantity___Liquids} Ounces Black Expression Transparent True 2.1,3.3,1.2,0.2 Arial,10,Bold 6e86e8127dbb0f3122eca3c925b58a6a 0,0,0,0 Text53 Quantity - Liquids: Black Expression Transparent True 4.1,3.5,1.5,0.2 Arial,10 0,0,0,0 Text55 {WorkOrderDetails.Quantity___Solids} Lbs. Black Expression Transparent True 4.1,3.3,1.2,0.2 Arial,10,Bold 0,0,0,0 Text86 Quantity - Solids: Black Expression Transparent True 6.1,3.5,1.5,0.2 Arial,10 95ba0c454ba86c440196a3dad8e78f61 0,0,0,0 Text89 {WorkOrderDetails.Quantity___Solids} Cu. Yds Black Expression Transparent True 6.1,3.3,1.2,0.2 Arial,10,Bold c1f2de99f24f03273a50a3dad8e75c5a 0,0,0,0 Text87 Quantity - Solids: Black Expression AdvBlack;1;None;Black;1;Solid;Black;1;None;Black;1;None;False;4;Black Transparent True 0,3.8,7.7,0.2 Arial,12 ed388a418c85145158eba3dcbe6dc8ff Center 0,0,0,0 Text90 Section 4 - Correction & Enforcement Black Expression Transparent True True 0.1,4.2,3.4,0.2 Arial,10 0,0,0,0 Text88 {WorkOrderDetails.Correction_Elimination_Method___Select_All_That_Apply} Black ,,,,WordWrap=True,A=0 Transparent True 0.1,4,2.1,0.2 Arial,10,Bold 0,0,0,0 Text91 Correction-Elimination Method: Black Expression Transparent True True 4.2,4.2,3.5,0.2 Arial,10 0,0,0,0 Text92 {WorkOrderDetails.Enforcement___Select_All_That_Apply} Black ,,,,WordWrap=True,A=0 Transparent True 4.2,4,3.5,0.2 Arial,10,Bold 0,0,0,0 Text93 Enforcement: Black Expression Transparent True True 0.9,4.5,6.8,0.2 Arial,10 0,0,0,0 Text94 {WorkOrderDetails.Comments} Black ,,,,WordWrap=True,A=0 Transparent True 0.1,4.5,0.8,0.2 Arial,10,Bold 0,0,0,0 Text95 Comments: Black Expression wo_wod_Rel WorkOrderDetails KeepFirstDetailTogether DataBand4 Transparent True 0,10.5,7.72,2 2 True Transparent True 0.1,0.1,3.7,1.9 var imageComp = sender as StiImage; var image = StiImageFromURL.LoadBitmap(WorkOrderDocuments.Url, null); var resolution = 96; var scale = Math.Min(imageComp.Width * resolution / image.Width, imageComp.Height * resolution / image.Height); var scaledImage = new Bitmap(image, (int)(image.Width * scale), (int)(image.Height * scale)); e.Value = scaledImage; 0,0,0,0 Image1 Documents_WorkOrders_Relation WorkOrderDocuments _x007B_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_BMP_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_JPG_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_JPEG_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_TIF_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_GIF_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_PNG_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_ICO_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_EMF_x0022__x0029__x0020__x007C__x007C_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_WMF_x0022__x0029__x007D_ DataBand2 AdvBlack;1;None;Black;1;Solid;Black;1;None;Black;1;None;False;4;Black WhiteSmoke 0,12.9,7.72,0.3 Transparent 0,0.1,1.9,0.2 Arial,10,Underline 0,0,0,0 Text42 Linked Documents Black Expression HeaderBand1 WhiteSmoke 0,13.6,7.72,0.2 Transparent True 0,0,7.7,0.2 Arial,10,Underline {WorkOrderDocuments.Url} 0,0,0,0 Text40 {WorkOrderDocuments.Document} MediumBlue Documents_WorkOrders_Relation WorkOrderDocuments _x007B__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_BMP_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_JPG_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_JPEG_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_TIF_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_GIF_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_PNG_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_ICO_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_EMF_x0022__x0029__x0020__x0026__x0026__x000D__x0021_ToUpperCase_x0028_WorkOrderDocuments.Url_x0029_.EndsWith_x0028__x0022_WMF_x0022__x0029__x007D_ DataBand3 Transparent 0,14.2,7.72,0.1 0,0.1,7.7,0.01 Black Black HorizontalLinePrimitive1 Black FooterBand1 322ffae52591473fb22e3b293e60c8a3 True 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 NPDES Work Orders Commercial Inspection VUEWorks 8/22/2017 10:37:17 AM 6/7/2017 1:25:20 PM c6db616bae152e190d8f0a207d2f6d43 NPDES Work Orders Commercial Inspection Inches 2017.1.6.0 True CSharp