Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Asif Sayed Reporting on Hierarchical Recursive data using Reporting Services RE: Reporting on Hierarchical Recursive data using Reporting Services

  • February 1, 2008 at 7:58 pm

    #774512

    Alum,

    Thanks for the reply. But, I am using reporting services 2005. I wish to set up three groups a top level profile group, a middle group which is recursive and a bottom group. It needs to look like this:

    Profile1

    -----Function1

    ----------Function1A

    ----------Function1B

    ----------Function1C

    -----Function2

    ----------Function2A

    User1

    User2

    User3

    User4

    Profile2 ...

    However, reporting services insists on displaying the data like this:

    Profile1

    -----Function1

    -----User1

    -----User2

    -----User3

    -----User4

    ----------Function1A

    ----------User1

    ----------User2

    ----------User3

    ----------User4

    ----------Function1B

    ----------User1

    ----------User2

    ----------User3

    ----------User4

    ----------Function1C

    ----------User1

    ----------User2

    ----------User3

    ----------User4

    -----Function2

    -----User1

    -----User2

    -----User3

    -----User4

    ----------Function2A

    ----------User1

    ----------User2

    ----------User3

    ----------User4

    Profile2 ...

    Any help you can give for doing this would be appreciated.

    Thanks.