Crystal 11.5 - Exporting to Excel via report viewer component

[Former Member]

When you export a report to Excel using the report view component, it add a lot of unwanted formatting such as extra lines, merged cells, etc. It basically renders the report unuseable within Excel for doing things such as sorting, moving columns, etc. Is there any other way to export to Excel without this additional formatting, while still maintaining the look of the report. We are aware of the data only export, but that strips the report down too much. Previous versions of Crystal Reports, seemed to do a better job of this.

[Former Member · Accepted solution]

We had the same problem here also. We solved the situation by playing with the export options and with a lot of patience changing the excel design (removing coloured borders, merged cells, etc, etc) until it exported in a way people are able to do excel-like stuff (sorting, etc).

The aspect is ugly when compared with the PDF export version (that happened to be the same at the beginning until our customer starting complaining about the useless of the XLS version). The workaround was that: have a nice PDF for print and an ugly XLS for working.

It was not really fair that CR is not able to export to XLS in a clean way (it makes me remember Microsoft Word exporting a document to html - you open the produced file in a notepad and rougly 90% of the stuff is junk, being hard to do further manual changes).

[Former Member]

Open you report in Crystal report designer and export it.With code we can achive the same format.We can have the same functionality through code what we can have with designer we can't alter formats through code.

Regards,

Shweta

[Former Member]

Thanks for your quick response, but I'm not sure I fully understand your reply. Can you please clarify?

[former_member208657]

I would suggest you first look at the Report Export Options in the designer. You can find these under the File -> Export menu.

The Report Export Options are saved with the actual .rpt file and should carry through to your report in your .NET app. Play around with the options for Excel and make sure it all looks good from the designer. Export a few times to Excel until you have the options the way you want them.

Next save the report and use it in your .NET app. See if the results carry over for you.