Share via


How to: Specify Expressions to Evaluate When Processing Bands

You can specify expressions to evaluate before or after processing a band in the report or label page layout.

To specify expressions to evaluate when processing a report band

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

  2. On the Report menu, click Edit Bands.

    The Edit Bands dialog box opens.

  3. In the Edit Bands dialog box, select the band you want, and click OK.

    The properties dialog box for the report band opens.

    Tip

    You can also double-click the band separator in the Report Designer or Label Designer to open the report band properties dialog box.

    Note

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

  4. In the report band properties dialog box, click the General tab if it is not selected.

  5. In the Run expression area, perform the following:

    • To specify an expression to evaluate before processing the report band, type an expression in the On entry box.

    • To specify an expression to evaluate after processing the report band, type an expression in the On exit box.

    To build an expression, click the ellipsis () button next to the On entry or On exit box to open the Expression Builder. For more information, see Expression Builder Dialog Box.

For more information, see General Tab, Report Band Properties Dialog Box (Report Builder).

See Also

Tasks

How to: Configure Output for Report Bands

Other Resources

Working with Report Bands