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

[jchewsmith]

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.

 

[kray4660]

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.

 

[SkipVought]

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]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[IanWaterman]

There is no way to do this natively in Crystal. However, there are some third-party tools available that will do this. See

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

for a good list and reviews of what's available.

Ian

 

[SkipVought]

If you care to pursue the Excel program option, you might start a thread in forum707.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[PeterDimitrov]

If you can use 3rd party software try our community edition, it is free:

http://r-tag.com/Pages/CommunityEdition.aspx.

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports, SSRS and Dynamic Dashboards.