Nested IIF not working

[Pinkesh]

Im trying to use nested if statement, but it fails to work:

 

inside my textbox:

=Max(IIF(Fields.RequestContactCodeDescription = "Broker", 
IIF(Fields.HomePhoneNo = "", IIF(Fields.BusinessPhoneNo = "", IIF(Fields.CellNo = "", "No Contact Num", Fields.CellNo), Fields.BusinessPhoneNo), Fields.HomePhoneNo), ""))

 

 

equivalent pseudo if statement:

If(Fields.RequestContactCodeDescription == "Broker"){

     if(Fields.HomePhoneNo == ""){

          if(Fields.CellNo == ""){

           [...]

          }else{

            //Show CellNo

          }

      }else{

         //Show HomePhoneNo

     } 

}else{

//show nothing

}

 

What I want it to do:

Find the entries that has 'Broker' as the code Description. Then show his Home phone number, if he doesnt have that then show his Cell number, if he doesnt have that then show his Business number

[Stef]

Hello Pinkesh,

The expression works correctly in our test, please check the attached TRDP file in the Standalone Report Designer of Telerik Reporting R3 2016 or newer.

Double-check if the fields are of string type and if they come as empty strings (""), null or other that mey require comparing them to different values e.g. as condition Fields.CellNo Like '' or Fields.CellNo Is Null or IsNull(Fields.CellNo,'') Like ''.


Regards,
Stef
Telerik by Progress