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

 

[skrandel]

You really should ask this in a Crystal forum. This one is really for classic BO and XI.

Steve Krandel
Symantec

 

[Alundil]

Will do - thanks



-- Andy