using OR in IIF statement...RDLC

report rdlc iif
marek picture marek · Jan 25, 2011 · Viewed 33.2k times · Source

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-

Answer

Beth picture Beth · Jan 25, 2011

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)

Related questions

How to limit RDLC report for one page in a PDF ?

I have a RDLC report and I am displaying it on the Report Viewer Control in my front end application. I am able to view the report perfectly. But the problem arises when I try to export the report to …

Read More
Dynamically binding of Dataset to RDLC Reports

I would like to bind the dynamically dataset to the rdlc. I can view the report if I use inline DataSource in ASPX file (static binding). However, if I use the following codes, the Report viewer keeps showing "Loading.." Image. …

Read More
How I can format date in report to appear exactly as I want - RDLC

I have a report in my application and this report will show a long date from db and I used this expression to make it shorter: =FormatDateTime(Fields!StatementDate.Value,DateFormat.ShortDate) and the date will show like this : 1/1/2010 I …

Read More