Skip to main content

Search

Welcome to PMG Support

Reports

PMG Support
  • Updated

The Reports dropdown is located on the Main Menu. There are two report types offered here: Standard Reports and Advanced Reports.

Standard Reports

The Standard Reports interface (Standard Reports) provides eight report types. This interface will not be available to guest users, so the user must log in and have the appropriate permissions to access these reports. To run one of these reports, follow these steps:

  1. Select a Standard Report in the "Select the Report" list.
  2. Fill the required filter fields.
    • "Centerline Miles Report" required filters - Route Type, Location Type
    • "Lanes Miles Report" required filters - Route Type, Location Type
    • "Memorial Highways/Bridges Report" required filters - County or Route Type
    • "Total Miles by County by Urban Area" required filters - None
    • "Total Miles by Functional Class by County" required filters - None
    • "Total Miles by Functional Class Statewide" required filters - None
    • "User Permissions" required fields - None
  3. Fill the optional filter fields if desired.
  4. Select an output option: Open as PDF or Open in Excel.

Advanced Reports

The Advanced Reports interface (Advanced_Reports.png) provides a set of tools to create user defined queries and reports. The Advanced Reports interface is divided into 7 sections:

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

The Advanced Reports 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 columns to the Selected Output Columns list at the bottom of the form. Each button produces a certain set of columns:

  • Bridges: Bridge Status, Posting Status, Bridge Inspection Date, Bridge Total Length, Bridge Year Built, BIN, Bridge Location, Bridge Latitude, and Bridge Longitude.
  • Projects: Project Status, Project ID, Contract ID, Project Description, Project Type, Project Manager, and Contractor.
  • Routes: County, Route ID, From Measure, and To Measure.
Category Column Dropdown Query Builder Select the Business data type.
Item Column Dropdown Query Builder Select an Item refined by the Category selection.
Logical Column Dropdown Query Builder Input a query operator (equal, not equal, etc.).
Value Column Dropdown Query Builder Select a valid value 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 row.
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 columns.
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.

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 a color for the mapped results.
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. 

On the report table, there will also be summary links. When selected, these links display the Detail Window on the map; the report will need to be minimized to view this window. Below is an example of the Detail Window for Project ID 100067934. As expected, this window only shows fields related to the "Projects" dropdown. If a summary link was selected in the BIN column instead (from the example above), the Detail Window would show fields related to the "Bridges" dropdown.

Advanced Reports Workflow

The Advanced Reports interface allows the user to build a report based on inputted criteria and column types. To generate an Advanced Report, the user must follow these steps:

  1. Add a Query Title in the textbox.
  2. Fill the search criteria table (Category, Item, Logical, and Value).
  3. Add another criteria row if desired by clicking the plus sign on the next available table row.
  4. Use the join and parentheses table fields to group criteria rows or create conditional queries.
  5. Use the output columns buttons (Bridges, Projects, or Routes) to add a preset grouping of columns to the report if desired. 
  6. Alternatively, use the plus button in the Available Columns box to find column types to include in the report; the user can then click the column names and click the "Add" button to place them in the Selected Output Columns box.
  7. Click the "Run Query" button to view the created report in a pop-up window.
  8. Click the "Save Query" button to save the built report; the user will have the ability to edit the Query Name, check/uncheck "Others Can View," and click save.

Users can also load a previous query into the interface to generate a report. To do this, the user can click the "Load Query" button, select the query name, and click "Load Selected Query." This will load the query information into the Advanced Reports interface, allowing the user to run the report. The user can also add/edit the displayed information for the loaded query before running the report.

Comments

0 comments

Please sign in to leave a comment.