Difficult Sorting Question

[Alundil]

Oracle 8i datasource
CR 9 Pro
ODBC connection

Report has two levels of grouping: one for Surgical service and the other for primary surgeon.

Crystal defaults the sorting to the group levels first. There are some calculated fields in the second group that count the # of cases that a particular surgeon has completed. The user would like to surgeon group sorted by highest # of cases instead of alphabetically by name (which is default because of the group being on the surgeon field itself).

What I'd like to know is if there is a way to group using the results of a summary. Or do I need to right a specific formula to accomplish that and have "fake" group look at it?

Thanks,

Andy






-- Andy

 

[bdreed35]

Once you have a group created, and at least one summary in that group, you can use the Group Sort Expert.
Look under the Report menu for the Group Sort Expert.
Use the ALL option in the first drop down, then pick your group and summary field if it doesn't default to the one you want.

~Brian