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
Printable View
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
You may have to create an invisible filed which contains a count of the records per client. Then sort on that field descending.
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.
Cheers - that has worked!!
I'm on Crystal 7
Thanks for your help