I am using the version of Crystal Reports that comes with Visual Studio 2008. There are only two Excel export options. One looks like a pdf and the other is data only.
If I export to Excel (the one that looks like a pdf) the columns get merged.
If I export to Excel using Data Only:
1) The report titles do not show up like in previous versions of Crystal.
2) The totals columns do not show up under the correct column like in previous versions of Crystal.
The issue is the user exports to Excel so they can sort columns and do other modifications. Since the export to Excel merges columns, Excel won't let them sort. Since the Data Only export doesn't not align the totals under the correct columns, they still cannot sort correctly.
I need to export the report to Excel like previous versions of Crystal (8.0 and 8.0 extended). Does anyone know how to do it or is there a patch I can download? I have already tried all the Excel export options using code and nothing worked. I cannot reformat all my report fields as suggested by some people because I have 800 reports (not an option).
If you have any information, please be specific, as I have searched this site for suggestions and patches and have only found one compatibility document which didn't tell me much.
Thanks.