problem in ssrs parameter
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
May 27th, 2012 12:51pm
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 & "')
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2012 1:00pm
is not any suggestion?
May 27th, 2012 2:31pm
Hi Sabnam2012
Thanks for your posting
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))
Free Windows Admin Tool Kit Click here and download it now
May 27th, 2012 9:04pm