Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Animating SQL Report Cells

Author  Topic 

sfjtraps
Yak Posting Veteran

65 Posts

Posted - 2010-01-20 : 19:58:45
Please Help.

Can SQL Report cells be animated different colors based on a value inside the cell?

I want to turn a cell red if the setpoint value inside the cell is outside Hi and Lo values.

Is this possible---and quick and easy?

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2010-01-21 : 12:01:48
Very easy/simple. To change the background color to red if a value goes negative(in my case it is a start date and if I am past it) the expression in the value for backgroundcolor was:


=IIf(Fields!Days_to_Start.Value < 0, "Red", "Transparent")



John
It's a small world (but I wouldn't want to paint it)
Go to Top of Page
   

- Advertisement -