Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Course Of The Month
8 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
crystal report to multiple sheets in one excel workbook (file)
Posted on 2012-12-26
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5 Comments
With crystal reports is not possible, because you are not in control.
take a look
http://stackoverflow.com/questions/947687/crystal-reports-excel-export-with-worksheets
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
Active today
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
This link from SAP has some code tha is supposed to do it
http://scn.sap.com/thread/2149869
mlmcc
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)
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)
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| What is the latest version of Crystal Reports? | 3 | 57 | |
| Timezone help | 5 | 43 | |
| Getting Maximum Score for certain records | 7 | 23 | |
| XML and Linq - reading fields in repeating nodes | 3 | 23 |
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code.
First, I create an Abstract Class for my DataTables Common Code. This class Inherits from DataTable.
Also, it can …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Are you ready to implement Active Directory best practices without reading 300+ pages?
You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses
Course of the Month8 days, 11 hours left to enroll
738 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.