This is a tool that is located on the Reports section of the Reports tab.
Function
The Advanced Reports interface () provides a set of tools to create user defined queries and reports.
Section
The Advanced Reports interface consists of 7 components: Report Title, Data Dropdown, Precision and Identity Column Controls, Query Builder, Available Output Columns, Output Field Controls, and Selected Output Columns.
(1) Report Title
The Report Title section allows users to specify a name for a set of search criteria for future recall. The user can enter an appropriate name that characterizes the selected search elements in the provided textbox.
(2) Data Dropdown
This section hosts the Data Table dropdown control.
(3) Precision and Identity Column Controls
There are two controls in this section. These two controls apply general settings to the output report.
| Control | Used To... |
| Decimal Places Textbox | Set the maximum number of decimal places displayed for numeric values in the output report. Data with higher precision will be rounded to this specified decimal place. |
| Identity Columns Button | Automatically add a preconfigured set of columns to the Selected Output Columns list at the bottom of the form. Parish, Route ID, From Measure, and To Measure are added when the Identity Columns button is pressed. |
(4) Query Builder
The Query Builder section is used to specify a combination of available data elements for creating a custom query and report. Below are some of the controls that aid this process.
| Control | Used To... |
| Category Dropdown | Select the Business data types. |
| Item Dropdown |
Select an Item refined by the Category selection. |
| Logical Dropdown | Provide query operators (equal, not equal, greater than, less than, etc.). |
| Value Dropdown | Select valid values for the data column or type in where set values do not exist. |
| Add/Item (+ and X) Buttons | Add additional criteria to the query (+) or remove criteria from a query (X). The remove option is not presented in the first row since the Advanced Report must have at least one search criteria. |
| Join Dropdown | Group or create conditional queries; used in conjunction with the parentheses controls. |
| Parentheses Textboxes | Group or create conditional queries; used in conjunction with the join control. |
| Reset Criteria Button | Clear all criteria and reset the form. |
| Enter SQL Button | Switch the query criteria window to a SQL entry window. In this mode, the Enter SQL button will change to “Enter Criteria” which can be used to switch back to the traditional query builder mode. |
| Verify SQL Button | Validate the entered SQL statement when in SQL entry mode. |
| Run Report Button | Execute the query based on the selected criteria. At least one output column must be selected to enable the Run Report button. |
(5) Available Output Columns
The Available Output Columns list is used to select the data items to include in reports. Data items are categorized by functional area and can be expanded and collapsed using the "+" and "-" buttons. This list can be used in conjunction with the Output Field Controls and Selected Output Columns to customize the output of reports.
(6) Output Field Controls
The following controls are used in conjunction with the Available Output Columns list and Selected Output Columns list to customize report outputs.
| Control | Used To... |
| Add Button | Add fields from the Available Output Columns list to the Selected Output Columns list. |
| Remove Button | Remove a field from the Selected Output Columns list. |
| Remove All Button | Remove all fields from the Selected Output Columns list. |
(7) Selected Output Columns
The Selected Output Columns box is used to specify the data columns to be included in the output report. The box will be initially blank until columns are loaded using the Identity Column Control or the Output Field Controls. There are some controls offered in this section:
| Control | Used To... |
| Sort Order Up/Down Arrows | Indicates 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. |
| Reorder the Report Column Sequence: Double Up Arrows | Move a selected item to the top of the list. |
| Reorder the Report Column Sequence: Up Arrow | Move a selected item up one row in the list. |
| Reorder the Report Column Sequence: Down Arrow | Move a selected item down one row in the list. |
| Reorder the Report Column Sequence: Double Down Arrows | Move a selected item to the bottom of the list. |
| Save Query Button | Open a popup form used to save the query to the database. |
| Load Query Button | Reload previously saved queries from a pickable list. |
Comments
0 comments
Please sign in to leave a comment.