Managing Recursive Group on SSRS Reporting Services Reports

Question

Post reply

Managing Recursive Group on SSRS Reporting Services Reports

Mohamed I.

SSCrazy

Points: 2774
More actions
November 5, 2019 at 12:00 am

#3690768

Comments posted to this topic are about the item Managing Recursive Group on SSRS Reporting Services Reports
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

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

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

Paul Novelli SSC Enthusiast Points: 162 More actions · Answer 1

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

Jeff Moden SSC Guru Points: 1004309 More actions · Answer 2

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.

Change is inevitable... Change for the better is not.

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

Mohamed I. SSCrazy Points: 2774 More actions · Answer 3

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 More actions · Answer 4

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: 1004309 More actions · Answer 5

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.

Change is inevitable... Change for the better is not.

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