Managing Recursive Group on SSRS Reporting Services Reports

  • Mohamed I.

    SSCrazy

    Points: 2774

    Comments posted to this topic are about the item Managing Recursive Group on SSRS Reporting Services Reports

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

  • Paul Novelli

    SSC Enthusiast

    Points: 161

    Nicely done with all the screenshots.  I did not know you could do that with SSRS.

  • Jeff Moden

    SSC Guru

    Points: 994867

    Hat's off to you.  I don't use SSRS but this looks like a really well thought out article with the correct order of revelation and all the right screen shots.

    The only thing missing is performance.  Have you tried this on a, say, 100,000 node hierarchy?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Mohamed I.

    SSCrazy

    Points: 2774

    Hi I am glad you appreciate the article

    Thank you for your comment

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

  • Mohamed I.

    SSCrazy

    Points: 2774

    Hi

    Thank you for your compliment

    This will encourage me writing more article 🙂

    It's good question about performance in large dataset when using recursive group

    It will be nice to make some performance test

    I have already developed report with about 5,000 lines with no big issues

    But for more than 100,000 it will be hard for SSRS to manage this. Maybe by doing some pagination.

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

  • Jeff Moden

    SSC Guru

    Points: 994867

    Mohamed I. wrote:

    Hi

    Thank you for your compliment

    This will encourage me writing more article 🙂

    It's good question about performance in large dataset when using recursive group

    It will be nice to make some performance test

    I have already developed report with about 5,000 lines with no big issues

    But for more than 100,000 it will be hard for SSRS to manage this. Maybe by doing some pagination.

    Perhaps combining SSRS with a little T-SQL would go a long way.  Please see the following article (and its predecessor)...

    https://www.sqlservercentral.com/articles/hierarchies-on-steroids-2-a-replacement-for-nested-sets-calculations-1

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply