Excel Exports in CR9+

[mgrejtak]

We recently went thru an ERP upgrade that forced us to upgrade all of our existing CR8.5 reports to CR10. Many of these reports are exported to Excel for further manipulation. With CR8.5 we had the ability to select a specific Excel version - and the export worked fine.

However with CR10 we no longer have specific Excel versions to select, the Excel output is "merged", and often broken, extra sorting, and extra blank lines are resulting.

How have you that have gone thru a similar upgrade path dealt with this problem. My understanding is that the problems started in CR9 and higher.......

Thanks in advance for any suggestions......

 

[synapsevampire]

One means I use is to create an additional detail section and drop the fields in right alongside each other, and then use a parameter to prompt the user for whether this report is for Excel export.

If so, then I suppress all otehr sections and only display the export detail, otherwise it is suppressed.

There should also be a Excel data only export available, and some even use a comma delimited export which opens fine within Excel.

Also apply the service pack for CR 10, it helps with some exporting concerns.

-k