Parameter Display in Report: Display "Select All" rather than all selections

Dear Anyone,

We have reports in RS that includes a display of selected parameter values in the page footer of the report. When "Select All" is selected in the parameter, all parameter values are displayed in our page footer. We would like to rather display the words "Select All" rather than displaying all of the available selections when select all is selected. Is there a way to do this?

Thanks,
Joseph

If you know the number of parameters in the list, you could compare that number with the count of the parameter collection.
Example:

Set up a text box, and in the expression put:

=iif(Parameters!yourParameter.Count = yourCount, "Select All", Join(Parameters!yourParameter,", "))

That is what I have done. There could be a simpler way, I just haven't stumbled upon it yet!

BobP

|||If only theres a way to determine how many rows or records are returned by the dataset in the parameter.

Parameter = "Select All"

Hi,

I am trying to pass an url to my report. In that url I want to pass my multivalue parameter with "Select All" as the parameter value. The probelm is, I don't know what value should I pass in the url which will be equal to selecting "select all" in the reporting services. I hope I am making my self clear, I case you have any doubts please ask me.

Thanks,

-Rohit

Thanks Robert I got your reply. Now I have an Idea what to do.