Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 2011 export multiple reports to one excel file on separate sheets 3

Status
Not open for further replies.

jchewsmith

Technical User
Nov 20, 2006
161
US
Is there a way to export multiple crystal reports into one excel file on separate sheets?

So I have 5 crystal reports that I want one excel file with 5 sheets.


 
The direct answer is no. But if you have one report that you want to five sheets and using some third party software, yes. Of course you could have one main report and five sub-reports (or no real main report and five subreports). But you would still need third party software to export to multiple sheets.
 
Hi,

I’d export all of the five reports as .csv text files, to an empty folder.

Any competent Excel user could import the five .csv files into as many sheets.

Or a competent Excel programmer could very easily write a procedure to import each text file in a given folder into separate sheets.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
If you care to pursue the Excel program option, you might start a thread in forum707.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top