& Construction
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing
Professional CAD/CAM tools built on Inventor and AutoCAD
The Query Summation Report can be used in conjunction with Database Queries (DB queries) to determine and evaluate the different attributes associated with the InfoWater Pro data elements. Those elements include junctions, tanks, reservoirs, pumps, valves, and pipes that satisfy the DB query. The report groups elements according to values in a specified field. Within each group, the values of another field are summed, such as length of pipe for each diameter value.
A DB query must be used to start a Query Summation Report. In this tutorial, the report includes all pipes. Therefore, a query must be created to select all pipes.
Note: This is a random value chosen to select all pipes when running the query. Because no pipes have this ID, by excluding it, all the pipes are selected in the query.
The software will sum the pipe lengths that fall under each diameter type. So, you will see the total length of pipes that are under each unique diameter.
In the Report Manager, you can view the results as a Report, Bar Chart, or Pie Chart. The options to format these charts are the same as those to format graphs in the Report Manager for any report.
If you ran this report to find out which pipe diameter has the most total length in the model, you can see that the 6" pipes have the most: