Parameter with multiple values

[kris_talikowski]

In paginated report. I have a parameter with multiple values people type in. When I say in array =Parameters!ReportParameter1.Value(0) it displays first value. I need to change hardcoded array to (1) to display the second value from parameter. Can I build an array that displays in rows all values people type in parameter? =Parameters!ReportParameter1.Value() does not work. Your help would be appreciated.

[kris_talikowski]

Thanks for your reply. By using join, I'm getting parameter values in one row like value 0, value 1, etc.

What I'm looking for, is to populate a table or a matrix and have parameter values listed in rows.  One value per row.

Regards

Kris

[v-easonf-msft · Accepted solution]

Hi, @kris_talikowski 

You can try the solutions mentioned by Jayvee and Luca Rusin in this thread.

SSRS multivalue parameter to multi-row table 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[kris_talikowski]

This is a very helpful solution. Much appreciated. I still have some problems with populating in the table incremented by 1 values from the query dataset but this might be another issue.

[v-easonf-msft]

Hi， @kris_talikowski 

You can refer to this thread to display all the selected value of  multi value parameter in SSRS report.

Display Parameter(Multi-value) in Report 

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

Best Regards,
Community Support Team _ Eason