Adding Multiple Data Groupings

You can define up to 20 levels of data grouping within a report. Nested groups are helpful for organizing data and totaling expressions for different levels.

To choose a level for a grouping, estimate how often the value might change, then define the group that will change most often first. For example, your report might need a grouping by region and a grouping by city. The value of a city field changes more than the value of a region field; therefore, the city should be the first of the two groups and the region should be the second. In this multiple group report, the table must be sorted or indexed on a key expression such as Region+City.

To add multiple groups

  1. From the Report menu, choose Data Grouping.

  2. In the first Group box, type the group expression.

    -or-

    Choose the dialog button to create an expression in the Expression Builder.

  3. In the Group properties area, choose the properties you want.

  4. Choose Insert and repeat steps 2 and 3 for each grouping expression.

  5. Choose OK.

Groups are numbered in the Data Grouping list in the order they are created. In the Report Designer, the names of the group bands contain the number of the group and a truncated group expression. The group headers and footers with the lowest number appear closest to the Detail band.

See Also

Adding a Single Group Report | Changing a Group Band | Data Grouping in Layouts | Deleting a Group Band | Changing the Grouping Order | Data Placement Preparation | Expression Builder | Report Designer