locked
SSRS ignores sort in a recursive hierarchy RRS feed

  • Question

  • I've got a SSRS report that builds a recursive hierarchy using the Recursive Parent property. I need to sort by a field in the dataset (not interactive sorting, just plain sorting). I've set it on the Details group but Reporting Services won't do the sort.

    If I remove the recursive grouping and return it to a flat dataset, the sort works as expected, so I know it is because of the hierarchy. Anyone else ever run into this?

    • Edited by Adam Neal Wednesday, February 15, 2012 9:51 PM grammar
    Tuesday, February 14, 2012 9:50 PM

Answers

  •  

    Hi Adam,

    Thanks for your post.

    Please note that the hierarchical recursive data are definitely come from the same the same dataset field, whenever you specify the recuisive hierarchy on the relevant talix column, the column data would show according to the Prarent-child relationship hierarchy, how you can force this column to show according to the special sorting order.

    Eg: The Data in your DataSet

    Employee

    ReportsTo

    Position

    A

    Null

    President

    B

    D

    Sales Employee

    C

    F

    IT Employee

    D

    A

    Sales Manager

    E

    D

    Sales Employee

    F

    A

    IT Manager

    Recursive Hierachy showing on your Report:

    Level 1

    Level 2

    Level 3

    A

    D

    B

    E

    F

    C

                   

    Thanks,
    Bill Lu


    Bill Lu

    TechNet Community Support

    • Marked as answer by Zilong Lu Friday, February 24, 2012 4:42 AM
    Friday, February 17, 2012 11:08 AM