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

76719856 40 Reputation points
2023-05-30T21:54:22.5066667+00:00

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)

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,867 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,416 Reputation points Microsoft Vendor
    2023-05-31T01:56:54.9133333+00:00

    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:

    1

    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

    0 comments No comments