Example: The following fields are added to a report to display the record's address but some records might not have a value for Address line 2.
  • Address line 1
  • Address line 2
  • City
  • State
  • Zip
To suppress blank fields:
  1. Go to Insert > Text Object to add a textbox into the report
  2. Drag the Address fields into the textbox
  3. Right-click on the text box and select Format Text
  4. On the Common tab, mark the Suppress Embedded Field Blank Lines checkbox
  5. Click OK

Example: There are Gift fields in the Details section of a report but some records might not have any gifts for this particular report.

To suppress blank sections:
  1. Go to Report > Section Expert
  2. Highlight the section that is showing blanks (in this example, the Details section)
  3. Mark the Suppress Blank Section checkbox
  4. Click OK

Note: If there are two fields adjacent to each other and these two fields are not directly related to each other, this can cause duplicate/blank rows to appear.  If this is the case use subreports to display these unique fields and place the subreports adajacent to each other.