Viewer Export to Excel

[btgroup]

Is there a way to get the CR9 viewers to export into Excel without adding all of the report formatting to the final file? I would like the final file to simply be a flat file that only contains the data in in the sheet.

I attempted to use the "Excel (Data Only)" option in the ActiveX viewer, but you still get the background of the report and cells are merged together, etc.

Thanks in advance for any input.

 

[synapsevampire]

Try exporting to a comma delimited file, Excel will open it and the data will simply be a title, rows and columns.

I sometimes have to allow for 2 formats when designing a report and use a parameter to prompt for the format (display or export) to satisfy both requirements.

If they select export, then you can use a subreport and/or suppress items that you don't want exported.

-k

 

[btgroup]

I don't believe exporting to a CSV is available as an export file type option. I just looked at the ActiveX and Java viewers. Neither one seems to have it. Is there a way to activate it as an option?