Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS Conditional formatting Expand / Collapse
Author
Message
Posted Friday, December 14, 2012 6:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:32 AM
Points: 26, Visits: 176
Hi

I have an SSRS report that I want to use conditional formatting, but I'm not sure that what I want to do is possible, I have not been able to find a solution on forums yet.


I have a table with columns "Servername", "PageLifeExpectancy". I want to use conditional formatting to hightlight the "Page Life Expectancy" value according to the "ServerName".


Thus,
If the "Servername"='Server1' AND the "PageLifeExpectancy"<1400 then "PageLifeExpectancy" colour should be RED
If the "Servername"='Server1' AND the "PageLifeExpectancy">1400 then "PageLifeExpectancy" colour should be GREEN
If the "Servername"='Server2' AND the "PageLifeExpectancy"<300 then "PageLifeExpectancy" colour should be RED
If the "Servername"='Server2' AND the "PageLifeExpectancy"<300 then "PageLifeExpectancy" colour should be GREEN


I hope someone can help me to set this up as I really do not want to create this report in Excel.

Thx,
Theresa
Post #1396623
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse