Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simpleton
Starting Member
25 Posts |
 Posted - 2009-01-12 : 13:13:22
|
| Is it possible to use SSRS to query against MS Access and have the parameter be a multi-value paramater?Sort of like this:SELECT * FROM EMPLOYEES WHERE (Name IN (?)) I'm getting an error in SSRS:Cannot add multi value query parameter '?' for data set because it is not supported by the data extension.Thanks!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-17 : 02:54:56
|
| try like below and see if it works (untested)SELECT * FROM EMPLOYEES WHERE ','+ ? + ',' LIKE '%,' + Name + ',%' |
 |
|
|
stelban
Starting Member
1 Post |
Posted - 2010-05-06 : 14:40:58
|
| simpleton,Did you ever get a solution for using a multi-valued parm in MS Access? I have the exact problem. Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-07 : 13:31:49
|
| the above works in sql server. post in access if you need access related query------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Multi-Value Parameter in SSRS w/MSAccess?