all groups > sql server reporting services > july 2005 >
You're in the

sql server reporting services

group:

Multi value "Select All"


Multi value "Select All" deepu_t NO[at]SPAM hotmail.com
7/31/2005 6:34:35 PM
sql server reporting services:
Hi all

I have a multi-value drop down list as my report's parameter.
Once the report is executed with the selected parameter, I am
displaying the selected parameter also as a part of the report's
results.

Is there a way I can display the word "All" in the report results when
the user selects "Select All" of the report parameter?

At present it shows a long list of concatenated values of the drop down
list.

Thanks heaps
Re: Multi value "Select All" John
7/31/2005 9:37:30 PM
I might be misunderstanding you, but you can display the parameter
label that is selected: Parameter.label instead of parameter.value
Re: Multi value "Select All" deepu_t NO[at]SPAM hotmail.com
7/31/2005 10:37:38 PM
I am sorry if my question was not clear.
I tried Parameter.Label, but gives an error if the parameter is a Multi
Value type.
So, one has to use Join(Parameter.Label,",").

This displays a list of all the paramters that were selected.

What I want is, if the user selects "Select All" instead of showing the
list of parameters, i should be able to display the word "All".
Does this make sense?

Thanks
AddThis Social Bookmark Button