display true when an SSRS expression value is null

• sqldevlearn

  Old Hand

  Points: 397

  More actions

  November 6, 2018 at 2:53 am

  Go to Answer

  #380796

  How to display Yes when an SSRS expression value is null, I have an SSRS expression as follows
  
  In some cases my value can be NULL, in that case also I would like to display as Yes

• sqldevlearn

  Old Hand

  Points: 397

  More actions

  November 6, 2018 at 3:26 am

  Answer

  #2012498

  Resolved 

  =IIF(IsNothing(First(Fields!IsActive.Value,"ds")) OR First(Fields!IsActive.Value,"ds") = true, "Yes", "No")