1

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!

Mahlon Graham
  • 11
  • 2

1 Answers1

0

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

Community
  • 1
  • 1
SQLDiver
  • 1,948
  • 2
  • 11
  • 14