The Advanced Reports interface allows the user to build and execute ad-hoc queries against the traffic database. From this interface, users can define criteria and select output columns for the ad-hoc report.
Define the Report
The user can define the report using many fields and elements on the Advanced Reports interface. To give the report a name, the user can enter a value in the "Report Title" textbox.
To this field's immediate right, there are three other tools. The user can define the year for the data through the "Traffic Year" list; this list is multi-selectable. The "Identify Columns" button can be used to assign a predetermined column set to the report; in this case, the button adds the CCS Number, County, Station, Route, Begin Milepoint, and End Milepoint columns. The final elements in this section, the radio buttons, allow the user to choose which stations will be reported on-- Active Stations, Inactive Stations, or All.
Below these fields is the Query Builder which allows the user to specify a combination of available data elements for creating a custom query and report. When the user first starts entering information into the Query Builder, only the parentheses and "Category" fields will be editable. The other fields-- Item, Logical, Value, etc.-- will become available as information is added.
Then, the user can navigate to the columns section. If the user wishes to manually add columns instead of adding the predetermined set (Identity Columns button), they can utilize the boxes and button controls here. To add a column to the report, the user can locate the desired column in the "Available Columns" box. This box will show the column categories which can be expanded through the "+" symbol. Once expanded, a column type can be clicked; then, the "Add >" button can be used to place it in the "Selected Columns" box. All controls here are described in the table below.
| Control | Used to... |
| Plus and Minus Buttons | Expand and Collapse categories. |
| Add > Button | Add fields from "Available Columns" to "Selected Columns" list by clicking the column name, then this button. |
| < Remove Button | Remove a field from "Selected Columns" by clicking the column name, then this button. |
| << Remove All Button | Remove all fields from "Selected Columns." |
| Sort Order Up/Down Arrows | Indicate that the currently selected item is in ascending (up arrow) or descending (down arrow) sort mode. This arrow is located in the actual table, and its current direction can be changed by clicking the arrow. |
| Show Previous Year Checkbox | Allow the previous year data to be shown. |
| Reorder the Report Column Sequence Arrows |
Change the order of the columns, which will be reflected on the report. It follows this logic:
|
Run the Report
To run the report, the user must specify at least one row of criteria in the Query Builder and specify at least one column. The "Run Report" button is located below the Query Builder. If the user wishes to reset the criteria, that button control is located below the Query Builder as well.
There are two more controls at the bottom of the interface. These are described in the table below.
| Control | Used To... |
| Load Query | Reload a previously saved query to run from a pickable, pop-up list. Saved queries can also be deleted from the Load Query interface. |
| Save Query |
Open a pop-up form used to save the query to the database. To save the query, the user must specify the Query Name and click "Save." The "Others Can View" checkbox is optional and specifies if the query will be available to all users or just the user who created the query. |
Results
The results of an executed query are displayed in a separate pop-up window. The Report Name, Search Criteria, Run Date, and Number of Records will be displayed at the top of the report. There are also some controls offered at the top of the output report:
| Control | Used To... |
| Map Symbol Color Dropdown | Select the color for displaying the report results on a map. |
| Map Traffic Segments Link | Toggle to the Map Frame and highlight the traffic segments in the selected map symbol color. |
| Map Counter Locations Link | Toggle to the Map Frame and highlight the counter locations in the selected map symbol color. |
| Print Link | Open the Windows Print Dialog to customize and print the results. |
| View in Excel Link | Open the file in Excel or save the results locally in Excel format. |
| View in Shapefile Link | Download the results in a Shapefile format (zip file). |
NOTE: If too many traffic records result from the query, the results will automatically be returned in a spreadsheet instead of being displayed in the results window.
Comments
0 comments
Please sign in to leave a comment.