Prev: Report Builder 1.0 Filter Prompts
Next: Page Break Separator Row
From: John Pratt on 27 May 2010 16:08
I just figured this out with SSRS 2008 (the following assumes you have two charts on one report - the source chart that you will click on and the target chart that will be modified based on the series value you click on in the source chart).

You need to create a parameter for the report that will be used by the target chart to filter its data and which passes the series value from the source chart. Create the applicable filter on the target chart using the new parameter. Then specify a Go To Report action for the series on the source chart that passes all existing parameters for the report plus the series value from the source chart in the new parameter.

This will rerun the whole report with the "new" parameter value, and batta-bing! The target chart now only displays the filtered data.

From http://www.developmentnow.com/g/115_2006_9_0_0_815225/Clickable-chartsgraphs.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/
 | 
Pages: 1
Prev: Report Builder 1.0 Filter Prompts
Next: Page Break Separator Row