Joined: 09 Jan 2012
Online Status: Offline
Posts: 7
Topic: Problem with Export To Excel functionality. Posted: 01 Aug 2013 at 12:47am
Hi,
We are using Visual Studio 2008 Crystal Reports. "Export to PDF" is generated correct but while doing "Export to Excel" some of the columns / column headings in the generated excel sheet are displayed incorrect or interchanged like
1. 6th column heading is displayed in 10th column heading
2. 4th column heading is displayed in 5th column heading
We are using "CrystalDecisions.Shared.ExportFormatType.ExcelRecord" format.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 07 Aug 2013 at 5:05am
The Excel export is VERY picky about formatting. A couple years ago I wrote an article for the SAP Crystal Reports and Dashboard Design Facebook page on how to format a report for exporting to Excel. You can find it here:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum