How to: Configure Output for Report Bands

  • Article

You can configure output for report bands in the following ways:

  • Control whether report bands maintain a constant height or adjust for lengthy data and suppressed blank lines.

  • Specify that the output from Title and Summary bands display on individual pages.

  • Specify that output from Detail bands start with a new column or page.

  • Reset the page number to 1 for each detail set.

  • Repeat the output from the Detail Header on each page.

  • Specify a minimum distance from the bottom of the page that determines when to begin detail sets on the next page.

To prevent report bands from adjusting their size to fit lengthy data or suppressed blank lines

  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. Click Constant band height, and then OK.

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

To display Title or Summary band output on individual pages

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

  2. On the Report menu, click Optional Bands.

    The Report Properties dialog box opens.

    Note

    If the _REPORTBUILDER system variable is not set to the default Report Builder, the Optional Bands dialog box opens instead. If _REPORTBUILDER is set to a third-party builder, a different dialog box might display. For more information, see Optional Bands Dialog Box.

  3. In the Report Properties dialog box, click the Optional Bands tab.

  4. Perform the following:

    • To specify that Title band output appear on a separate page, in the Title area, click New page after title has printed.

    • To specify that Summary band output appear on a separate page, in the Summary area, click Summary prints as new page.

  5. When you are finished, click OK.

For more information, see Optional Bands Tab, Report Properties Dialog Box (Report Builder).

To configure output for Detail bands

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

  2. On the Report menu, click Edit Bands.

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

    The Detail Band Properties dialog box opens.

    Note

    If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the Detail 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 Detail Band Properties dialog box, click the Band tab.

  5. In the Detail properties area, select the output settings you want.

  6. When you are finished, click OK.

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

See Also

Tasks

How to: Specify Expressions to Evaluate When Processing Bands

Other Resources

Working with Report Bands