Hi,

I was previously able to export data from Crystal Reports 8.5 to Microsoft
Excel 2003 where the information exported appeared in groups of customers
with two empty rows in between. I was then able to subtotal the numerical
data (using data subtotal, without sorting) & the subtotals would appear
directly below each group of customer data & leave the extra empty row
between the subtotal & the next group. For example,

ABT100 1.00
ABT100 2.00
ABT100 Total 3.00

ABT101 1.00
ABT101 1.00
ABT101 Total 2.00

When I did my export this month (following the exact same steps I always
have) the subtotals are now appearing differently; they now appear after the
two blank rows & then start on the new customer. For example,

ABT100 1.00
ABT100 2.00


ABT100 Total 3.00
ABT101 1.00
ABT101 1.00


ABT101 2.00

The only way I've been able to change this is by sorting the customer
numbers & then subtotaling which then eliminates all blank rows between each
customer group. For example,

ABT100 1.00
ABT100 2.00
ABT100 Total 3.00
ABT101 1.00
ABT101 1.00
ABT101 Total 2.00

Is there any way to get back to the original format?

Thanks,

Shelley