We help IT Professionals succeed at work.

Suppress Blank Rows

kgittinger asked
I have a report that I need to export to Excel.  How can I ellimnate the blank rows from the export?  My blank rows are conditionally formatted to suppres.
Watch Question

Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Blank rows in Excel export have several causes.

Does the report have a subreport?

Here is a white paper on exporting Crystal to Excel

As a rule of thum to minimize blank rows in exporting to Excel try creating as many as possible of subsections like if in a section you have 5 lines that are static not variable hten try creating each line in a sub section this way you can control the data output minimizing blank lines also try aligning the data fields so that they don't use diffrent columns and some may endup blanks