Pass multi-valued parameters to another SSRS report

Per Microsoft documentation for SSRS, it’s possible to add an action to an object that will allow you to jump (drillthrough) from one report to another. This can be useful if you have multiple reports that form a logical group & you want users to be easily able to navigate between them.

What’s even more useful is that you can pass parameters from the first report to the next one. This is easy to do with single-valued parameters by following the instructions in the Microsoft documentation, however if the parameter is multi-valued, you will find that only the first value is passed. There is an easy fix for this (once you know the correct syntax).

Right-click the object you want to add the action to & click Properties. In the “Go to report” section of the Action tab, paste the following into the Value’s expression & replace <ParameterName> with the name of the multi-valued parameter.

=SPLIT(JOIN(Parameters!<ParameterName>.Value,","),",")

This expression will pass multi-valued parameters from one report to another whether the user chooses all values, a subset or a single value.