Exporting to Excel with multiple worksheets

[Smithsc]

Is there any way of exporting a crystal report onto multiple excel worksheets. I've got a report that has multiple invoices on it and I need to split the details onto seperate sheets.

I've got CR version 14.0.5.882 and excel 2010

Any help would be greatly appreciated.

Stuart.

 

[SkipVought]

hi,

WHat would you do in Excel with multiple invoice REPORTS?

Why not instead export out of CR, a tablular report for all the invoices? That's something that can actually be useful in Excel, rather than an indeterminate number of invouce REPORTS.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Smithsc]

Hi Skip,
Our customer has asked for each invoice on a seperate worksheet. Can it be done oin crystal?

 

[kray4660]

No, but there are third party solutions to this issue. We looked into it at one time. I do not have any more information.

 

[hilfy]

Check out

http://www.kenhamady.com/bookmarks.html

for a starter list of third-party tools that are available. While this is by no means a complete list, it should get you started.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com