Solved

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

Posted on 2012-12-26
5
4,794 Views
Last Modified: 2013-07-29
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
0
Comment
Question by:hongclub
5 Comments
 
LVL 8

Accepted Solution

by:
Crashman earned 168 total points
ID: 38722244
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
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 166 total points
ID: 38722366
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
 
LVL 18

Assisted Solution

by:vasto
vasto earned 166 total points
ID: 39166842
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB.Net. Reading xml value 6 38
Convert Ctime to date time in textfile? 7 62
Dates formatted Differently on another pc 2 28
Filtering a datagrid view 8 34
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question