1
votes

I have an SSRS report (report A) that currently generates a comma-delimited list of user ids based on a labor category. I'm trying to link report A to another report (report B), and pass that list of user ids (contained in a single field), to report B to use in its multi-select parameter 'User Id'.

The field value being passed from A to B is "1,2,3,4", etc., but when report B loads, the parameter drop down shows no value selected.

Is there a specific format the string needs to be in for the multi-select parameter to pick it up?

I've tried splitting the field, then using the JOIN() command, but no luck.

Thanks!

1

1 Answers

0
votes

CodeGrue's answer to a similar question gives a solution for passing multi-valued integer parameters:

Passing multiple values for a single parameter in Reporting Services