I have been working on a solution for a while to get around the current limitations in SQL RS as it relates to passing multiple parameters to a report. I have created a stored procedure to handle the multiple parameters. I have developed a User interface in C# so the user can select multiple values from listboxes and I want to pass those values selected to the report. I have it working fine as long as the user selects one value, but once the user selects more than one value, the system does not recognize the values passed.

If I run the query in SQL RS development mode and pass in, let's say 1;2;3;4;, the report executes fine. If I set returnValues[i].Value = "1;2;3;4";, the report does not run. If I set returnValues[i].Value = "1", the report runs fine.

How do I pass multiple values in C#?

Any help would be greatly appreciated.

Do you have code in your report to parse the values from your concatenated list of parameters?

Another approach might be to specify one value per distinct parameter rather than specifying multiple values for a single parameter.

If I pass one value, it definitely works, but most of my reports will require multiple values passed. No, I do not have a procedure to parse the values. If necessary, I can easily create one. I was just hardcoding the values to see if it would work, and it does not.