Revision: 1569 Author: britchson Date: 11:13:55 AM, Tuesday, February 04, 2014 Message: Functional: Removed association to DMS table check sign name for VSL and filter out fixed the from date to use 1900-01-01 when no date is given filtered out null messages filtered out sunguide blank sign messages img tags now appear as curly bracketed text date range will now display if no user date range is provided Formatting: Changed version to 2.0. ---- Modified : /RPT/Oracle_SunGuide_Reports/DMS_Messages.rpt Revision: 1373 Author: britchson Date: 2:26:08 PM, Tuesday, September 17, 2013 Message: Functional Changes: changed search for newlines and newpages to be case insensitive Formatting Changes: Changed version to 1.6 ---- Modified : /RPT/Oracle_SunGuide_Reports/DMS_Messages.rpt Revision: 1300 Author: cpackard Date: 9:37:46 PM, Tuesday, June 25, 2013 Message: made compatible with SunGuide version 6.0 and increased template version to 1.5 ---- Modified : /RPT/Oracle_SunGuide_Reports/DMS_Messages.rpt Revision: 1257 Author: britchson Date: 9:54:01 AM, Monday, April 01, 2013 Message: moving oracle templates to new folder ---- Added : /RPT/Oracle_SunGuide_Reports (Copy from path: /RPT/SunGuide_Reports, Revision, 1252) Replacing : /RPT/Oracle_SunGuide_Reports/Device_Locations_Detail.rpt (Copy from path: /RPT/SunGuide_Reports/Device_Locations_Detail.rpt, Revision, 1255) Added : /RPT/SQL_Server_SunGuide_Reports Deleted : /RPT/SunGuide_Reports Revision: 1230 Author: britchson Date: 9:54:30 AM, Wednesday, February 13, 2013 Message: ---- Added : /RPT/SunGuide_Reports/DMS_FilteredMessages_for_TVT.rpt (Copy from path: /RPT/Unprocessed_Reports/DMS_FilteredMessages_for_TVT.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/DMS_Messages.rpt (Copy from path: /RPT/Unprocessed_Reports/DMS_Messages.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/DMS_Usage_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/DMS_Usage_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Event_Chronology.rpt (Copy from path: /RPT/Unprocessed_Reports/Event_Chronology.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Event_Details.rpt (Copy from path: /RPT/Unprocessed_Reports/Event_Details.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Event_Lane_Blockage_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Event_Lane_Blockage_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Event_Level_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Event_Level_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Event_List.rpt (Copy from path: /RPT/Unprocessed_Reports/Event_List.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Event_Response_Times_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Event_Response_Times_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Event_Summary_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Event_Summary_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/FHP_Request.rpt (Copy from path: /RPT/Unprocessed_Reports/FHP_Request.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/IDS_Alert_Types_Summary.rpt (Copy from path: /RPT/Unprocessed_Reports/IDS_Alert_Types_Summary.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Notifier_Contact_Summary.rpt (Copy from path: /RPT/Unprocessed_Reports/Notifier_Contact_Summary.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Probe_Vehicle_Data_Messages.rpt (Copy from path: /RPT/Unprocessed_Reports/Probe_Vehicle_Data_Messages.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/QAR_DMS_Safety_Message_Campaign.rpt (Copy from path: /RPT/Unprocessed_Reports/QAR_DMS_Safety_Message_Campaign.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/RSE_Device_Status_History.rpt (Copy from path: /RPT/Unprocessed_Reports/RSE_Device_Status_History.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/RWIS_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/RWIS_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Ramp_Meters_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Ramp_Meters_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Activity_Details_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Activity_Details_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Activity_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Activity_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Activity_Summary_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Activity_Summary_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Admin_Details_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Administration.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Administration.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Administration_Summary.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Administration_Summary.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Assists2.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Assists.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Cost_Savings_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Cost_Savings_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Duplicate_Activity_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Duplicate_Activity_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Status_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Status_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Road_Ranger_Void_Activity_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Road_Ranger_Void_Activity_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Safety_Barriers_Report.rpt (Copy from path: /RPT/Unprocessed_Reports/Safety_Barriers_Report.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Segment_Average_Speed.rpt (Copy from path: /RPT/Unprocessed_Reports/Segment_Average_Speed.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Segment_Average_Speed_Line_Graph.rpt (Copy from path: /RPT/Unprocessed_Reports/Segment_Average_Speed_Line_Graph.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Segment_Average_Travel_Time.rpt (Copy from path: /RPT/Unprocessed_Reports/Segment_Average_Travel_Time.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Segment_Average_Travel_Time_Line_Graph.rpt (Copy from path: /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_Line_Graph.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Segment_Average_Travel_Time_and_Speed_Tabular.rpt (Copy from path: /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_and_Speed_Tabular.rpt, Revision, 1229) Added : /RPT/SunGuide_Reports/Segment_Travel_Time_and_Speed.rpt (Copy from path: /RPT/Unprocessed_Reports/Segment_Travel_Time_and_Speed.rpt, Revision, 1229) Deleted : /RPT/Unprocessed_Reports/DMS_FilteredMessages_for_TVT.rpt Deleted : /RPT/Unprocessed_Reports/DMS_Messages.rpt Deleted : /RPT/Unprocessed_Reports/DMS_Usage_Report.rpt Deleted : /RPT/Unprocessed_Reports/Event_Chronology.rpt Deleted : /RPT/Unprocessed_Reports/Event_Details.rpt Deleted : /RPT/Unprocessed_Reports/Event_Lane_Blockage_Report.rpt Deleted : /RPT/Unprocessed_Reports/Event_Level_Report.rpt Deleted : /RPT/Unprocessed_Reports/Event_List.rpt Deleted : /RPT/Unprocessed_Reports/Event_Response_Times_Report.rpt Deleted : /RPT/Unprocessed_Reports/Event_Summary_Report.rpt Deleted : /RPT/Unprocessed_Reports/FHP_Request.rpt Deleted : /RPT/Unprocessed_Reports/IDS_Alert_Types_Summary.rpt Deleted : /RPT/Unprocessed_Reports/Links.rpt Deleted : /RPT/Unprocessed_Reports/Notifier_Contact_Summary.rpt Deleted : /RPT/Unprocessed_Reports/Probe_Vehicle_Data_Messages.rpt Deleted : /RPT/Unprocessed_Reports/QAR_DMS_Safety_Message_Campaign.rpt Deleted : /RPT/Unprocessed_Reports/RSE_Device_Status_History.rpt Deleted : /RPT/Unprocessed_Reports/RWIS_Report.rpt Deleted : /RPT/Unprocessed_Reports/Ramp_Meters_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Details_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Summary_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Administration.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Administration_Summary.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Assists.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Cost_Savings_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Duplicate_Activity_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Status_Report.rpt Deleted : /RPT/Unprocessed_Reports/Road_Ranger_Void_Activity_Report.rpt Deleted : /RPT/Unprocessed_Reports/Safety_Barriers_Report.rpt Deleted : /RPT/Unprocessed_Reports/Segment_Average_Speed.rpt Deleted : /RPT/Unprocessed_Reports/Segment_Average_Speed_Line_Graph.rpt Deleted : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time.rpt Deleted : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_Line_Graph.rpt Deleted : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_and_Speed_Tabular.rpt Deleted : /RPT/Unprocessed_Reports/Segment_Travel_Time_and_Speed.rpt Revision: 1099 Author: vjohnson Date: 3:26:41 PM, Tuesday, June 19, 2012 Message: adjusted headers footer divide bars page numbering and version ---- Modified : /RPT/Unprocessed_Reports/DMS_Messages.rpt Modified : /RPT/Unprocessed_Reports/DMS_Report.rpt Modified : /RPT/Unprocessed_Reports/DMS_Usage_Report.rpt Revision: 1026 Author: vjohnson Date: 3:15:49 PM, Monday, March 26, 2012 Message: applied new SunGuide report formatting ---- Modified : /RPT/Unprocessed_Reports/DMS_Messages.rpt Revision: 964 Author: britchson Date: 2:52:38 PM, Tuesday, January 31, 2012 Message: Centered District Header ID ---- Modified : /RPT/Unprocessed_Reports/DMS_Messages.rpt