General Tab, Report Band Properties Dialog Box (Report Builder)

Makes it possible for you to specify general options for report bands in the Report Designer or Label Designer.

Note

This tab replaces the functionality of the native Visual FoxPro Report Band Properties Dialog Box when the Report Builder is active.

Band options

The following options allow you to specify the formatting and behavior of report bands.

Group expression
(Group Header and Group Footer bands only)

Specifies the expression used by the report engine to determine when to "break" from detail band rendering. The group header and footer information is rendered each time the result of the expression changes. Empty expressions are not valid.

You can type or build an expression by clicking the ellipsis (…) button. For more information, see Expression Builder Dialog Box.

Height
Specifies the height of the band. The report band height determines the amount of space each report band uses on the page within the page margins. The units of this spinner control depend on the setting of measurement ruler units for the report layout. For more information, see How to: Configure the Page Layout Grid for Reports.

For example, if the title band is set at half an inch, information in the title band appears in the first half inch of the page after the top margin.

Tip

When adding items to a report band, you might need to change the report band height to accommodate its contents. As a guide to determine the height, use the ruler to the left of the band. The ruler's measurement is specific to the height of the band and does not include the page margins.

Note

When reducing the height of a band, you cannot make a band shorter than the height of the controls in the layout. If controls in the band prevent you from resizing the band, move the controls in the band and then reduce the height.

Constant band height
Prevents the band from stretching to fit lengthy data or adjusting for suppressed blank lines. For more information, see How to: Suppress Blank Lines in Report Controls.

Specifies expressions to evaluate before and after processing the report band.

On entry
Specifies an expression to evaluate before processing the band. To build an expression, click the ellipsis (…) button to open the Expression Builder. For more information, see Expression Builder Dialog Box.

On exit
Specifies an expression to evaluate after processing the band. To build an expression, click the ellipsis (…) button to open the Expression Builder. For more information, see Expression Builder Dialog Box.