Displaying Multiiple Parameter values on report

Hello Experts,

How can I display the values selected in the Report Parameters on my report. For example, my report allows users to filter by one or all Districts. In a textbox on my report I have the following espression:  

=Parameters!District.Value(0)  

If I select only one district I am okay. That one district will be the first value in the parameter array (0). However, if I select more than one mult-value array item I still only get the first item in the array (0).

How can I display  on my report both District.Value(0) & District.Value(1) if two values are select for example.    

Any help would be most appreciated.

Thanks!

shogun5Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
PFrogConnect With a Mentor Commented:
You can use "Join"
i.e.
     =Join(Parameters!District.Value,", ")
will give you a string consisting of
"Val1, Val2, Val3" etc.
0
 
shogun5Author Commented:
PFrog,
Yes, that works perfect!
Thank you!
0
All Courses

From novice to tech pro — start learning today.