Fix extra spaces in a report

Sometimes you might see extra spaces between the header and body of your report. Follow these steps to fix this.

Save a backup of your report:

Select File
, then Save As
.

Give your report a new name.

Open your report for editing:

Select File
, then Report Designer
.

Select the +
next to the document type folder.

Double-click the report to open it.

Remove vertical centering:

Select File
, then Page Setup
.

Go to the Paper
tab.

Clear the Vertically
checkbox in the Center on Page section.

Select OK
.

Select File
, then Save
to save your changes.

If there are still extra spaces in the report:

Select a cell near the blank space.

Put your cursor at the end of the cell's content in the Contents
field (similar to the formula bar in Microsoft Excel).

Use the Delete key to remove any spaces after the content.

Repeat for other cells with nearby blank space.

Select File
, then Save
to save your work.

note

You can select File
, then Restore Default
to go back to the original report.

This article applies to: