> Making reports look good / Properties / Data Source properties / Aggregation

Aggregation

Data aggregation allows you to combine multiple data records before running the report (so you can combine data without using groups).

  1. Select the report or subreport from the Report Explorer pane.
  2. From the Properties pane, select Aggregation from the Data Source area, then click the finder button .
  3. On the Data Groups tab, you can enter fields for which you want to group the data. You can type a field name or click ... to display the Expression Editor, then click Add.
  4. By default, the method of aggregating the fields will be to calculate their sum. Alternatively, you can calculate their minimum, maximum, or average value. To do this, select the Aggregated Data tab, and add each field (that you do not want to sum) and select its Aggregate Method.

Go to top