I have a table in my RDLC file. I want to change the text of its on column based on a value. I tried something like this:
=iif(First(Fields!IsMemberOfHousehold.Value, "DSClientContact")=false,"Yes","No")
but this sho开发者_Go百科ws No in all rows of that column whereas I have a True and a False in DB. And it must show one Yes and one No.
The thing I want to do is when First(Fields!IsMemberOfHousehold.Value, "DSClientContact")
returns True, I want to show "Yes" and if it returns False, I want to show "No".
Any help please ...
try this;
=iif( CBool(First(Fields!IsMemberOfHousehold.Value, "DSClientContact"))=false , "Yes", "No" )
精彩评论