Order by sum desc 1

[hanchilicious]

Hi,

I don't seem to have very much luck with anyone responding to me when I post. I hope if I try a different approach, I might be able to get better luck.

I'm using Crystal Reports XI release 2, and I would like to order my report by the desc sum of a group total.

GH1 - suppressed
GH2 - suppressed
Dtl - suppressed
GH2 - data with GH2 sums displayed
GH1 - suppressed

e.g.
GH1 Fruit
GH2 Apple 10
GH2 Melon 20
GH2 Pears 15

Crystal orders by GH1 and GH2 and then the fields within this order. I know you can base ordering in the 'change group' dialogue to be based on a formula.

I would like to know if it's possible to order by sum descending, in a final pass that prioritises this above group sorting.

e.g.
GH1 Fruit
GH2 Melon 20
GH2 Pears 15
GH2 Apple 10

Thank you

 

[Madawc]

Take a look at Top n

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[hanchilicious]

Nice.