Generating Custom Tabular Reports

In Lesson 3, we saw how FlexTables can be used as an efficient means of data entry.

They are also useful for creating customized reports of calculated results, as

demon-If you’ve already completed Part 1 of this lesson, you can continue using the same model. Otherwise, begin by clicking the File/Open button; then, browse to the C:/

Program Files/Bentley/SewerGEMS V8i/Lessons folder, highlight Lesson_5_2.swg, then click Open.

1. Click the Compute button, then close the Calculation Executive Summary dialog.

2. Click the Analysis menu, select the EPS Results Browser command. A FlexTable displays the calculated results for the current time step. The EPS Results Browser allows you to control the time step that is displayed.

3. Click the View menu and select the FlexTables command.

4. In the FlexTables dialog, highlight the Tables-Project node, then click the New button and select Folder from the submenu that appears.

5. A folder is created in the tree view of the FlexTables dialog.

This allows you to organize your custom tables. Highlight the newly created folder and click the Rename button. Rename the folder to Conduit Results.

6. Click the New button and select FlexTable from the submenu that appears.

7. The FlexTable setup dialog appears. Change the Table Type to Conduit.

Lesson 5: Presenting Calculated Results

The Available Columns list pane on the left side of the dialog displays all of the attributes that are available for display in the custom table. The Selected Columns list pane, which is currently empty, displays all of the attributes that will be displayed in the custom table. You define a custom table by moving the attributes that you want the table to display from the Available Columns list to the Selected Columns list.

Input data attributes are denoted by a blue icon.

Output data (result) attributes are denoted by a yellow icon.

8. Double-click Label to move it to the Selected Columns list.

9. Double-click each of the yellow result attributes in the Available Column list to move them to the Selected Columns list. Alterna-tively, you can highlight the attributes and click the Add button.

10. When you have finished moving all of the output attributes to the Selected Columns list, click the OK button.

11. The FlexTable display dialog appears. The table currently displays the results for each of the conduits in the model for the 00:00:00 hour timestep. Resize the FlexTable dialog so that more columns are visible, and position the FlexTable dialog so that the EPS Results Browser dialog is also visible.

12. Click and hold the Time Slider control, then slowly drag the control to the right.

Note that the values for most of the result attributes in the table vary over time.

Move the slider to around the halfway point.

Lesson 5: Presenting Calculated Results

13. The rows in the FlexTable can be sorted according to any attribute. Right-click the Flow column heading and select the Sort...Descending command from the shortcut menu that appears. The table rows will be arranged so that the element with the highest flow during the current time step is at the top and the element with the lowest flow is at the bottom.

14. You can apply filters to any FlexTable. Filters let you change the table so that only rows that match the specified criteria will appear. Tables can be filtered according to any attribute. Click the Edit button.

15. In the FlexTable setup dialog, double-click the Diameter attribute in the Avail-able Columns list. Click OK.

16. In the FlexTable display dialog, scroll to the Diameter column. Right-click the column heading and select the Filter...Filter command from the shortcut menu that appears.

17. In the Filter dialog, scroll to the Diameter attribute in the Fields pane and double-click it to add it to the query pane at the bottom of the dialog. Click the <=

operator button. Click the refresh button above the Unique Values pane and double-click 24.0 in the list that appears. The dialog should now look like this:

18. Click the Apply button, click OK in the Query Successful prompt, then click OK to close the Query Builder dialog.

19. In the FlexTable display dialog, note that there are only three elements displayed, and a message has appeared along the bottom of the dialog: “3 of 9 elements displayed” and a “FILTERED” notification appears to the right of the message.

Only the elements with a diameter of 24 inches or less are shown in the table because of the filter we created.

20. Close the FlexTable display dialog, then close the FlexTables manager dialog.

This concludes this part of the lesson. The next part continues where this part leaves off, so you can keep the same project open if you plan to continue immediately. If you plan to begin the next part at a later time, you can either save the current project or use the Lesson_5_3.swg project located in the C:/Program Files/Bentley/SewerGEMS V8i/Lessons folder.