开发者

using OR in IIF statement...RDLC

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
 Le开发者_开发百科n(CStr(First(Fields!B.Value, "dsResult_dtRows")))=0, True, False)

thanks a lot for ideas and answers -marek-


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)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜