Crystal Reports - Sorting

[mickysavage]

Trying to sort my report of client details by highest page number first followed by next highest

Eg. 1st Client XYZ 10 pages
2nd Client ABC 7 pages
etc
etc

Any help in achieving this would be appreciated

Cheers

[Pasvorto]

You may have to create an invisible filed which contains a count of the records per client. Then sort on that field descending.

[ducky]

Group by Client, as you probably already have. Insert a summary count of each detail record for your Client group. Then go into the Top N/Sort Group Expert and sort All based on Count for the Client group. This works in version 8, what version you have? try it in yours.

[mickysavage]

Cheers - that has worked!!

I'm on Crystal 7

Thanks for your help