Extra Rows and Columns in Excel Export

Monday 29 September 2008 @ 10:53 pm

A few years ago I wrote a newsletter article related to Excel exports. I described what you should do to prevent extra rows, extra columns and merge cells when exporting to Excel from Crystal Reports. Just last week I found another piece of the puzzle that explains why my methods would occasionally not eliminate all of the extra rows. It appears that if your row of objects in the report is not at the very top of the section (position 0) then Crystal will create double rows in the spreadsheet. Even if all the objects are the same height, and all are aligned in one clean row across, a tiny space above the row of objects will export to a spreadsheet with data on every other row. Read the article above for more information on cleaning up your Crystal Reports exports.

Leave a Reply

Recrystallize Pro