How to eliminate blank rows while exporting to Excel


When I export a crystal report to an Excel file, it adds a blank row after every detail row. I have tried many solutions like aligning the fields, keeping the height similar, alignment as baseline. But none of them work.

Can you please let me know a solution so that such blank rows don't get added?

Best Solution

Finally, I got a solution with trial and error method. On crystal report designer, I went to Report->Section Expert. Under Details section, unchecked the 'Free-form Placement' checkbox and clicked on 'OK'. This solution worked and the blank rows no longer appeared while exporting to excel.

Related Question