<div>
This is the only tool that I know of that can do this for you:<br />
<br />
<a href="http://www.milletsoftware.com/Visual_CUT.htm" rel="ugc">http://www.milletsoftware.com/Visual_CUT.htm</a><br />
<br />
Other than that, yo uwould have to write the code yourself I am afraid.
</div>


This is the only tool that I know of that can do this for you:

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

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

<div>
Ido's software is excellent. &nbsp;He's a nice guy, too:-)
</div>


Ido's software is excellent.  He's a nice guy, too:-)

<div>
I agree with what bdreed said - you can't do it with Crystal only - here's the &quot;workaround&quot; that Biz Objects recommends: <a href="http://support.businessobjects.com/library/kbase/articles/c2014059.asp" rel="ugc">http://support.businessobjects.com/library/kbase/articles/c2014059.asp</a><br />
<br />
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.<br />
<br />
Visual Cut is a great tool and well worth the money.<br />
<br />
frodoman
</div>


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 [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

<div>
<div class="content wysiwyg-content">
I need to take the groupings from Crystal and put into separate workbooks and worksheets within the workbook. &nbsp;<br />
<br />
Example: &nbsp;I have a sort by VP, Company, and Department with associated employees in Crystal. &nbsp;I want to export into Excel in workbooks by VP and worksheets by Department.
</div>
</div>


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.

Exporting crystal reports into excel individual workbook

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.