Color code based on 2 col values

• mtz676

  SSCrazy Eights

  Points: 9261

  More actions

  June 24, 2015 at 12:47 am

  #398638

  My expression for backgrounfColor:

  =iif( Fields!ColA.Value<>Fields!ColB,"Red","Green")

  is returning wrong:

  Error is:

  The background color expression for the textbox 'ColA' contains an error:[BC30452] Operator <> is not defined for types Object and Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Field

  How do get over this.

  I a trying compare ColA and ColB values and if the values are not equal the color code that row as red if they are equal color code the row as green

• pietlinden

  SSC Guru

  Points: 63594

  More actions

  June 24, 2015 at 3:09 am

  #1807674

  Instead of

  =iif( Fields!ColA.Value<>Fields!ColB,"Red","Green")

  try

  =iif( Fields!ColA.Value=Fields!ColB,"Green","Red")