SQLTeam.com | Weblogs | Forums

Only show certain text in a column


#1

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


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

#3

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.


#4

hi

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

I think this should work