Multi-Select Value dropdown "Select All" Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sumit - 13 Jan 2006 08:22 GMT

Hi,

I hava report (RDL) which is having a parameter called Plan Owner, i
want the facality of "Select All" in the dropdown, this i can achive
through setting the parameter as Multi-Value. But the problem is if the

user select "select all" from dropdown, i uses the IN claues, i want to

avoid the use of IN clause if the "select all" is selected in
Multi-value dropdown. How can i programatically write the dataset to
avoid "select all"?

What is the internal value of "select all" which it added automatically

in the multi-value parameter dropdown.

I can provide more info if needed.

Regards,
Sumit

Reply to this Message

Potter - 13 Jan 2006 18:18 GMT

This is my interpretation of the multivalue parameter.

The internal representation of a multivalue parameters is an array of
all the possible values for the parameter. So if your parameter has 3
values (A,B,C) if you do 'Select All', RS sees an array with values
(A,B,C)

The only way I know of to determine if someone has picked 'Select All'
is to test the array against the # of rows in the dataset populating
the parameters. It would look something like this:

=iif(Parameters!MultiValParam.Count = Count("datasetformvparam"), "",
"FIELD IN (" & join(Parameters!MultiValParam.Value, ", ") & ")")

Andy Potter

Reply to this Message

Melissa - 30 Jan 2006 20:46 GMT

Hi,

I tried the above solution but the count of my dataset always returns 0
even though there are records in there. Any suggestions?

=iif(Parameters!bus_group.Count = Count("business_group"),
"ALL",Join(Parameters!bus_group.Label, ", ") )

Thanks,
Melissa

Reply to this Message

FurmanGG - 28 Apr 2006 19:55 GMT

I ran into a similar problem in wanting to know if they had selected all
possible options. See the following for a further discussion, a feature
suggestion, and a workaround:

http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=dfec8
7e1-a34d-4ff8-a480-fb1f8d4160ea

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks,
> Melissa

Reply to this Message