Results 1 to 4 of 4

Thread: Crystal Reports - Sorting

  1. Aug 11th, 2004, 06:56 PM #1
    mickysavage
    mickysavage is offline

    Thread Starter
    New Member
    Join Date
    Jun 2002
    Posts
    14

    Crystal Reports - Sorting

    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
    Reply With Quote Reply With Quote
  2. Aug 12th, 2004, 07:20 AM #2
    Pasvorto
    Pasvorto is offline
    PowerPoster Pasvorto's Avatar
    Join Date
    Oct 2002
    Location
    Minnesota, USA
    Posts
    2,951
    You may have to create an invisible filed which contains a count of the records per client. Then sort on that field descending.
    Reply With Quote Reply With Quote
  3. Aug 12th, 2004, 09:03 AM #3
    ducky
    ducky is offline
    Addicted Member
    Join Date
    Jan 2001
    Location
    MPLS
    Posts
    187
    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.
    Reply With Quote Reply With Quote
  4. Aug 12th, 2004, 06:55 PM #4
    mickysavage
    mickysavage is offline

    Thread Starter
    New Member
    Join Date
    Jun 2002
    Posts
    14
    Cheers - that has worked!!

    I'm on Crystal 7

    Thanks for your help
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width