Grouping sections of the report

  1. Select Insert > Section > Group Section.
    The Group Section dialog is displayed.
  2. Specify this information:
    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.
  3. Save your changes.