When Export to Excel Column Allignment is Mismatching

[#1]

Dear Expert ,

I am using Visual Studio 2010 and  CR Version 13 Service Pack 13.0.6.1027  . . My report is working fine when export to PDF ,

But Same report when I export to Excel Record  Format  , Column is getting  mismatching ..

I am using Following Code to export in Excel Record .

rpt.ExportToHttpResponse(ExportFormatType.ExcelRecord, Response, False, "Profit_Loss")

[DellSC · Accepted solution]

Crystal is VERY picky about how things are formatted in order to get the correct output to Excel.  In addition to the document in Ludeks response, I uploaded a text file on this thread (see my second response) http://scn.sap.com/thread/3329390.  This contains information about formatting a report for Excel export that I wrote for the SAP Crystal Reports and Dashboard Design Facebook page a couple of years ago.

-Dell