Previous Topic Next Topic

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.

The following are details about options in the dialog:

Summaries

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 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.

Insert

Inserts the selected or newly created summary into the report.

Cancel

Does not retain any changes and closes this dialog.

Help

Displays the help document about this feature.

Previous Topic Next Topic