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>

   
klgrubeAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Here is the Crystal answer (at least through CR9)

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

mlmcc
0
 
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
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
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.