Rdlc Expression Error

rdlc

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?

Best Answer

if the value u r getting is a string

IIF(Field!test1.Value="","",test1.Value.ColumnName)

else compare with 0 like dis

 IIF(Field!test1.Value=0,"",test1.Value.ColumnName)

try dis.

Related Topic