How to use IIF
I need to show a field into a report only if it has a value and I tried to use the IIF to solve the problem but without success.
I need to do something like that:
IIF(<field> is null, '', 'Contact person:' + <field>)
I need to do something like that:
IIF(<field> is null, '', 'Contact person:' + <field>)
Comments
[IIF(<Customers."Addr2"> ='',<Customers."City">,<Customers."Addr2">)]
if you want the evaluation expression to check for null then the report engine option
convert nulls must be set to false otherwise check for value.