Pass Multiple Parameters from C# to SQL RS
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.