crystal report to multiple sheets in one excel workbook (file)

hi,

I am using Visual Studio 2012 Crystal Repot 13 to create a report which based on a dataset.

I was able to export the crystal report to excel, however, how can export it to multiple sheets in one excel file? Each sheet should represent each group. I got the grouping working, just don't know how to export to multiple sheets.

I heard visual cut software will work, but i don't know how to use it.

If you really have no answer for multiple sheets, at least show me how i can insert a print break after each group for workaround.

Please advise,
hongclub
hongclubAsked:
Who is Participating?
 
CrashmanConnect With a Mentor Commented:
With crystal reports is not possible, because you are not in control.

There is a tool: R-Tag Report Manager, which will allow you to combine multiple crystal reports and export them to separate worksheets in one excel file. You can find details here: www.r-tag.com

take a look
http://stackoverflow.com/questions/947687/crystal-reports-excel-export-with-worksheets
0
 
mlmccConnect With a Mentor Commented:
Visual Cut can do it.  You can read the user manual online

This link from SAP has some code tha is supposed to do it

http://scn.sap.com/thread/2149869

mlmcc
0
 
vastoConnect With a Mentor Commented:
This looks pretty old and obviously considered as unanswered so here are my 2 cents.

There are 2 tools on the market, which can be used to burst a crystal report: R-Tag Report Manager and Visual Cut. They can also combine the bursted files in one excel file with multiple worksheets. The difference is how they will do this:  
 
 - Visual Cut will use Excel automation. Microsoft strongly recommends to not do this. Here is why : http://support.microsoft.com/kb/257757
 
 - R-Tag does not require Excel, all exports are handled internally ( I was working for this company in the past and I am familiar with the internal architecture)

Basically, you can do the same in your program  by bursting the report to a folder and combine all generated excel files (one per group) in one file. I guess you will spend more time with the bursting , because this is the tricky part. Combining worksheets in  Excel is few lines of code ( if you use Excel automation)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.