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?

score 1 · Answer 1 · answered Sep 25 '12 at 13:05

1

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.

answered Sep 25 '12 at 13:05

Zara

291
4
19

score 0 · Answer 2 · answered Jul 12 '13 at 07:30

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

In the above if condition the field test1 will check the value as equal to "" (blank) which is the first part before first comma, id it holds true than the value will be assigned as ""(blank), otherwise the last part of the equation test1.Value.ColumnName

score 0 · Answer 3 · edited May 23 '17 at 11:43

0

I guess it will throw an error if you try to access 'ColumnName' on something that doesn't exist.

The below quote might give some help.

IIF evaluates all arguments. If any argument generates an error, then the entire function will throw an error, regardless of which of the three arguments should have been returned.

edited May 23 '17 at 11:43

Community

1
1

answered Feb 17 '14 at 17:52

Jim Aho

9,932
15
56
87

score -1 · Answer 4 · answered Oct 01 '09 at 16:59

-1

Try

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

answered Oct 01 '09 at 16:59

Jeremy Stein

19,171
16
68
83

rdlc Expression Error

4 Answers4