SSRS 2008 R2 Dynamic filter a report based on chart click


  • Hi all

    I'm currently working on something which I've seen recently but can't figure out how it's done!

    I have a report with 4 charts, age break down, post code areas, gender split and number of orders.

    What I want to do for example is click the female chunk of the gender chart and have this limit all the other charts to just the female information. I then want to go further and click the post code area for example. So then the whole report is filtered by gender, then post code area.

    Essentially I want to click on any section of any chart and re-filter the whole report based on that selection, and I want the ability to do this multiple times.

    I'm pretty reasonable with BIDS and SSRS so a know it's going to be something around actions, parameters and filters but can't get my head around how best to take it forward.

    Thanks in advance!

    Saturday, September 21, 2013 6:24 PM