manipulating data with expressions

• Tash Hansan

  SSC Enthusiast

  Points: 159

  More actions

  March 16, 2006 at 10:09 pm

  #168173

  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 in advance for any help.

   

   

  -Tash

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  March 17, 2006 at 4:21 am

  #627237

  select isnull(value,0) in your sql code would do the job

  MVDBA

• Syed Asim Rizvi

  Ten Centuries

  Points: 1112

  More actions

  March 17, 2006 at 6:46 am

  #627290

  Or use this expression:

  =IIF(Fields!Cost.Value=Nothing,0,Fields!Cost.Value)