Exporting to multiple Excel worksheets.

[mrees]

I have clients who still wish to receive reports via Excel, some of these contain more that one worksheet, eg a sheet with the raw data and another with summaries.

We use CR 8.5 and Crystal Enterprise, and ideally want to use these for all our reporting. Is there any way that we can export data to the same workbook and on different sheets?

 

[Madawc]

I'm fairly sure there isn't. Your best solution might be to make two versions of the report producing the two different types of output. Madawc Williams
East Anglia
Great Britain

 

[mrees]

Thanks for that, it was as I thought but it was worth a try.
Some clients insist on having all data in one spreadsheet

I suppose its back to using Excel itself to pull the data thru via an ADO connection - bah!

mrees