The Insert Summary dialog helps you to insert a summary into a report. It appears when you select Insert > Summary, or right-click a DBField and select Summary Function from the shortcut menu.
The following are details about options in the dialog:
To create a new summary, select <Create...> from the drop-down list; to insert an existing summary into the report, select it from the drop-down list.
Lists the functions available for the selected field to be summed on. When DistinctSum is selected, the following option is available and should be set:
- Distinct On
Specifies the fields according to whose unique values to calculate DistinctSum. Select to select the required fields in the Select Fields dialog.
Displays the field on which the summary is to compute.
Specifies the field used to group the data. If selected, a summary of each group will be calculated.
Inserts the selected or newly created summary into the report.
Does not retain any changes and closes this dialog.
Displays the help document about this feature.