Crystal Reports – How to suppress blank rows

The following steps show how to suppress blank detail rows in a crystal report.

In this example the report does not have a ‘user_name’ value – leaving the row blank.

  1. With the report open in Crystal  Reports, click on the ‘Report’ menu then ‘Section Expert’
  2. Make sure the correct section is selected under ‘Sections’ (most likely ‘Details’)
  3. Tick ‘Suppress Blank Section’ and click ‘OK’
  4. The blank rows will now be hidden/suppressed.