sql server reporting services: multi-value Parameters 2005 Beta 2 -- sql server reporting services

You're in the

sql server reporting services

group:

multi-value Parameters 2005 Beta 2

Stephen
7/9/2005 7:19:06 PM

sql server reporting services: I am trying to use the multi-value feature in sql server reporting
services 2005 beta 2. The feature is in there but for the life of me I
don't know how to make it work. I have tried a dynamic select
statement, a plain old view, a sproc, but all return all the values,
not the ones selected in the drop down. Anyone know how to make these
work?

Re: multi-value Parameters 2005 Beta 2

Jéjé
7/10/2005 9:47:59 AM

what is your query?

a multivalue selection in 2005 produce a coma delimited list:
Cust1, Cust2, Cust3....
use this filter in a "in" statement:
select * from customers where custid in (@MultiSelect)

[quoted text, click to view]

Re: multi-value Parameters 2005 Beta 2

Stephen
7/18/2005 7:38:53 AM

Got it, thanks. The problem was stupidity on my part.

[quoted text, click to view]

Re: multi-value Parameters 2005 Beta 2

Jéjé
7/18/2005 9:14:56 PM

I do this too ;-)
so there is nothing stupid, but we just see a complex method where the
simple method works! ;-)

[quoted text, click to view]
Got it, thanks. The problem was stupidity on my part.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn