Indicators for Yes, No, or blank

• giszzmo

  SSChasing Mays

  Points: 647

  More actions

  April 24, 2014 at 8:36 am

  #307074

  I am writing an SSRS 2008 report. I am trying to use the checkmark, X, and exclamation indicators for a column using "Yes," "No" or blank. I cannot get it to work. For the value expression I have

  =iif(First(Fields!Finished.Value, 1)=True,1,0)

  States of Measurement Unit, I have it set to Numeric. For the checkmark I have it at start:1, end:1. For the X I have it at start:0, end 0. For the exclamation I have it at start:"", end:""

  I know its wrong somewhere but I just not sure where. If anyone can point me in the right direction.

  Thanks!

• David Burrows

  SSC Guru

  Points: 65138

  More actions

  April 24, 2014 at 9:20 am

  #1708443

  Assuming Finished is a bit column then use this expression

  Switch(IsNothing(Fields!Finished.Value),2,Fields!Finished.Value,1,True,0)

  Far away is close at hand in the images of elsewhere.
  Anon.