Exporting to Excel-Create new sheet on change of group

[HappyMoose]

I am trying to find a way of exporting a report to excel and have it create a new worksheet for each nominated change of group. There are 5 group layers and I want to do it on group 1.

Is this possible?

Cheers

 

[synapsevampire]

Not without external code, such as VB.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[IdoMillet]

If by "worksheet" you mean a different Excel file, My Visual CUT software can do this:

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

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com