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
Solved

Exporting crystal reports into excel individual workbook

Posted on 2004-09-08
4
690 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

792 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