Grouping sections of the report

Group by

This pane shows the available items for grouping. To include them in grouping, highlight the required items in either the Fields tab, or the Calculated Fields tab and click Add. The selected items are moved to the Group Sections pane.

Group Sections

This pane shows the items selected for grouping. Select the required check boxes under Header and/or Footer to define where the grouping sections are to be displayed on the report. To remove items from the list, highlight the required items and click Remove. The selected items are returned to the Group by pane.

Other attributes of the Group Sections:

Sort Order

Change the order to either ascending or descending.

Grouping Rows

Enter a number of rows to group by. The report creates a new group instance each time a multiple of the number of rows is reached.

Page Break

Enter the event on which you want the page break to occur; None, Start, End, Start and End, Between.

Reset Page Number

If selected, the Globals Page Number is reset on a change of the group.

Variables

Define a group variable expression to be evaluated on each change of the group. The variable is used in the report by creating a field with the variables collected. For example, in the format Variables!VariablesName.Value.

Click OK to return to the main window. The defined groupings are shown in the Report Design window.

Note: To amend groupings, from the Edit menu, select Report Ordering to display the Group Section dialog which you can then amend as required.