Post reply

Using LIKE comparison

  • May 4, 2011 at 9:22 am

    #235646

    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

    #1320096

    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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply