How to: Suppress Blank Lines in Report Controls

Your report might include records that do not contain values for every field on the report. By default, Visual FoxPro leaves the area for that field blank. To reduce the "white space" in the rendered report output, you can specify that the report engine vertically contracts the report output in cases where all controls in a horizontal line across the layout render as empty.

To suppress blank lines in a report control

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

  2. In the designer, double-click the report control you want.

    The properties dialog box for the report control opens.


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

  3. In the report control properties dialog box, click the Print when tab if it is not selected.

  4. On the Print when tab, click Remove line if blank, and then OK.

For more information, see Print When Tab, Report Control Properties Dialog Box (Report Builder).


When a field in a report band is blank or the field in the underlying table is empty, Visual FoxPro checks the report band for other report controls. If no other controls exist in the report band, Visual FoxPro removes the entire line. You can choose whether the report band adjusts for suppressed blank lines. For more information, see How to: Configure Output for Report Bands.

See Also

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic