I WOULD LIKE TO DO A CONDITIONAL FORMATING ON A FIELD. This is what I'd like it to do:- The query has NULLs and blanks in some fields and I want the field on the report to display a "0" (zero) If null values. How would I write the expression. The expression below errors out.

=IIf(Fields!Cost.Value IS NULL, "0", Fields!Cost.Value)

Thanks for any help.

-Tash

Hi Baaul,

i too faced the same prob few days back, i couldn't resolve it in report designer.
But i checked for null values at the backend.

For eg.
SQL Server
--------------------
SELECT isNull(Cost, -999) FROm tablename.

In Report Designes use the code like the one below
----------------------------------------------------
=IIf(Fields!Cost.Value = -999, 0, Fields!Cost.Value)

Hope the reply is helpful..

Cheers
Chakri

You may be able to use switch

=switch(Fields!Cost.Value IS NULL,"0")



Hope this helps.