Listing the count in order of highest to lowest 1

[DJWheezyWeez]

I'm using CR XI.

I have a report that lists the inks used on a job for printing labels. Currently it is grouped by ink and has a distinct count of the jobs for each ink. The end user has requested that this report lists the count in order of highest to lowest in order to determine which inks we use most/least.

Since I'm already grouped by ink to find the count and I can't group by the count, is there a way to list the job counts per ink in order?

Any help is greatly appreciated.

-DJWW

 

[Madawc]

Take a look at Top N

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP