Hi I have a requirement to use preferred ame if it is not null else use first name in my current report.
I am trying to create a new data item with following expression:
IF [Pref Name] IS NULL THEN [First Name] ELSE [Pref Name]
But it give me error 0459.
Please help me resolve the issue
Try this
IF ([Pref Name] IS NULL )THEN ( [First Name]) ELSE ([Pref Name])
or try coalesce function as coalesce ([Pref Name] ,[First Name])
Works :):):)
Thanks