Grouping

• Grouping is used to categorize a table within a report so that rows with a common value appear together. Grouping is applied when the table is created using the Table Wizard or Table/Form options.

• In the Table Wizard, there are grouping options for Group Left and Group Above. Group Left creates a nested table. Group Above creates a new table for each new value for the grouping field, displaying the value of the group by field as the table title.

• The grouping is contained within G and E markers.

• When selecting an element to group by, the report is sorted by the grouping. Checking the Data already sorted option improves performance.