Search code examples
sql-serverssrs-2008reporting-services

SSRS: Is it possible for an action to load a subreport?

I want to have users click on a column of a histogram and have that action load a subreport contained based on an attribute of that column.

This would make SSRS reports a bit more interactive and a lot more useful.

I noticed that when specifying actions, we get the following dialog which has "go to report" but not "load subreport".

Maybe there's hope in "Go to URL" and javascript?

enter image description here

Solution

  • The answer is no, it is not possible to re-load a subreport based on a click using SSRS.

    Several people mentioned this to me in different places: @cadrell0 says:

    SSRS posts when ever you click on anything, such as sorting tables or toggling hidden items. This leads me to believe you cannot use javascript to interact with it

    On twitter, I get the simple, straightforward advice:

    Subreports in SSRS don't work that way. See Summary of Characteristics here - http://bit.ly/v0erHi

    In general, If you want a more interactive experience, you need to do web development or find another solution that is not SSRS. A Microsoft solution that looks promising is Power View. It comes out soon and it may provide a better way to explore data.