1. Open the report or label in the appropriate designer.

2. On the Report menu, click Data Grouping.

   The Report Properties dialog box opens.

   Note:
   If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the Data Grouping dialog box displays or a different dialog box might display. For more information, see _REPORTBUILDER System Variable and Data Grouping Dialog Box.

3. In the Report Properties dialog box, click the Data Grouping tab if it is not selected.

4. On the Data Grouping tab, click Add.

   A data group expression appears in the Grouping nesting order list.

5. In the Group on box, type the expression you want. To build an expression, click the ellipsis (…) button to open the Expression Builder.

6. In the Group starts on area, select the output settings you want for the data group.

7. To add another data group, click Add and repeat steps 4 through 5 for each data group expression. To remove a data group, click Remove.

   Tip:
   Expressions appear in the Group nesting order list in the order they are added initially. However, you can change the order of the group expressions. To change the expression order, drag the mover button to the left of the expression you want to move to the position you want.

8. When you are finished, click OK.

   Group Header and Group Footer bands appear for each data group and surround all Detail bands in the layout. Each Group Header and Group Footer band displays the number of the data group and the data group expression. The Group Header and Group Footer bands with the highest number appear closest to the Detail band.

Other Resources