Summary fields allow you to add totals, aggregates, averages and other statistical calculations to your reports. See below for details on how to add, edit and delete barcodes in your report whilst in design mode in the report designer.

Adding a Summary Field

Select the Summary Field button from the Tools Panel.

Draw the Summary Field on to a section of the report.

Enter a name for the summary field and press OK.

You can then choose to create a summary field based on a query field, an expression or a calculated field as described below:

To create a summary field based on a field in your query, select the database field option, then select the field you wish to summarise in the database fields list.

To create a summary field based on an expression, select the expression option, then press the expression builder button to open the expression builder and build your expression.

To create a summary field based on a calculated field on your report, select the existing expression option, then select the expression you wish to summarise in the expression list.

Select where the field's calculations will be done by selecting the Sum Values By value.

Report (GrandTotal) – Calculates the summary expression once for all detail records in the report.

Page (PageTotal) – Calculates the summary expression once for each page.

Group (SubTotal) – Calculates the summary expression once per group section selected in the Group list.

Select the summary type you wish to use. If you are using a distinct summary type, select the field to be used in the distinct function calculation. Press OK to continue and resize and format the field as required.

Editing a Summary Field

Select the summary field in the sections panel, press the right mouse button and select Edit from the drop down menu, then follow the steps above to define your field.

Deleting a summary field

Select the summary field in the sections panel, then either press the delete key, or press the right mouse button and select delete from the drop down menu.

Summary Types

Summary Type

Description

Sum

Calculates the total of all values within the specified summary region (group, page report).

Average

Calculates the average of all values within the specified summary region (group, page or report).

Count

Calculates the count of all values within the specified summary region (group, page or report).

Minimum

Calculates the minimum of all values within the specified summary region (group, page or report).

Maximum

Calculates the maximum of all values within the specified summary region (group, page or report).

Variance

Calculates the variance of all values within the specified summary region (group, page or report).

Population Variance

Calculates the population variance of all values within the specified summary region (group, page or report).

Standard Deviation

Calculates the standard deviation of all values within the specified summary region (group, page or report).

Population Standard Deviation

Calculates the population standard deviation of all values within the specified summary region (group, page or report).

Distinct Sum

Calculates the total based on the values of another field within the specified summary region (group, page or report).

Distinct Average

Calculates the average based on the values of another field within the specified summary region (group, page or report).

Distinct Count

Calculates the count based on the values of another field within the specified summary region (group, page or report).

Distinct Variance

Calculates the variance based on the values of another field within the specified summary region (group, page or report).

Distinct Population Variance

Calculates the population variance based on the values of another field within the specified summary region (group, page or report).

Distinct Standard Deviation

Calculates the standard deviation based on the values of another field within the specified summary region (group, page or report).

Distinct Population Standard Deviation

Calculates the population standard deviation based on the values of another field within the specified summary region (group, page or report).