rdlc Expression Error

Question

I am using iif(Field!test1.Value=nothing,"",test1.Value.ColumnName)

It works fine if test1.value is not null. If it is null then i am getting #Error in my report.

Is there something i am doing wrong?

Answer 1

Try

=Iif(IsNothing(Field!test1.Value),"",test1.Value.ColumnName)