How to: Protect Report Bands

You can set protection options for a report band to prevent the user from changing the band when modifying the report or label in protected mode.

To set protection for 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. There is no way to set a design-time caption using the native report control dialog box. For more information, see _REPORTBUILDER System Variable.

  4. In the report band properties dialog box, click the Protection tab.

  5. On the Protection tab, select a combination of the following protection options:

    • The user will not be able to resize the band in protected mode.

    • The user will not be able to access the Band Properties dialog box.

  6. When you are finished, click OK.

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

See Also

Tasks

How to: Protect Report Layouts
How to: Protect Report Controls

Reference

MODIFY REPORT Command

Concepts

Report Protection Flags

Other Resources

Setting Protection for Reports