MicroStation CONNECT's reports and tables add useful capability to those wanting to harvest DGN data. They could be improved further by adding agggregate functions that perform calculations on the set of data displayed in a report or form.
For example, suppose I have a model that contains shapes each representing a room plan. I can create a report from the shape elements' area properties. But I need to find the total area of those rooms. An aggregate SUM() function in a report would facilitate that calculation.
Area Report - No Aggregates
| Room ID | Area |
|---|
| 101 |
200 |
| 102 |
250 |
| 103 |
250 |
| 104 |
400 |
| 105 |
150 |
Area Report - With Aggregates
| Room ID | Area |
|---|
| R101 |
200 |
| R102 |
250 |
| R103 |
250 |
| R104 |
400 |
| R105 |
150 |
| Total |
1250 |