Menu
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?
691
Subreports and drillthrough reports are both separate reports, so they're stored external to the main report. Subreports can be on the same or a different report server, but drillthrough reports must be on the same report server. Nested data regions are part of the main report.
A subreport is a report item that displays another report inside the body of a main paginated report. Conceptually, a subreport in a report is similar to a frame in a Web page. It is used to embed a report within a report. Any report can be used as a subreport.
What Is Drill Through? A drill through is an analytical feature that allows you to visualize additional, more detailed information about a specific KPI in a report. The difference with a drill down is that in a drill though report the new data is opened in a pop-up and not on the same chart.
Well, sort of. You could set the Go To Report function to go to the Parent Report (back to itself), and pass a parameter that updates the subreport. Not elegant, but it works. I've used it to create a tabbed "form" and use the "tabs" to switch out the subreport below.
62
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
