<div>
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<br />
gowlfow
</div>


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

<div>
<div class="content wysiwyg-content">
I have a report that I need to export to Excel. &nbsp;How can I ellimnate the blank rows from the export? &nbsp;My blank rows are conditionally formatted to suppres.
</div>
</div>


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.

Suppress Blank Rows

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.