SQLTeam.com | Weblogs | Forums

Only show certain text in a column

Hi,
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!
testing2

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.

hi

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

I think this should work