We help IT Professionals succeed at work.

Suppress Blank Rows

kgittinger
kgittinger asked
on
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.
Comment
Watch Question

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

Does the report have a subreport?

Here is a white paper on exporting Crystal to Excel
http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/20c9c239-7b64-2b10-4ab3-b59d52ed35de?QuickLink=index&overridelayout=true

mlmcc
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
gowlfow