Name

[Sep2013]

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

[HalfBloodPrince]

Try this
IF ([Pref Name] IS NULL )THEN ( [First Name]) ELSE ([Pref Name])

or try coalesce function as coalesce ([Pref Name] ,[First Name])

[Sep2013]

Works :):):)
Thanks