Advanced Reports Controls

This is a tool that is located under the Reports dropdown on the Main Menu.

Function

The Advanced Reports interface () provides a set of tools to create user defined queries and reports.

Sections

The Advanced Reports interface is divided into 7 sections:

Query Title -- Specifies a name for a set of search criteria for future recall.
Output Column Data Type Controls -- Specifies a preset group of output columns.
Query Builder -- Specifies a combination of available data elements for creating a custom query and report.
Available Output Columns -- Specifies the available data items that can be included in reports.
Output Field Controls -- Customizes the report output through the use of movement-based button controls.
Selected Output Options -- Specifies the data columns to be included in the output report.
Button Controls -- Removes, saves, or stores the created query.

NM EGIS Viewer Advanced Reports.png

Controls

The interface hosts these controls:

Control	Section	Used To...
Query Title Box	Query Title	Display a name that characterizes the search elements; this name will be retained when the Save Query button is selected.
Bridges, Projects, and Routes Buttons	Output Column Data Type Controls	Automatically add a set of data attributes to the Selected Output Columns list at the bottom of the form.
Category Column Dropdown	Query Builder	Select the Business data types.
Item Column Dropdown	Query Builder	Select an Item refined by the Category selection.
Logical Column Dropdown	Query Builder	Input query operators (equal, not equal, etc.).
Value Column Dropdown	Query Builder	Select valid values for the data column or type in where set values do not exist (if applicable).
Add/Remove Item (+ and X) Buttons	Query Builder	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 interface requires at least one search criteria.
Join Dropdown	Query Builder	Group or create conditional queries; used in conjunction with the parentheses controls.
Parentheses Textboxes	Query Builder	Group or create conditional queries; used in conjunction with the join control.
Plus and Minus Buttons	Available Output Columns	Expand and collapse the lists of available data items.
Add (>) Button	Output Field Controls	Add fields from the Available Output Columns list to the Selected Output Columns list.
Remove (<) Button	Output Field Controls	Remove a field from the Selected Output Columns list.
Remove All (<<) Button	Output Field Controls	Remove all fields from the Selected Output Columns list.
Reorder the Report Column Sequence: Double Up/Down Arrows	Selected Output Options	Move a selected item to the top or bottom of the list.
Reorder the Report Column Sequence: Single Up/Down Arrow	Selected Output Options	Move a selected item up or down one row in the list.
Reset Criteria Button	Button Controls	Clear all criteria and reset the form.
Run Query Button	Button Controls	Execute the query based on the selected criteria.
Load Query Button	Button Controls	Reload a previously saved query from a pop-up list.
Save Query Button	Button Controls	Save the query to the database from a pop-up window.

Preset Columns

The Projects, Bridges, and Routes buttons automatically add a set of data attributes to the Selected Output Columns list at the bottom of the form. Each button produces a certain set of columns. These sets are:

Bridges	Projects	Routes
BIN	Control Number	County
Bridge Condition	Project Status	Route ID
Posting Status	Project Description	From Measure
Inspection Date	Primary Project Type	To Measure
Year Built	Project Manager
Bridge Width	Contractor
Bridge Length

Output Reports

The results of an executed query are displayed in a pop-up report. 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 Link	Toggle to the Map Frame and highlight the records in the selected map symbol color.
Export to Shapefile Link	Save the results locally in Shapefile format.
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.

Workflow

To view the workflow for the Advanced Reports interface, click here.

Search

Welcome to PMG Support