Report wizard, step five

Specify what summary information, if any, you want in your report. Summary information is presented in the report immediately after each specified group (or at the end of the report in the case of a grand summary).

How to specify summary information

1. Select a group from the Group drop-down list box. The Group box lists the fields that were selected as groups in the previous step. It also lists <Grand Summary> for summarizing the selected field not just for groups, but across the entire report, like the Grand Total on a bill.

• From the Available Fields list select a field on which you want to perform a summary operation within this group. The Available Fields list shows all the fields in the source table that are appropriate for summary information. A field does not have to be included on the report to be used for a summary field. And a field does not have to be specified for grouping to be used as a summary field.

• From the Available Aggregates drop-down list box, select the summary operation you want performed on this field.

• Double-click the field or click the > button to move the field name and specified operation over to the Selected Summary list box.

• If you want summary operations performed on other fields within the selected group, repeat steps 2–4.

• To specify summary operations for other groups, select another group from the Group drop-down list, and repeat steps 2–4.

You can change the summary operation you already specified for a field by selecting the field in the Summary list and choosing a different operation from the Selected Summary Aggregate box below it.

Dialog box options

Group Available fields

The Available Fields list shows those fields on which you can group your report. (You cannot group on BLOB fields, such as graphic or memo fields.)

You don’t have to group your report on any field, if you don’t want to. In that case, rows will be displayed in the same order as the source table. Also, you can use a field for grouping without including that field’s information in the report.

Select the fields that you want to use and move them to the Selected Fields list by double-clicking or using the arrow buttons.

Available aggregates

Select the summary operation you want performed on the field highlighted in the Available Fields list:

Maximum Display the maximum value of those in the grouped field.

Minimum Display the minimum value of those in the grouped field.

Count Display the number of fields in this group.

Summary

The list of fields you are selecting to appear in the report. To remove a field from the list, double-click it or use the arrow buttons.

Selected summary aggregate

Use this selection box to change the summary operation on a field already added to the Summary list. First highlight the field in the Summary list to change its summary operation.

Arrows

Click the > arrow to add the selected field in the Available Fields list to the Summary list. Click the >> arrow to move all the available fields to the Summary list..

Click the < arrow to remove the selected field from the Summary list to the bottom of the Available Fields list. Click the << arrow to remove all the selected fields from the Summary list to the bottom of the Available Fields list.