Post reply

multi value parameter - need to know when All or None are selected

  • June 25, 2010 at 7:44 am

    #222665

    Hi,

    using SSRS 2005, I have a multi value parameter on my report and I would need to know whether the user has selected all values or none, in order to omit the parameter in my code because if they select all or none, I have to include rows that have null in that particular column in the table. Is there a way I can do that?

    Any suggestions are welcome!!

    thank you!

    -nicky

  • November 30, 2010 at 9:45 am

    #1256866

    When referencing the parameter, try using .count instead of .value. It is possible to compare this with the 'count' of records returned by the query used to populate the paramter in the first place if you need to know whether all have been selected.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply