Summarizing Data

You can summarize data or scripts in a report collection by using one of the following functions.

• Sum

• Average

• Non-zero average

• Count

• Distinct Count

• Non-null Count

• Maximum

• Minimum

A summary field cannot summarize a script if that script references summary fields.

A summary field can be used for a running total or as a summary of a group of query results. A summary field used as a running total accumulates throughout a report. A summary is usually printed once at the end of a series of detail lines. A running total may be printed for each line, showing the accumulating total.

A summary field has a reset feature, which indicates the range of query result objects to summarize (for example, the sum of sale amount reset on the change of branch or a running total of the sale amount reset on the change of sales item). Valid values for the reset feature are:

• Never

• Change of database field value

• Change of group

• Whenever the summary field is printed (for example, when printing totals for a page)