locked
Multi Value Parameter Select All change value to Null RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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 ???

    Thanks.

    Thursday, March 29, 2012 10:51 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

    eg

    SELECT Value, DisplayText

    FROM MyList

    UNION ALL

    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