Can you help me with this expression?
=iif(Fields!BILLSEPARATE.Value=-1,Fields!SERVICENUMBER.Value,
"")
I want to see the values of servicenumber only if the billseparate value=-1 when i run this expression it gets blank... nothing.. However i do know there are 4 rows .. Can someone tell me..
what am i doing wrong?FM
October 17th, 2011 3:43pm
Try this -
IIF(Fields!BillSeparate.value = "-1",Fields!ServiceNumber.Value,"")
Hope this Helps!
Free Windows Admin Tool Kit Click here and download it now
October 17th, 2011 3:47pm
Thank you for the TIP... but it not working for me .... i still get the textbox blank...FM
October 17th, 2011 4:57pm
Hello Farhan1,
Try using
=IIF(cint(Fields!BillSeparate.Value) = -1, Fields!ServiceNumber.Value, Nothing)
Hope this helps.
Sammie
Free Windows Admin Tool Kit Click here and download it now
October 17th, 2011 5:08pm
I can run the report and in the preview i still see a blank textbox....FM
October 17th, 2011 5:31pm
Try:
=IIF(trim(cint(Fields!BillSeparate.Value)) = -1, Fields!ServiceNumber.Value, Nothing)Sammie
Free Windows Admin Tool Kit Click here and download it now
October 17th, 2011 5:33pm
Try this :
=IIF(Fields!BillSeparate.value = "-1,"",Fields!ServiceNumber.Value)Cheers!! Sumit
October 18th, 2011 1:08am
Try this :
=IIF(Fields!BillSeparate.value = "-1,"",Fields!ServiceNumber.Value)Cheers!! Sumit
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2011 7:48am