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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics