How to sort by group totals 1

[mgpeters]

Working with CE/CR 10, Oracle direct connect.

I am attempting to do a rather simple report but am having problems. The report shows the number of incidents reported in 2 diff. project phases. I want the projects with highest totals to show at top. What I want to achieve is something like ...

PROJECT PHASE1 PHASE2 TOTAL
NAME INCIDENTS INCIDENTS INCIDENTS
Expo 90 50 140
ICE 30 70 100
Alpha 50 10 60

Instead (because I'm grouping first on Project to total up the incidents), I get ...

PROJECT PHASE1 PHASE2 TOTAL
NAME INCIDENTS INCIDENTS INCIDENTS
Alpha 50 10 60
Expo 90 50 140
ICE 30 70 100

Any suggestions???

Thanks

 

[Madawc]

Try Top N

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

 

[mgpeters]

Beautiful! Thanks much!