Using the Summary Sheet

Use the Summary sheet of the Catalog of Available Fields dialog to create and maintain your summary fields. Summary fields enable you to automatically maintain running totals, and they provide automatic calculation of average, maximum, and minimum values.

When you select the field that you want to summarize, that value is accumulated automatically when the report runs. In your design, place the summary field in the section (usually a footer) in which you want your summary total printed.

The value of a summary field based on a script field depends on the sections of the report that include the script field. If the script field is included only in a header or footer section, the script field values in that section are summarized; otherwise, the script field is evaluated for each detail section, and those values are summarized.

You can place your summary field in exactly the same way that you place other field types, by dragging it from the Catalog of Available Fields dialog and dropping it in place in your layout. For details about inserting report fields, see "Inserting Report Fields", earlier in this chapter.

Maintaining a summary field is described in the following subsections.