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

Format Cell based on conditions in SSRS VS2010 Expand / Collapse
Author
Message
Posted Friday, March 7, 2014 7:29 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, July 20, 2014 12:12 PM
Points: 46, Visits: 197
Hello,

Struggling to write a Iif or Switch statement in the expression for the following:

If the cell value is "Y" then nothing
If TODAY() is 10 day or less prior to SV3 date (Field SV3Date) then Red color.

Thank you.
Post #1548938
Posted Friday, March 7, 2014 10:03 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 10:21 PM
Points: 887, Visits: 5,668
Struggling to write a Iif or Switch statement in the expression for the following:

If the cell value is "Y" then nothing
If TODAY() is 10 day or less prior to SV3 date (Field SV3Date) then Red color.


IIF(Column="y",Nothing,IIF(DATEDIFF("d",TODAY(),[SV3Date])<10,"Red","Black"))

??
Post #1548945
Posted Tuesday, March 11, 2014 4:35 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, July 20, 2014 12:12 PM
Points: 46, Visits: 197
Thank you very much. I was able to take this hint and fix my problem. This can be closed now. Thanks again ..!
Post #1549979
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse