hi i have a table with name ptncu in ab with this fields i create a multivalue visible parameter with name product family an this property

and the view of this parameter is i wanna each one of this value select, its row in db that have tue value shown i create a dataset and wrote this quary but doesnt work ="SELECT codeptncu "& "FROM ptncuinfo"& "WHERE ( " &Iif(Field!txthot.Value,"hot","")& "in'" &Parameters!productfamily.Label & "') or("& &Iif(Field!txtcold.Value,"cold","")& "in'" &Parameters!productfamily.Label & "')

Hi Sabnam2012 Thanks for your posting, I think you have already ask this question in another post but I am putting the reply here as well I have managed to put something together for you. Please do the following Right click on your tablix and go to tablix properties and go to filters optionAdd a filter and in expression please select hotOperator please select INIn expression please put the following expression =iif(instr(join(Parameters!productfamily.Value,","),1)>0 and instr(join(Parameters!productfamily.Value,","),2)>0 ,Fields!Hot.Value,iif(instr(join(Parameters!productfamily.Value,","),1)>0,true,false))You are done I am putting some screenshot for your help If you have any questions please do ask. ManyThanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful ---Filter Expression inside your tablix =iif(instr(join(Parameters!productfamily.Value,","),1)>0 and instr(join(Parameters!productfamily.Value,","),2)>0 ,Fields!Hot.Value,iif(instr(join(Parameters!productfamily.Value,","),1)>0,true,false))