all groups > sql server reporting services > june 2005 >
You're in the

sql server reporting services

group:

Parameter lists


Parameter lists McGeeky
6/22/2005 12:27:35 PM
sql server reporting services: In my data set I want to use a where clause with IN. E.g where name in (
'a', 'b', 'c')
But I don't want to hard code the list I want the user to enter it as a
parameter. Does SSRS support parameter lists?

where name in ( @names )

--
McGeeky
http://mcgeeky.blogspot.com


Re: Parameter lists Jens Süßmeyer
6/22/2005 2:21:28 PM
I am aifraid, since now NO, but there will be an option in SQL Server 2005.

--
HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---
"McGeeky" <anon@anon.com> schrieb im Newsbeitrag
news:uK5sv3xdFHA.2880@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button