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!