Entire expression returns null if any of its part is null

[Amar]

Hi,

I am facing a problem in binding the reports data with expressions. I am using the below expression-

=Fields.Name + ", " + Fields.Address + ", " + Fields.PhoneNo

In this, if any part(like Fields.Name) is null then it makes the whole expression to return null and it leaves the line blank on the report. ​I expect it to concatenate the strings and if there is any null value then it should ignore and should give us the rest as the output(Which is the default behaviour of .Net)

 Please suggest if there is any option to change its behaviour of dealing with null values or is there any alternative ?

 

[Nasko]

Hello Amar,

The IsNull() conditional function or the  operator (??) can be used in the expression to replace null values with an empty string or another value of your choice.

Regards,
Nasko
Telerik

[Amar]

Thanks.