SSRS Multi Value Parameter. Check whether "Select All" is selected

reporting-services parameters multivalue
Sathya picture Sathya · Feb 1, 2012 · Viewed 54.4k times · Source

I have a multi value parameter in my SSRS Report. I want to find out whether (Select All) is checked in that parameter.

In other words, whether all the values in the parameter are checked or only some values are checked.

Is it possible?

I am able to find out number of selected values through Parameters!Parameter.Count. Is there a way to find out total of items in that parameter?

Answer

Merr Leader picture Merr Leader · Feb 12, 2013

In case anyone is still having issues doing this, I just coded this easy fix.

=IIF(COUNTROWS("dataset").Equals(Parameters!parameter.Count),"it is equal","this is not equal")

Related questions

Passing multivalue parameter to a subreport

I'm having a problem when working with multivalue parameters between reports. I have a main report in which I have defined a multivalue paramer, which I use to run a SQL query to populate its dataset. The parameter is used …

Read More
Using SSRS Expressions to see which options a user has selected from a multivalued parameter?

I'm trying to set up a filter against a "Totals" column in an SSRS report using an expression for the field. I have a multivalued parameter setup with the values value1, value2, value3, and value4 as options. Before the filter, …

Read More
Passing multiple values for a single parameter in Reporting Services

I have several Multi-Select parameters in my report. I am trying to find a way to pass in multiple values for a single parameter in the web query string? If I pass in a single value, it works fine. The …

Read More