SSRS: How to use custom IDs instead of index values in multi-value parameters?

Question

I'm trying to pass the custom Id in multivalue parameter.Basically by defualt multivalue parameter accepts only index like 0,1 and its return data on base of that index but my current SSRS requirement that to use the custom ID in multivalue paramter.

This is the default expression of mulitvalue paramter to get value of lable.

= Parameters!multivalue.Label(0)

I tried this, but it doesn't work:

= Parameters!multivalue.Label(textId)

Answer 1

Hi @76719856

What is your custom ID referring to? If you want to get data based on the id entered in the report, then you can follow the steps to create a multi-valued parameter, and then enter the id at runtime, like this:

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-multi-value-parameter-to-a-report?view=sql-server-ver16

Best regards,

Aniya