I need an iif conditional like this:
=iif(fields!carrier.ismissing, " ", "carrier name is "(fields!carrier.value))
in this example if the field carrier is missing or is nothing then nothing is returned; otherwise the text "carrier name is " and "the field value is returned.
I also need something like this:
=IIF(Fields!carrier.Value Is Nothing," Nothing", IIF(Fields!carrier.Value like "%Sprint%","Sprint/Nextel",Fields!carrier.Value))