Add a summary

The summary field allows you to aggregate and present values of record fields in your report.

The summary field computes these values before the rows in your report are processed, unlike running totals which must process each row first. This may cause your device to use more memory to compute the values.

Note:

The summary field is currently available in reports created with C#.

To add a summary to your report:

1. Open the Data Model Diagram (.4rdj).
2. In the central workspace, right-click inside of the record and select Add Field.
3. In the Properties view, under Field, click the fieldType combobox and select SUMMARY.
4. In the Properties view, click the summaryField combobox and choose the record field to apply the summary to.
5. Select the summaryFunction combobox and choose the function type from one of the following:
   • COUNT
   • DISTINCT COUNT
   • MIN
   • MAX
   • SUM
   • AVERAGE
6. Select the groupTrigger combobox and choose from the following options:
   • GrandTotal - Computes all fields specified in the fieldType.
   • OnFieldChange- Computes individual fields within the specified fieldType. When selecting OnFieldChange, choose the record field to apply it to in the groupField combobox.

When run, the report returns the summary values.