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: 1184 Author: britchson Date: 4:07:08 PM, Thursday, October 18, 2012 Message: Suppressed detail section in preparation for sending to Jason. This is a possible final draft. ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1183 Author: britchson Date: 10:26:13 AM, Thursday, October 18, 2012 Message: changed parameter order in an attempt to get the filter parameter working ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1182 Author: britchson Date: 10:09:28 AM, Thursday, October 18, 2012 Message: removed the previous record from the queries and added it into the report calculations. ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1181 Author: britchson Date: 3:48:43 PM, Wednesday, October 17, 2012 Message: optimized the vw_rs_avl view by stealing its code and removing unneeded information ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1180 Author: britchson Date: 3:05:46 PM, Wednesday, October 17, 2012 Message: fixed some errors in the query leading to erroneous data. ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1179 Author: britchson Date: 2:28:10 PM, Tuesday, October 16, 2012 Message: fixed up some errors in the command query ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1178 Author: britchson Date: 1:14:10 PM, Tuesday, October 16, 2012 Message: all parameter fields added to command query ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1176 Author: britchson Date: 10:39:45 AM, Tuesday, October 16, 2012 Message: filters fully transitioned into sql from crystal syntax ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1172 Author: britchson Date: 10:15:31 AM, Friday, October 12, 2012 Message: Removed summary subreport from the beginning of report as it doubled the running time of the report and all the information was already available at the end. Also, restored the previous command query since some of my alterations resulted in it not working. ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1171 Author: britchson Date: 4:19:06 PM, Thursday, October 11, 2012 Message: Further reduced the complexity of the command query. ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 1170 Author: britchson Date: 3:42:11 PM, Thursday, October 11, 2012 Message: Updated formatting and changed report to use command query rather than view. ---- Modified : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Revision: 866 Author: britchson Date: 9:11:41 AM, Tuesday, November 15, 2011 Message: ---- Added : /RPT/Unprocessed_Reports Added : /RPT/Unprocessed_Reports/DMS_Report.rpt Added : /RPT/Unprocessed_Reports/DMS_Messages.rpt Added : /RPT/Unprocessed_Reports/DMS_Usage_Report.rpt Added : /RPT/Unprocessed_Reports/511_Message_and_Travel_Time_Report.rpt Added : /RPT/Unprocessed_Reports/Agency_Response_Times_Report.rpt Added : /RPT/Unprocessed_Reports/Average_Speed_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Bar_Graph_of_Total_Volume_By_Direction_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Basic_Safety_Messages.rpt Added : /RPT/Unprocessed_Reports/Beat_Coverage_Summary.rpt Added : /RPT/Unprocessed_Reports/CCTV_Report.rpt Added : /RPT/Unprocessed_Reports/Camera_Usage_Report.rpt Added : /RPT/Unprocessed_Reports/Central_Computer_System_Report.rpt Added : /RPT/Unprocessed_Reports/Daily_Chronology.rpt Added : /RPT/Unprocessed_Reports/Detector_Data_Detail.rpt Added : /RPT/Unprocessed_Reports/Detector_Speed_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Detector_Speed_Tabular.rpt Added : /RPT/Unprocessed_Reports/Detector_Volume_Bar_Graph.rpt Added : /RPT/Unprocessed_Reports/Detector_Volume_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Detector_Volume_Tabular.rpt Added : /RPT/Unprocessed_Reports/Event_Chronology.rpt Added : /RPT/Unprocessed_Reports/Event_Details.rpt Added : /RPT/Unprocessed_Reports/Event_Lane_Blockage_Report.rpt Added : /RPT/Unprocessed_Reports/Event_Level_Report.rpt Added : /RPT/Unprocessed_Reports/Event_List.rpt Added : /RPT/Unprocessed_Reports/Event_Response_Times_Report.rpt Added : /RPT/Unprocessed_Reports/Event_Summary_Report.rpt Added : /RPT/Unprocessed_Reports/FHP_Request.rpt Added : /RPT/Unprocessed_Reports/IDS_Alert_Types_Summary.rpt Added : /RPT/Unprocessed_Reports/Incident_Management_Monthly_Report.rpt Added : /RPT/Unprocessed_Reports/Notifier_Contact_Summary.rpt Added : /RPT/Unprocessed_Reports/Probe_Vehicle_Data_Messages.rpt Added : /RPT/Unprocessed_Reports/Ramp_Meters_Report.rpt Added : /RPT/Unprocessed_Reports/Regional_Floodgate_Messages.rpt Modified : /RPT/DetectorReliability/DetectorCalibration.rpt Added : /RPT/Unprocessed_Reports/AVL_Report.rpt Added : /RPT/Unprocessed_Reports/Annual_Incident_Duration_Summary.rpt Added : /RPT/Unprocessed_Reports/DMS_FilteredMessages_for_Safety.rpt Added : /RPT/Unprocessed_Reports/FAT2_Report_Generic_Template.rpt Added : /RPT/Unprocessed_Reports/FAT2_Report_Parameter_List.xls Added : /RPT/Unprocessed_Reports/FDOT_Logo.jpg Added : /RPT/Unprocessed_Reports/Incident_Duration_Flagged_Events.rpt Added : /RPT/Unprocessed_Reports/Incident_Duration_Full_Detail.rpt Added : /RPT/Unprocessed_Reports/Monthly_Performance_Measures_Report.rpt Added : /RPT/Unprocessed_Reports/QA_Report.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Flagged_Events.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Full_Detail.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Performance_Report.rpt Added : /RPT/Unprocessed_Reports/Quarterly_Incident_Duration_Summary.rpt Added : /RPT/Unprocessed_Reports/RSE_Device_Status_History.rpt Added : /RPT/Unprocessed_Reports/RWIS_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Details_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Activity_Summary_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Admin_Details_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Administration.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Administration_Summary.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Assists.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Cost_Savings_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Status_Report.rpt Added : /RPT/Unprocessed_Reports/Road_Ranger_Void_Activity_Report.rpt Added : /RPT/Unprocessed_Reports/SIRV_Assists.rpt Added : /RPT/Unprocessed_Reports/Safety_Barriers_Report.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Speed.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Speed_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_Line_Graph.rpt Added : /RPT/Unprocessed_Reports/Segment_Average_Travel_Time_and_Speed_Tabular.rpt Added : /RPT/Unprocessed_Reports/Segment_Travel_Time_Detail_For_Last_Hour.rpt Added : /RPT/Unprocessed_Reports/Segment_Travel_Time_and_Speed.rpt Added : /RPT/Unprocessed_Reports/Speeds_at_Detector.rpt Added : /RPT/Unprocessed_Reports/SunGuide_Logo.jpg Added : /RPT/Unprocessed_Reports/Suspect_Data_Report.rpt Added : /RPT/Unprocessed_Reports/TSS_Report.rpt Added : /RPT/Unprocessed_Reports/Total_Volume_By_Direction_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Traffic_Flow_Report.rpt Added : /RPT/Unprocessed_Reports/Traffic_Volumes_Report.rpt Added : /RPT/Unprocessed_Reports/Traveler_Advisory_Messages.rpt Added : /RPT/Unprocessed_Reports/Typical_Volumes_at_Detector.rpt Added : /RPT/Unprocessed_Reports/Variable_Speed_Limits_Posted.rpt Added : /RPT/Unprocessed_Reports/Vehicle_GPS_Location_Report.rpt Added : /RPT/Unprocessed_Reports/Vehicle_Location_Report.rpt Added : /RPT/Unprocessed_Reports/Video_Switch_Report.rpt Added : /RPT/Unprocessed_Reports/VisioPaD_Summary_2009.11.02.rpt Added : /RPT/Unprocessed_Reports/Weekly_Performance_Measures_Report.rpt Added : /RPT/Unprocessed_Reports/Yearly_Performance_Measures_Report.rpt