Dynamically change colour

• sachinrshetty

  SSCrazy

  Points: 2062

  More actions

  May 14, 2010 at 2:51 am

  #222510

  Hi,

  I m displaying total hour in the field. The values are like 09:11:00, 10:09:00, 07:23:00 and so on. If the value is less than 8 hour i want to change that field background color to red.

  I have written expression for the background color as below but its not working.

  =IIf(Fields!TOTHR.Value < 8, "Red", "White")

  what is wrong in the above expression.

  Thanking you all

  Sachin

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  May 14, 2010 at 7:19 am

  #1167516

  Hi,

  Try this

  =iif(Hour(Fields!TOTHR.Value)< 8 , "Red", "White")

  This code is in SSRS 2008 , If you are using SSRS 2005 , please check Hour() is there or note, try using some function to get the hour part only

  Thanks & Regards,
  MC