Help checking for Null

• dba321

  Hall of Fame

  Points: 3917

  More actions

  February 1, 2006 at 9:55 am

  #189066

  I'm not sure how to check first to see if New_Old_CC in my SSRS 2005 expression

  I tried changing:

  =IIf(Fields!New_Old_CC.Value= 1, Fields!PDC.Value,0)

  to:

  IIf(IIf(Not(Isnothing(Fields!New_Old_CC.Value) AND Fields!New_Old_CC.Value = 1), Fields!PDC.Value,0)

  I also tried:

  =IIf(IsNumeric(Fields!New_Old_CC.Value))

  AND Fields!New_Old_CC.Value = 1, Fields!PDC.Value,0)

  both times got syntax errors in VS

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  February 2, 2006 at 5:43 am

  #618349

  Use  MyValue = Nothing