StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODrillthrough report in SSRS 2008 using parameter values from chart series?
text
Body
copied!<p>I'm in the middle of creating a Dashboard System for my company and it consists of Excel, Graph and Gauge Reports that are designed in <strong>Reporting Services 2008</strong>.</p> <p>I have a Pie Chart that contains the top 5 best Products and the number of Insured parties that are allocated to each of the Products. I want to enhance this by being able to click on the Series Area (Product Description) of the chart and want it to open/un-hide another report that will display further display more detail about the selected product.</p> <p>How can this be achieved? I know there are expressions that can be used with javascript but I don't want to add stuff that I don't fully understand, plus I won't be maintaining this report project once it has been signed off to the client. This means that anyone who is to support this system would have to have all the skills I've used to make the report functional. </p> <p>I've tried by Creating the main report, then added a separate report that contains a parameter which stores a Product name. This is the filter for the data From the initial report I am able to add an Action setting to instruct the report to navigate to my more detailed report and by default it would need to pass the value of the item selected. </p> <p>My problem is that I'm not sure how to set the selected Series value I clicked on in order to pass it to the other report with the value of the product. How can I achieve this requirement?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload