Partager via


How to: Suppress Repeated Values for Report Controls

You can suppress the display of repeated values in consecutive records so that the value appears once for the first record but not for subsequent records until the value changes. You can also suppress the repeat display of report controls.

For example, suppose you have an invoice with underlying table fields that contain the date of the transaction. You can specify that the date appears only once for transactions that occurred on the same date.

You can also choose to repeat values only when a new page or column begins, when the data group changes, or when a Detail band continues with the next page or column.

To suppress repeated values or report controls

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

  2. In the designer, double-click the report control you want.

    The properties dialog box for the report control opens.

    Note

    If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the report control dialog box displays or a different dialog box might display. In the report control dialog box, click Print When to open the Print When dialog box. For more information, see _REPORTBUILDER System Variable and Print When Dialog Box.

  3. In the report control properties dialog box, click the Print when tab if it is not selected.

  4. In the Print repeated values area, click No, and then OK.

For more information, see Print When Tab, Report Control Properties Dialog Box (Report Builder).

To repeat values or report controls under specific conditions

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

  2. In the designer, double-click the report control you want.

    The properties dialog box for the report control opens.

    Note

    If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the report control dialog box displays or a different dialog box might display. In the report control dialog box, click Print When to open the Print When dialog box. For more information, see _REPORTBUILDER System Variable and Print When Dialog Box.

  3. In the report control properties dialog box, click the Print when tab if it is not selected.

  4. In the Print repeated values area on the Print when tab, click No.

  5. In the Also print area, choose one of the following:

    • To repeat values or the report control only for a new page or column, click In first whole band of new page/column.

    • To repeat values or the report control only when the data group changes, click When this data group expression changes. Select the appropriate data group from the drop-down list.

    • To repeat values or the report control only when the band continues with the next page or column, click When band content overflows to new page/column and In first whole band of new page/column.

  6. When you are finished, click OK.

For more information, see Print When Tab, Report Control Properties Dialog Box (Report Builder).

See Also

Tasks

How to: Suppress Blank Lines in Report Controls

Other Resources

Configuring Report Controls