Group information

Introduction

You can divide report information into groups that share something in common. For example, you may prefer to see a list of contacts grouped by town or city.

Each group section has a header at the start of the information set and a footer at the end of the information set. A group header can be used to show a title that indicates what is contained in the group. A group footer can be used to show a total or subtotal for the group.

The details section (the main body of the report) sits between the group header and footer on your report layout. We recommend you deal with your details section before grouping the information.

Multiple levels of grouping can be used. For example, a list of contacts could be grouped by type (private, corporate, government) and then by city or town.

A group section has an expression that controls how the information is divided into the different sets of information, such as date, name or post code. By its very nature the group sorts information into sets. The information in these sets can then be sorted. The group sort always takes priority over other sorts.

You can

Add headers/titles to introduce the information in a group.
Add totals or subtotal to grouped information.
Have the information sets ordered in ascending or descending order.
Have multiple levels of grouped information.
Allow or prevent the grouped information from breaking across pages.
Start the grouped information on an even or odd page.
Add a filter to exclude unwanted information from the group.
Sort the information within each grouped set.

Group information in your report

To group information on your report:

Choose Sections > Add Section > Group Header and Footer.

The Expression Editor appears.
Enter the expression or variable on which the report will be grouped.

Tip: The group can be controlled by a variable that doesn't even appear on your report.

Go to top