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:
- SelectFile, thenSave As.
- Give your report a new name.
- Open your report for editing:
- SelectFile, thenReport Designer.
- Select the+next to the document type folder.
- Double-click the report to open it.
- Remove vertical centering:
- SelectFile, thenPage Setup.
- Go to thePapertab.
- Clear theVerticallycheckbox in the Center on Page section.
- SelectOK.
- SelectFile, thenSaveto 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 theContentsfield (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.
- SelectFile, thenSaveto save your work.noteYou can selectFile, thenRestore Defaultto go back to the original report.