Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Shipped
Categories 2D Drawing
Created by Guest
Created on Jan 27, 2021

Aggregate Functions in Reports and Tables

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 IDArea

101
200

102
250

103
250

104
400

105
150

Area Report - With Aggregates

Room IDArea

R101
200

R102
250

R103
250

R104
400

R105
150

Total
1250

  • Guest
    Reply
    |
    Feb 5, 2021

    Thanks again Jon for pointing this out new interface for our Ideas forum.


    Regards,

    Regie

  • Guest
    Reply
    |
    Jan 28, 2021

    MicroStaton CONNECT Update 15 added aggregates to Report Definitions