Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 696
  • Last Modified:

Exporting crystal reports into excel individual workbook

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
mlofton
Asked:
mlofton
1 Solution
 
bdreed35Commented:
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
 
Kurt ReinhardtCommented:
Ido's software is excellent.  He's a nice guy, too:-)
0
 
frodomanCommented:
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
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now