Add aggregate fields to a record

In this procedure, you add one or more aggregate fields to a record in a Report Data diagram. For example, you can get the average value of the fields.

To add aggregate fields to a record, you specify aggregation properties for one or more fields existing in the record.

Note: The aggregationFunctions property is available only for fields in business records for reports (.4rd files), not for forms (.4fd* files) or web services (.4ws or .4wsj files).
  1. Open the Report Data (.4rd) diagram.
    The diagram opens. The record hierarchy displays in the Structure View.
  2. In the Structure View, select the field to aggregate.
  3. In the Properties view, select the aggregationFunctions property. Click the ellipse to open the Aggregation Functions dialog.
    Figure: Aggregation Functions dialog

    Screenshot of Aggregation Functions dialog.
  4. Select the options to include in your aggregation.
  5. Save your changes.

When you compile your report data, the resulting data schema file includes fields to hold the selected aggregates, one for each grouping level. Like any other data field, these fields are available in the Data View and can be added to your report design document.