locked
Display specific chart based on selection of Filter drop-down value RRS feed

  • Question

  • Hi All,

    I have a report (rdl) in which we placed one filter drop down (multi value  selection) and 2 charts(Chart A, Chart B).

    One selection of filter values, the chart's data get changed.

    My need is that, when user select only one value from filter drop-down, chart A should get visible and if multi selection then Chart B should get display.

     

    Thursday, December 22, 2011 3:25 PM

Answers

  • Hey Nai,

    Here you go...

    Select your First Chat control >> Properties >> Hidden >> Write following expression

    =IIF(Join(Parameters!Parameter1.Value,",").Contains(" A"),false,true)
    

     

    Select your Second Chat control >> Properties >> Hidden >> Write following expression

    =IIF(Join(Parameters!Parameter1.Value,",").Contains(" B"),false,true)
    

    I'm joining parameter values as you are using multivalue parameter here.

    Let me know if you have any issues


    Thanks, Sandip Please "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    • Edited by Sandip Shinde Thursday, December 22, 2011 3:44 PM
    • Proposed as answer by Suhas Kudekar Friday, December 23, 2011 3:59 AM
    • Marked as answer by Zilong Lu Monday, January 2, 2012 7:34 AM
    Thursday, December 22, 2011 3:43 PM