Export A Report To Excel In Seperate Worksheets

[campbere]

I have a Crystal Report that customers would like to see broken out into individual worksheets for each distinct product.

Currently I have a report that lists all the current products, the number of products varies through time.

The reports lists the product name, location of product, date of first arrival, price, quantity, and number of components. At this time it all shows up in one Excel Spreadsheet when I export it. Is there any way I can automatically export it out to Excel but for each individual product put that information in a new Excel Worksheet?

Thank you for your help

 

[dgillz]

In a completely separate file? not just a separate tab in the same file? Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[campbere]

I need to export the Crystal Report into one Excel Workbook but have each Product and it's information on seperate worksheets in the one Workbook.

Currently when I export the report all the information goes to one Excel Worksheet in the Workbook.

 

[synapsevampire]

I don't think that Crystal will support this, but you can use post-process VBA within an Excel spreadsheet.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dgillz]

SV is correct, this does not work in crystal while exporting to excel. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[IdoMillet]

If you are willing to export to a new spreadsheet file for each unique Product, have a look at my CUT or Visual CUT utilities at the link below.

Cheers,
- Ido CUT & Visual CUT: e-mailing, exporting, bursting, distribution, and scheduling of Crystal Reports:

http://www.MilletSoftware.com