Hi, Thanks for your answer. I have two dropdown list in SSRS. Second one depends on first list parameter. So that second one is disabled when first one is null. But the problem is when i select a single item from the first list, data comes in the second list based on the first parameter. But when select Two values next , the second list has the values but not selected( not checked). only the previous data is selected. Could you give solution as soon as possible?
October 21st, 2010 7:45am
Hi, The dataset queries used should have IN operator in the where clause, like the following: select Col1,Col2 from Tbl1 where Col1 in (@Mypara) thanks, Jerry
October 25th, 2010 7:45am