June 29, 2009 at 10:19 am
Hi there,
Trying to work on learning SSRS and after doing Crystal for 10 years I'm running into what are probably translation issues of my crystal knowledge to SSRS.
I have a report that runs a stored proc with two values that return. A category value and a count of the category in the specified time range.
What I want to do is make the pie chart clickable so that if you click a slice, it runs a sub-report and passes the pie slice field in as a parameter to a details stored procedure and displays the resulting output below the piechart.
I figured out how to link the pie chart to seperate report, I just want to make that seperate report part of calling one and not have it pop another one up, but I'm stumped.
any tips?
June 29, 2009 at 1:37 pm
Hey Mark,
So you have the sub-report set on your main report? It's not clear whether you got the pie slice to relate to 'another report' (ie not a subreport and therefore fires to a different report/page) or hooked to the subreport and there is an issue making this show.
Steve.
June 29, 2009 at 3:08 pm
stevefromOZ (6/29/2009)
Hey Mark,So you have the sub-report set on your main report? It's not clear whether you got the pie slice to relate to 'another report' (ie not a subreport and therefore fires to a different report/page) or hooked to the subreport and there is an issue making this show.
Steven,
What I wanted to do was to hide the subreport until the pie chart is clicked. When that happens I want to display the subreport and pass the values used to generate the pie graph to a sub-reports stored procedure along with the slice of the pie that was clicked. I want to do this without having to launch a different report instance (i.e. show the sub-report portion on the page below the graph for the piec slice clicked, while still displaying the entire pie above it so that another piece can be clicked to display a different subset of the data.
April 14, 2010 at 2:59 pm
Did you every get this to work? I'm working on the same issue now...
Thanks
-WM
April 15, 2010 at 7:17 am
I'm not saying this will work but did you try this?
Click on your graph, then right click on the little rectangle that represents the values displayed in your graph. Select Properties. On the Action tab, you can set a Jump to Bookmark. This will enable the click on a pie section to jump to another area of your report. I'm not sure how you'd manage making it dynamically visible, but maybe this is a start?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply