Results 1 to 2 of 2
  1. #1
    jokeboy1 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Dec 2014
    Posts
    6

    Is it Possible to Sort after Grouping and Hiding Details in a Report?


    I created a report and grouped and total the records by category. After adding total, I hid the details to display only the total of each group. However, using the method, I'm unable to display the group totals in descending order.

    Is there any way to do this?

    Thanks for your help!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,526
    no, all sorting is done IN the report, in the sorting bands.

    But, you may be able to use 2 sub reports tho. 1 sorts 1 way. The 2nd sorts a different way.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. if report qty is empty hide all details
    By mathanraj76 in forum Reports
    Replies: 4
    Last Post: 06-11-2013, 12:07 AM
  2. Reports Grouping Totals in details
    By slatterie in forum Reports
    Replies: 1
    Last Post: 01-27-2012, 07:10 PM
  3. Hiding an Empty Sub-report
    By ophirw in forum Reports
    Replies: 16
    Last Post: 10-04-2011, 09:37 AM
  4. Hiding checkbox on report
    By bluezidane in forum Reports
    Replies: 2
    Last Post: 06-29-2011, 12:46 PM
  5. report grouping and sort
    By Meccer in forum Access
    Replies: 1
    Last Post: 01-05-2011, 08:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums