Just curious.  I have been asked several times to export a Crystal Report to Excel. The standard question I get asked is: Since we grouping by department, can you create a separate tab on worksheet - one for each department?  I politely ssay no. I have never seen anything that indicates to me that this is possible.  I was wondering if perhaps I might be missing something and someone could provide the guidance if it is possible.

There may be a third party solution.  We were looking into this at one time.  I do not remember what we found out.