Multi Value Parameter Select All change value to Null RRS feed

  • Question

  • Hi All,

    I'm using Visual Studio 2010 and I'm writting a report with multi value parameters.

    My Problem is when a user ticks the SELECT ALL option in the multi value list I want to pass null to my stored proc instead of all the values.

    Is there a way to do this in SSRS ???


    Thursday, March 29, 2012 10:51 PM


  • Unfortunately not that I know of.

    Usually when you have a special condition around a multiselect list, such as also giving the option of searching on nulls, in your values you have to union all on a choice at the end


    SELECT Value, DisplayText

    FROM MyList


    SELECT -1, '-No Value-'

    Then search for that option in your stored procedure.  Otherwise you have to look at user control issues such as leaving the field blank.

    Best Wishes, The Redman; If something helps, please help show it by voting, if it solves, bonus!

    • Marked as answer by ChristosA Thursday, March 29, 2012 11:02 PM
    Thursday, March 29, 2012 10:58 PM