Hi I have an SSRS report that executes a stored procedure with several parameters. I need to make these parameters multi-value but I don't know how to do this. Even if I make the parameter multi-value but only send one value across I get a scaler variable error. Thanks David

Hello David, In your sproc add a filter condition like WHERE Parameter in (@Parameter) Hope this helps

Thanks for the response My filters are set as you describe. I think my problem is to do with how to format the parameter being sent. I have just created a simple procedure -'select * from <table> where<column>in (@Parameter)' When I execute it in SQL Server Console (as opposed to running a query to execute it) I can't work out the correct format to pass it multiple parameters. I get an error when I send 2 parameters separated by a comma Must pass parameter number 2 and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'. David

Hello, I think you have more than one parameters .Then You have to execute the sproc like sproc_name 'param1','param2','val1,val2,val3','param4' where parameter3 has multiplevalues.

Multi-value parameters are passed to SQL stored procs as a comma-delimited string of the values. You need to then parse this back into values in your stored proc. SQL does not support passing multiple values to a stored proc natively.

Aaron Meyers [MSFT] wrote: Multi-value parameters are passed to SQL stored procs as a comma-delimited string of the values. You need to then parse this back into values in your stored proc. This link demonstrates how to parse(split) a comma-limited string into a tableby applying table-valued function. Let us know if helpful.

I think you have to use the function join of reporting services, like join(X, "/") and if the parameter X have 2 values like "Bonjour" and "Test", join(X,"/")="Bonjour/Test"So you can use this in your procedure. Create a Dataset as text and concatenate the values as you want.DATASET:="execute MaProcedure "+join(X,"/")Hope it helps

Thank you all for your ideas. I'll have a go at the function. David

Hi folks It seems to be working now - many thanks to you all I created 2 functions as per above - 1 to handle integer and 1 for char values I set all my input parameters as varchar I turned the parameters in the report dataset to join(x etc). Running the dataset query directly did not need this but to run as a report it does Once again, many thanks David

This seems to be what i am looking for, can someone give me the syntax for the text command? ="execute MaProcedure "+join(X,"/") this does not work I am using SQL server 2008ThanksZafar

I implemented SQLUSA solution using hidden parameters. Please see report 'Multi-values parameters' from http://www.californiadreamhomesandland.com/Pages/ReportExplorer.aspx?ItmPath_25B7ED104E83=/English/Web%20Master/William but I use IN (@parameter) for report 'For test only'. Can't see a big difference. Alexei Cioina

David, I've exact same issue. could you pls. let me know how did you resolve this issue of passing multi parameters comma delimited. like 1,2,3SSRSRpt