Column SORT problem

[syncdba]

Hi,
I have a report with columns:
Name Amount Probability
jack $45678 67%
jill $23567 89%
make $458900 90%
I have one GROUP BY name with a Drill-Down.if you drill down it will give you Name information..
I'm trying to get GROUP BY name(only for Drill-down purposes) & SORT BY Probability..LIKE:I tried alot & I'm not sure if its possible.

make $458900 90%
jill $23567 89%
jack $45678 67%

 

[lbass]

What version of CR are you using? What is the formula for probability (please show the contents)? What kind of summary is "Amount"? Please explain.

-LB

 

[syncdba]

I'm using CRXI, There is no Summary in this report. Name,Amount,Probability all are direct records from the DB tables. On First I have to show these 3 values & then drill down for futher information on Names(like city,state..).I'm getting this but now I need this report with Probability DESC.

 

[lbass]

Insert a maximum on Probability on your detail field at the name group level and then go to report->group sort->choose "maximum of Probability", descending.

-LB