Like the Project Comparison in the Simple report tab, the Standard Project Comparison report allows users to compare the differences in projects between two STIPs. The report includes summary information about each project with differences highlighted. The major differences in this version are that it will include a Funding Outlay table and more advanced filters for the report.

Filters 

The user has the STIP, Revision, STIP to Compare, and Revision (STIP to Compare) filter options that they can fill before running the report, just like in the Simple version. However, the Standard version provides the "Category" dropdown filtering option which presents two choices to the user: Project Details and Project Location. Either selection here will prompt additional attributes to become available to the user in other dropdown boxes. The attributes in the items/value columns are described below.

After selecting the item, the user can choose a Logical operator from the dropdown box and select a Value. The type of input available in the Value field depends on the specific item that is selected (shown above). The user may choose to search within string records here, using Logical operators such as “Begins With,” “Ends With,” or “Contains.”

If the user wishes to add additional search options or constraints, they may click the "Add Criteria" Button (Plus ) on the next empty row in the criteria table. If the user wishes to remove a criterion, they may click the "Remove Criteria" Button (Minus ). If the user wishes to remove all criteria, they may use the "Clear Criteria" button located at the bottom left of the table.

When the user has added more than one criterion, they may select a Boolean (AND NOT, OR NOT), and/or enter parenthesis, to combine the criteria together. These can be combined, nested, and chained to create distinct searches.

The advanced filtering options offered in the Standard tab allow more user capabilities. However, the user can opt to not add any advanced filters, causing the report to return all projects in the selected STIPs/Revisions.

Report Format

The Project Comparison Report will be grouped and sorted by Division, County, Mode, and STIP ID. Each project will have a Project Header row with the project's STIP ID and a sub-header row with the name of the STIP and the STIP Revision (if applicable) being used for comparison. Each version of the STIP project will be shown below the sub-header with the changes in the versions highlighted in yellow.