multiple select in reporting services

[akalinowski]

is there a way i can have reporting services allow me to select more than one value for a variable, almost like a where in clause?

would that work properly

like this

select style, department, onhand
where department in (@dept1)



akalinowski

http://www.olivelabs.com

 

[xlbo]

In SSRS 2005 and above a parameter should have a multiselect property which should allow the SQL to work excactly as you have described

In SSRS 2000 you would have to fudge this

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question