Exporting to multiple worksheets in one Excel file
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18873
Printed Date: 20 Apr 2025 at 11:58am
Topic: Exporting to multiple worksheets in one Excel file
Posted By: gloworm
Subject: Exporting to multiple worksheets in one Excel file
Date Posted: 24 Jan 2013 at 3:59am
I am working on a project where I need the data from 4 separate reports exported into a single Excel workbook, but on separate worksheets in the workbook.
Can this be accomplished with 4 separate reports or would they have to be combined into a single report.
If a single report is the way to go, please explain how to accomplish it. I am guessing subreports, but have not done subreports in over 10 years.
How would I tell the export to separate it into 4 worksheets in the workbook?
Everything I have found says it is not possible to do it with Crystal Reports natively. A third party program has been suggested but that is not a solution for this project.
|
Replies:
Posted By: kevlray
Date Posted: 24 Jan 2013 at 10:43am
|
It is true with the native CR you cannot export to more than one sheet of Excel. Yes you could combine the four reports into one report, but I am not sure this will help much at this point.
|
Posted By: hilfy
Date Posted: 28 Jan 2013 at 6:31am
|
To expand on kevlray's answer, I believe there is at least one third-party tool available that will do this. You can check out the list of tools here http://www.kenhamady.com/bookmarks.html - www.kenhamady.com/bookmarks.html for some options. -Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|