Output Multivalue Parameters

I'm trying to output all the values selected through a multivalue parameter, but I am having difficulties. In the text box, the parameter contains only four member functions (value, label, count, ismultivalue). However, to output a value or label for the parameter you need to specify an index in the form of:

Parameters!Names.Value(0)

Ideally, I would like to be able to obtain all these values with a function call, but it doesn't look like there is one. Any ideas of how to get all the values

Thank you!!

Answer this question

Output Multivalue Parameters

David Emigh
Try JOIN(Parameters!Names.Value, ",") to get a comma seperated list.
yves_teissier

Hi. I have been trying to get this to work. I am fairly new to reporting services. This is what I need, but I am not exactly sure about where to put this function/expression. Do I leave the textbox properties as is and hve this as my initial expression or do I keep the Field as the textbox data and use this function to filter on Please advise. Thanks, in advance.
Duncan R. Campbell
Yep, that works perfectly.

Thanks for the fast reply!!
Output Multivalue Parameters

Answer this question