Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sorting on group summaries

Status
Not open for further replies.
Nov 23, 2006
22
GB
Hi, I'm very stuck here.
I have two columns in my report, grouped by the first column(defaulted in ascending order), and a percentage summary (worked out from GP 1 sum of a formula returning 1 or 0 in the details divided by a count of site)
I want to be able to present the report in highest percentage first - a bit like a league/results table.

EG.
Site Percentage
A 50%
B 70%
C 40%
D 100%

and I want it to look like this...
Site Percentage
D 100%
B 70%
A 50%
C 40%

Does anyone know how to do this?

Thanks in advance.

Charlie
 
It depends upon your CR version. You should be in forum149 or forum767. Please repost there and identify your version.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top