View Single Post
  #1 (permalink)  
Old June 1st, 2012, 11:53 AM
jjjane jjjane is offline
Registered User
Points: 17, Level: 1
Points: 17, Level: 1 Points: 17, Level: 1 Points: 17, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2012
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Change background color based on two field data at SQL Server 2008 R2

Hi,

I have a report need to change one field background color based on another field data, and data at the field self.
E.G.

Category Number

Apply 100
Orange 50

if category column shows Apply, then
when Number > 100, Number field backgroud color is Black
Number >50 and < 100, Number field background color change to Green.
When Number <50, Number field background color change to Red.

if Category column shows Orange, then
when number > 50, Number field background color is Black
Number <50 and >20, color is Green
Number <20 then Number field background color is Red

Would someone give me suggestions how to do that?
I searched online, only see change background color for one field and based on this field value.

I am much appreciated if someone can help me out.

Thanks a lot.