BackPrevious Topic Next TopicNext

Insert Summary Dialog

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.

Insert Summary dialog

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.

Aggregate Function

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 Choose button to select the required fields in the Select Fields dialog.

Summary On

Displays the field on which the summary is to compute.

Group By

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.

Back to top

BackPrevious Topic Next TopicNext