In reporting services, multi selecting filter works as an OR.

How do we get an AND affect using reporting services?

Users would like to choose options like

1. sales where product 1 is sold
2. sales where products 1 or 2 are sold
3. sales where products 1 and 2 are sold

Points 1 and 2 are the usual select, but for 3 -

how do we provide the user a facility to select this in the report. Can we
put in something in the cube for this?

tia

--
Message posted via http://www.sqlmonster.com