Crystal Reports Group sort on summary field

Message

   Hi,

I'm working on another report now and have another question about sorting and groups.

This time the report looks like

Rep  Account  Jan-07 Feb-07 ... Nov-07 Dec-07 AccountTotal
08   AAAAA    500     263.45    0      0      763.45
08   BBBBB    0       100       0      0      100
     totals   500     363.45    0      0      863.45

06   CCCCC    450.50  230.10    0      0      680.60
06   DDDDD    1234    1110      0      0      2344
     totals   1684.50 1340.10   0      0      3024.60

And so on for the rest of the reps.
The grand total for each rep is a summary field.

I've got the report grouped by Rep and then using the group sort expert, sorted by the grand total.

This is nearly what I need. the only problem is that the summary field seems to be picking up on suppressed and non-suppressed fields. therefore some of the grand totals aren't correct and the sort order is wrong.

So i have a few questions

1) Is there anyway to get a summary field to ignore suppressed data?
2) Can I use any other type of field with group sort expert? (I've tried running totals and formula fields but it doesn't seem to like them)

If not does anyone have any suggestions how else to sort the data?

Thanks