p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 (http://p2p.wrox.com/book-professional-sql-server-reporting-services-isbn-0-7645-6878-7-127/)
-   -   Change background color based on two field data at SQL Server 2008 R2 (http://p2p.wrox.com/book-professional-sql-server-reporting-services-isbn-0-7645-6878-7/87660-change-background-color-based-two-field-data-sql-server-2008-r2.html)

jjjane June 1st, 2012 11:53 AM

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.


All times are GMT -4. The time now is 03:13 AM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.