How to Use the Query Summation Report Tool in InfoSWMM and InfoSWMM SA
The Query Summation Report may be used in conjunction with DB Queries to determine and evaluate the different attributes associated with the InfoSWMM H2OMap SWMMInfoSWMM SA data elements (Subcatchments, Junctions, Outfalls, Dividers, Storage Units, Conduits, Pumps, Orifices, Weirs, and Outlets) that satisfy the DB query.
Click the following links to learn more:
- Description of Query Summation Report dialog and Report tab
- Query Summation Report Methodology
- Description of Bar Chart tab
- Description of Pie Chart tab
- Adjusting display of Bar and Pie Charts
Description of Query Summation Report dialog and Report tab
The example below contains parameters that enable a summary of total conduit length by Geom1 (diameter etc.).
Contents of the Query Summation Report dialog are described below.
| Name | Description |
| ID | Specify the ID of the Query that you want to evaluate in your Query Summation Report. |
| Summary Field | Choose the Summary Field here. Use this to identify the Summary Class Field values. Depending on the DB Query ID chosen, all the fields corresponding to the DB Query element type will be available. |
| Summary Class Field | Use this field to select the InfoSWMM data field summary that you want to see. The Query Summation Report will display all the selected Summary Class Field values in your Summary Report. |
| Sub-Total | The Summary Class Field values for your Summary Field is displayed here. For instance if your Summary Class Field is GEOM1then all the diameter values will be displayed here. |
| Sub-Class | The data field values for your Summary Field is displayed here. For instance if your Summary Field is ID then all the element IDs will be displayed here. The Sub-Total section of the Summation Report will display all the Class Field values corresponding to this element. |
| Refresh | Use this to refresh your Query Summation dialog box. Change the Query ID and choose the Summary Field and the Summary Class Field and click on the Refresh button to display the new results. |
| Close | Use this to close out of the Query Summation dialog box. |
Note: The Customized Report Manager can now be accessed from the Report Manager by pressing the down arrow next to the new button.
Query Summation Report Methodology
Do the following to launch a Query Summation Report -
- Create a DB Query using the DB Query dialog box.
- Launch the Query Summation Report dialog box from your InfoSWMM Tools menu -> Query Summation Report. Alternately, the Customized Report Manager can now be accessed from the Report Manager by pressing the down arrow next to the new button.
- Specify the DB Query in the ID field of the DB Query section of the Query Summation dialog box. A report or graph depending on which tab (Report, Bar or Pie) you choose will be displayed in the display section of the Query Summation dialog box for all the elements that satisfy your DB Query.
- Choose the Summary Field and the Summary Class Field in your Query Summation dialog box.
- Click on the Refresh button to view your Query Summation Report. You may change your Query ID, Summary Field and Summary Class Field to view other attributes.
- Click on the Bar Chart tab to view a Bar chart and choose the Pie Chart tab to view a Pie chart. You may right-click inside the graph to customize your graphs.
The following example shows the data from the example above in a bar chart format
Note: Right-click inside the chart to initiate the Graph Control dialog
The following example shows the data from the example above in a pie chart format:
Note: Right-click inside the chart to initiate the Graph Control dialog
Adjusting display of Bar and Pie Charts
The display of the Bar and Pie charts can be controlled with the Graph Control dialog. To initiate the Graph Control dialog, click on the properties dialog. The following dialog will appear:
