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.

Tasks

Other Resources