To navigate the Reports window, follow the steps below:

  1. Click on the Structure Analyst application.
  2. Select GIS & Reports from the top banner.
  3. Click Reports in the drop-down menu.

New Standard Report

This section provides instructions on how to create a new standard report. For example, an ad-hoc report based on a view of Network Master.

Once you know the view that will serve as the basis of the report, follow the steps below:

  1. In the left pane of the Reports page, right-click on the My Reports folder.
  2. Click Insert Standard Report in the function menu.
  3. The system displays a dialog box where you select the table or view on which the report will be based. An example of this dialog box is shown below:
  4. Select the desired table or view from the drop down list, e.g. Network Master view for Bridge Management (RPT_BMS_NETWORK_MASTER_VW)
  5. Click OK.
  6. The dialog box closes and shows the new report in the Reports window.
  7. As needed, change the title of the new report by clicking the title to select it and then typing the new title in the right pane.
  8. In the left pane, right-click the new report and then click Setup/Show Report.

  9. The system displays the Setup Standard Report dialog box. An example of this dialog box is shown below:

    Note: The actual columns listed will differ depending on the selected table or view.
  10. In the List of Columns pane of the dialog box, select the columns that you would like to appear in the report by clicking the check box in the Show column for each one.
  11. Decide what columns will determine how to sort the records in the report. For each column to be used to sort the records, click the Order By check box in the column's record.
  12. The system places each selected column in the Order By pane below.
  13. In the Order By pane, review the columns. The top-most listed column is the primary sort, the next one down is the secondary sort, etc.
  14. If necessary change the sort order by clicking the record to be moved and then using the arrow keys to the right of the pane.
  15. Verify the Sort Order column in the Order By pane. This column indicates whether the records are sorted in ascending or descending order.
  16. Optionally, you may restrict the data in the report by using the Filter button. After clicking the button, the system displays the Filter dialog box, which appears similar to the example below:
  17. After your filter criteria are set, click OK.
  18. This closes the Filter dialog box.
  19. You have now configured all the parameters for the report. To display the report, click Show Report.
  20. This opens a new window and displays your report.
  21. Click OK to close the Setup Standard Report dialog box.
  22. Click Save Data. All information is now stored in the database.

New GIS Report

In this example, we will create a new GIS report that shows the condition ratings of bridges.

To create this report, follow the steps below:

  1. In the left pane of the Reports page, right-click on the My Reports folder.
  2. Click Insert GIS Report in the function menu.
  3. The system displays a dialog box where you select the table or view on which the report will be based. An example of this dialog box is shown below:
  4. The first table listed is the table that is needed.
  5. Click OK to close the dialog box.
  6. This adds a new GIS report title to the folder.
  7. As needed, change the title of the new report by clicking the title to select it and then typing the new title in the right pane.
  8. Right-click the new report and then click Setup/Show Report.
  9. This displays the Setup GIS Report dialog box. An example of this dialog box is shown below:
  10. In the Color By pane on the left, select the column that will have its data shown on the map by clicking the check box beside the name of the column. For this example, the desired column is Bridge Condition Rating.
  11. Click the Report tab. For this example, this displays a map with the bridge condition ratings.
  • No labels

Provide Feedback