none
How do I sort within a group in a table in Microsoft Reporting RRS feed

  • Question

  • Hi all,

    How do I sort on a particular column (column B) with in a group (on column A).
    for e.g I add a new group and set the Group on : "Manager Id".  Now with in the Manager Id group I need the sorting to happen on say "Employee Id" field.
    I would presume I need to set the "Employee Id" in the "Sorting" tab of the "Grouping and Sorting properties". But that doesnt seem to work. Instead if I specify "Manager Id" in the sorting tab, then the group "Manager Id" is sorted in Ascending or Decending manner as specified.

    Out put required :
    Manager1
                     Employee1
                     Employee2
                     Employee3
                     Employee4
    Manager2
                     Employee5
                     Employee8

    Current Out put :
    Manager1
                     Employee3
                     Employee4
                     Employee1
                     Employee2
    Manager2
                     Employee5
                     Employee8

    Thanks and Regards, Vikram
    Friday, May 22, 2009 8:45 AM

Answers

  • Ok I was able to resolve this.
    I had to set the sorting option in the Group level (on ManagerID) and on the Table level i.e Table sorting the (EmployeeID).

    Cheers.
    Thanks and Regards, Vikram
    • Marked as answer by VNSuvarna Tuesday, June 2, 2009 10:09 AM
    Tuesday, June 2, 2009 10:09 AM