Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2002
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping; Sorting by grouping name (2002)

    Hello,

    You have all been so helpful I am sure this too is a no brainer. How can I sort my report by the name that appears in the Grouping level. For instance, I have my report grouped by department and then sorted by name, title etc. I want the report to sort by department, which is the only grouping level. How can I do this? It appears to be using the primary key to sort ascending but there must be a way to sort by department name? Hope this makes sense [img]/forums/images/smilies/smile.gif[/img]

    K

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping; Sorting by grouping name (2002)

    Is the Department Name in the Group Header? If so, in the Report design view, on the ToolBar, click on the Sorting and Grouping icon and Enter the Department Name in the first row of the Field/Expression column. The Sort Order is the second column. Click OK and the sort order will take effect.

Posting Permissions

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