SQLTeam.com | Weblogs | Forums

Only show certain text in a column


I'm needing some help. I've been trying to do an iif that only show the row text TBE shows, everything else change. notice columnA is the original, columnB is what I need. Thanks!

case when color='TBE' then 'TBE' else '' end


how do I write that in SSRS? I tried doing the =iif(Fields!color.Value<>"TBE", Nothing,"Black")). I had tried to so many different way but to no avail.



=iif(Fields!Color.Value <> "TBE","No color","Blue")

I think this should work