How to: Edit Data Groups in Reports

You can edit the expression for a data group and its output options. You can also change the order in which data groups appear.

NoteNote

When you change the order of a data group, all controls in a group band move to the new location. Changing the order of data groups does not change any previously defined controls. For example, if controls are positioned relative to the top or bottom of a group band, they remain anchored in that position in the band.

To edit a data group expression

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

  2. On the Report menu, click Data Grouping.

  3. The Report Properties dialog box opens.

    NoteNote

    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.

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

  5. In the Grouping nesting order list, select the expression you want.

  6. In the Group on box, type the new expression or change the expression in the Expression Builder by clicking the ellipsis () button.

  7. When you are finished, click OK.

For more information, see Data Grouping Tab, Report Properties Dialog Box (Report Builder) and Expression Builder Dialog Box.

To change output settings for a data group

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

  2. On the Report menu, click Data Grouping.

    The Report Properties dialog box opens.

    NoteNote

    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, change the output settings you want.

  5. When you are finished, click OK.

For more information, see Data Grouping Tab, Report Properties Dialog Box (Report Builder).

To change data group expression order

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

  2. On the Report menu, click Data Grouping.

    The Report Properties dialog box opens.

    NoteNote

    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. In the Group nesting order list, drag the mover button to the left of the group expression you want to its new position.

  5. When you are finished, click OK.

For more information, see Data Grouping Tab, Report Properties Dialog Box (Report Builder).

See Also


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic