• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3411
  • Last Modified:

Export CR to an Excel Workbook with multiple worksheets based on group

Hi!

   I need to export a Crystal Report into multiple worksheets within a single Excel workbook based on the report's highest level grouping.  Crystal's only published option is to do this manually by exporting each group to individual workbooks and combining them.  That's not an acceptable solution.  

  I  know there are programs out there that I can buy that will do this, but I'm doing this on my own and they're too expensive for me (over $40).  However, if you know of a freeware or very inexpensive shareware solution that will do this, please feel free to refer me to that.  But, please no trial versions of expensive programs.
 
   Thanks.  I know this has been a huge gap in Crystal for a long time.  I'm just hoping someone has a little, inexpensive program or add-in that will do this.

Thanks!
Karen Grube
<email address deleted by mlmcc PE>

   
0
klgrube
Asked:
klgrube
  • 3
  • 3
1 Solution
 
mlmccCommented:
Here is a program (a bit more expensive than you want) that allows you to try it to see if it does what you desire.

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

I realize the price seems high but consider how long it might take for you to build an application with this feature and what the true cost of the development is.

mlmcc
0
 
klgrubeAuthor Commented:

   I've looked at Cut.  You're right, it's too expensive.  I definitely have more time than money, so if anyone can point me to a sample of how to do this in VB.Net or to a freeware/shareware solution, I'd appreciate it.

   This has been so problematic for Crystal for so long, I'm really hoping someone has developed some kind of solution.

Thanks!
Karen

P.S.  Sorry about the email address.  I didn't realize.  Thanks for the tip!
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Just to set the record right, "CUT" cannot, but "Visual CUT" can, insert each group as a separate tab inside a single workbook.  

Cheers,
- Ido
0
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
mlmccCommented:
WHich version and edition of Crystal?

Do you have the ability and tools to build an application?  You can use VB, asp, etc.

My thought would be to build an application that exports the report to a spreadsheet but does one group at a time.

mlmcc
0
 
klgrubeAuthor Commented:

Yes, I know I can export to individual worksheets for each group by running CR from within VB once for each group.

What I don't know how to do within VB is take all of those spreadsheets and place each one as an individual worksheet within a new workbook.  However, that's probably out of the scope of this forum.

All I really need to know is if there's some freeware or shareware that will do this or if anyone can provide either some sample code or a link to sample code that will accomplish the goal of creating a single workbook with individual worksheets for each top-level group.

At one point, I thought I saw something like a user-defined function that would perform this task, but I can't find it any longer.   You included it in your report and passed to it the name and location of the workbook, and it automatically updated the workbook by creating a new worksheet for each group as the report ran  I think there may even have been a parameter that you set when you run the report that said "Export to Excel Workbook" rather than using CR's export function. But, I just don't recall how this worked exactly or what it was called.  If anyone knows of something like this, I'd appreciate a heads-up.

Thanks!
Karen
0
 
mlmccCommented:
Here is the Crystal answer (at least through CR9)

http://support.businessobjects.com/library/kbase/articles/c2014059.asp

mlmcc
0
 
klgrubeAuthor Commented:
Yes, I object to any accepted answer here.  I specifically said I was already aware of Crystal's answer and was looking for a good, INEXPENSIVE, alternative which no one provided.  Please close this with no accepted answer.

Thanks!
Karen
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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