Solved

Exporting crystal reports into excel individual workbook

Posted on 2004-09-08
4
691 Views
Last Modified: 2006-11-17
I need to take the groupings from Crystal and put into separate workbooks and worksheets within the workbook.  

Example:  I have a sort by VP, Company, and Department with associated employees in Crystal.  I want to export into Excel in workbooks by VP and worksheets by Department.
0
Comment
Question by:mlofton
4 Comments
 
LVL 28

Expert Comment

by:bdreed35
ID: 12008932
This is the only tool that I know of that can do this for you:

http://www.milletsoftware.com/Visual_CUT.htm

Other than that, yo uwould have to write the code yourself I am afraid.
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12009150
Ido's software is excellent.  He's a nice guy, too:-)
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12009485
I agree with what bdreed said - you can't do it with Crystal only - here's the "workaround" that Biz Objects recommends: http://support.businessobjects.com/library/kbase/articles/c2014059.asp

That is however a complete load of crap - you'd be better off to export the whole thing and write a macro in Excel to move it to different sheets.

Visual Cut is a great tool and well worth the money.

frodoman
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 500 total points
ID: 12012970
First, thanks for for the kind words.

There's a slight twist to how you would achieve this in Visual CUT.  You would need to group your report at level 1 by a formula concatenating VP & Department ({My_Table.VP_Name} & {Department.Name}).  
This means that each VP&Department combination will be a new group at level 1.

You would place (suppressed) in GH1 the fields for {VP} and {Department}, as well as the formula used for the grouping.

Visual CUT would then let you drag these fields into the export file name option to dynamically control the excel workbook name, as well as the tab name within it, for each group.  For example:
-----------------------------------------------------------------------------------------
c:\temp\Info for {My_Table.VP_Name} Tab!{Department.Name}.xls
-----------------------------------------------------------------------------------------

If you download the user manual, there are two sections you may want to read:
1. Combining Excel Bursting Exports into a Single Multi-Tab Spreadsheet
2. Adding Excel Exports as Tabs in Existing Spreadsheets (Briefing Books)

Cheers,
- Ido
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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

679 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