Previous TopicNext Topic


Chapter 9 Aggregating data

One of the key features of any report is the capability to display summary, or aggregate, information. For example, a sales report can show the overall sales total, sales subtotals by product type, region, or sales representatives, average sales amounts, or the highest and lowest sales amounts.

Aggregating data involves performing a calculation over a set of data rows. For a simple listing report, the aggregate calculations are performed over all the data rows in the report.

For example, BIRT calculates an average payment in a report by adding the payment amounts in every row, then dividing the total by the number of rows.


(c) Copyright Actuate Corporation 2006

Previous TopicNext Topic