Subreport Grouping Sort Override

[LLowrance]

CR 8.5
SQL database

I have a SUBREPORT that is gathering productivity detail grouped by Claim# and employee. There is a sum of dollar amount billed on the employee grouping. I need the name of the employee to display but sort DESC on the Sum of dollar amount. Is there a way to override the "sort" of a grouping using a summary field?
Example:

GH1-Claim#(suppressed)
GH2-Employee(suppressed)
D-Charge date, amount (suppressed)
GF2-employee, Sum(amount)
GF1-Claim# (suppressed)

I have a similar override working in the main report. Is it simply not possible in a subreport?

Thanks,

-LLL

 

[lbass]

You can use a group sort in a subreport just as you can in a main report, but the group sort must be activated by right clicking and inserting a sum on the amount field in the detail section at the group level. Then go to report->topN/group sort and select "all" and the summary as your sort field.

-LB