Multiple parameter values in expression

I know I have done it before (at a different company) but how do Include all of my multi selections in an expression for a report title? The parametercomes back
=Parameters!Branch.Value(0)> I know it's an array but can't remember how its done.
Laura2112Asked:
Who is Participating?
 
Megan BrooksSQL Server ConsultantCommented:
I don't know if I have seen this elsewhere, but I have code in my current reports to join parameter values or iterate through them. Here is an example of Join():

=Join(Parameters!ReportParameter1.Value, ", ")

This constructs a comma-separated list of the selected values of the parameter. You can also make a list of the selected parameter labels:

=Join(Parameters!ReportParameter1.Label, ", ")
0
 
Megan BrooksSQL Server ConsultantCommented:
A mult-value parameter returns an array of strings for Parameters!xxx.Value instead of a single string. You can join the strings in the array together using Join(), or for something more elaborate you could call a function in custom code that iterated through the array.
0
 
Laura2112Author Commented:
seems like solution I have seen before took the (0) into consideration and maybe have concatenated ',' somewhere in the expression instead of the array location. Sound familiar at all ?
0
 
Laura2112Author Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.