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

[Former Member]

Hello Sriram

Not sure if this doc will help, but have a look:

http://scn.sap.com/docs/DOC-39608

If that does not help, how is the export when you use the viewer? I realize you may not be using the viewer in your app, but a simple test of this export would be appreciated.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member]

Thanks For Your Reply Ludek ,

Above Link Which You Posted Helped me to Understand the Behavior of the Excel Report , Also

My Report is Not a complicated one, So I easily handled with the help of Christy  Post , Just I inserted Some Blank Text Box and Now Its working Fine ,, 

  If there is 4 to 5 sub report handled in report , I think it will be complicated to design report in Excel Format , Can We Expect Better Solution in Future ?