May 4, 2011 at 9:22 am
Anyone know how this is done,
I have a text box containing a various value for example "ID" may be one in a column, I want to highlight in the next column if is in a list of comma delimited initials by changing the background colour to red. - the list looks like ID,DB,VG,FR,DA
below does not work -
= IIf(Fields!owner.Value like "*" + Fields!Dist_List.Value + "*" ,"Red", "Transparent")
Any help very much appreciated
May 4, 2011 at 2:38 pm
I am not quite sure what you are trying to indicate with "*" but I would probably use IIF(InStr to do your evaulation. In the SSRS Expression builder you can find InStr and it will tell you how to use it.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy