How to export from crystal reports to excel without leaving any blank rows?

[Former Member]

Hii,

   I am using crystal reports 2008.While I am exporting from crystal reports to excel it is creating blank rows.Actually I need to leave a little space on the top and bottom of the fields while crystal report designing time,so that report view will look good.But if am leaving space like that,exporting time it is creating blank rows.I found a solution to this in one forum like if we are leaving any space while crystal reports design time excel will create blank rows or columns for each space while exporting to excel.I made all the fileds "Fit to section" without leaving any spaces.It worked with excel.But the report is not looking good.Can anyone plz help me?

[former_member188030 · Accepted solution]

Edit: Dell has replied to the same query in your other post .

Please close this thread.

Thanks,

Bhushan