Report Wizard: Step 2 – Group Records

See Also

You can use data grouping to categorize and sort your records so that they are easier to read. Once you select a field in one of the Group by boxes, you can choose Grouping Options and Summary Options to refine your grouping selection.

Choosing Grouping Options opens the Grouping Intervals dialog box that lets you select levels of filtering that are relevant to the type of data contained in the fields you selected for grouping.

Choosing Summary Options opens a new dialog box that lets you specify from the following list the type of calculation to perform on specific numeric fields:

Summary Option Return
Sum Total of values in the specified numeric field
Avg Average of the values in the specified numeric field
Count A count of the number of records containing a non-nil value in the specified field
Min The minimum value in the specified numeric field
Max The maximum value in the specified numeric field

You can also choose Detail and Summary, Summary only, or No Totals for the report.

Fields that you select as groupings here are not available in Step 3 - Sort Records.