June CTP - Multi Value Parameter

I have a string report parameter with Multi-value checked. The multi-value list generated does not contain quotes around each string values. Is there a simple way to accomplish this? I want to include this list in the IN of the WHERE clause.

Thanks,

[252 byte] By [KKaps] at [2007-12-16]
# 1
You don't need to add single quotes to string parameters. It generates quotes by itself.
VectorR3 at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 2
Thanks! I was trying to use the Parameter in an expression for a dataset, but none of that is necessary, at least in my case. IN (@ParmName) works just fine.

Thanks for your help.

KKaps at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 3
I have been trying to pass the string values so that the

WHERE column IN (@param) works.

The only quotes that are generated are 'value1, value2'
where as the following are required 'value1', 'value2'

Is there a special setting somewhere to generate these quotes?

Help please

dipika at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 4

Is your query string an expression, i.e. starting with = sign ? If so, I think you are correct that the entire list is returned within single pair of quotes. However, when the the query string is not an expression, WHERE column IN (@param) worked just fine.

KKaps at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 5

I am actually trying to execute a stored procedure to populate the report.
So the dataset type is Stored Procedure instead of Text.
Therefore the parameters are passed in the expression format as you said.

How do I pass them otherwise?

Thanks

dipika at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 6
Stored procedures do not natively support a multi-valued parameter. You will need to pass a string and parse within the SP.
BrianWelcker at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...
# 7
Considering you have single quote to the left and right of the entire list, then you need this in your query

join(Parameters!parameterName.Value,"','")
draenk at 2008-1-23 > top of Msdn Tech,SQL Server,SQL Server Reporting Services...

SQL Server

Site Classified