using OR in IIF statement...RDLC
34,909
you should be able to concatenate the field values and test for the empty string instead of testing each value individually.
try
IIF(Fields!A.Value & Fields!B.Value = '',true,false)
for either empty returning true, try:
IIF(Fields!A.Value ='' or Fields!B.Value = '',true,false)
Author by
marek
Updated on July 09, 2022Comments
-
marek almost 2 years
Please can you someone help me? My question is :
How to use properly OR in IIF statement in RDLC report?
Both Fields!A.Value and Fields!B.Value contains string or empty string.
This code works fine:
=Iif(Len(CStr(First(Fields!A.Value, "dsResult_dtRows")))=0, True, False)
This code doesnt work:
=Iif(Len(CStr(First(Fields!A.Value, "dsResult_dtRows")))=0 Or Len(CStr(First(Fields!B.Value, "dsResult_dtRows")))=0, True, False)
thanks a lot for ideas and answers -marek-
-
marek over 13 yearsThank you for your answer. You are right,it works...but if only both Fields!A.Value and Fields!B.Value are empty strings.
-
marek over 13 years...but I need to have the result=true if A or B is empty. Not A and B. Im trying to work it out,using your sugestion,but unfortunately im not succesful.
-
Daria Dragomir over 13 yearsoh, sorry. thought you wanted both empty. I'll edit my response