Export to multiple tabs in Excel

Spykair
Spykair used Ask the Experts™
on
Hi,

Is there a way that I can export data into different tabs in the same Excel file ?
Using CR10 with an Oracle DB.

Spykair
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor of MIS at Penn State Erie and Owner, Millet Software
Commented:
One of the 3rd-party Report Managers listed at http://www.kenhamady.com/bookmarks.html provides this functionality.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
as stated above only through a third-party tool or by writing your own application to do it.  Crystal doesn't have a way to do it through the export button.

mlmcc

Author

Commented:
Hi guys,

Thanks for your comments.
Mike, when you say writing your own app, have you got some sample code for me ? We're using .net

Spykair
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
I don't.  I have never had a reason to build such a tool or the need to export reports to more than 1 tab.

Did you look at the tools listed above.  Take a quick look at Visual Cut.  It can do what you want.

I think you will find that you will spend much more than the cost of the tool developing the application and then only have the export feature.

mlmcc

Author

Commented:
Thanks guys. I will try and twist the boss' arm to buy it.

Spykair

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial