November 16, 2016 at 8:45 pm
Hello,
I'm just getting started with SSRS so I maybe this is a simple beginner question.
I have created two pie charts, that provide information on two different locations, what I'd ideally like to do is have it so the user clicks on the pie chart that represents Location A, and starts to go down a road of reports relating to location A, and likewise on the Pie Chart that represent Location B. Can I assign a different action for each pie chart?
Also, is it at all possible to click on a section of pie to go through to a report on that particular section?
I am using VS 2010, SSRS 2012.
Thank you for any help and guidance.
Kind regards,
D.
November 17, 2016 at 2:25 am
Yes, you can assign different actions to different pie charts.
If you right click the series you want to amend, either on the pie chart, or in the Values panel on the Chart Data pane, and select Series Properties. Then select the Action Panel. You can then pass any parameters you want to, and any values from the dataset you've click.
For example, if you have a report which has the parameters DateFrom and DateTo, and your Pie is showing Sales figures for "New Business" (Green), "Renewals" (Blue), and "Transfers" (Yellow) you could set your action for clicking the Green part of the chart (New Business), to go to a drillthrough report. The drillthrough report would need 3 parameters DateFrom, DateTo and something like SalesTypes, which would have the values [@DateFrom], [@DateTo] and [Salestype] (not this is a field value, not a parameter) passed to it from the parent report.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2016 at 4:13 pm
Thank you Thom, that was exactly the answer I needed, plus a little extra that will help me down the line.
While on a winning streak, I wondered if you might be able to tell me out to get datapoint lines on the pie charts? As I may be using the wrong words to describe what I'm going on about, I mean I can get the data labels to display on the outside of the Pie Chart, but I cannot find the 'option' of have a line that kind of underlines the number then goes to the relevant segment.
I have Googled this and I find lots of sites/videos to do this in Excel, but not in SSRS. The SSRS ones I find only tell me how to get the numbers on the outside of the chart. I'm starting to think these are not available in SSRS 2012, but surely they are somewhere?
Thank you for your help.
Kind regards,
D.
November 18, 2016 at 2:07 am
I'm pretty sure that for these SSRS makes a decision. I don't think you get much choice in it if I'm honest.
I don't make a massive use of Pie charts (I think I might have one or two over our entire resposititory), so I'm not sure. I had a look at one and couldn't see anything immediate that suggested how to do it.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply