Post reply

Conditional Formatting in SSRS Based on a Range of Values

  • September 20, 2013 at 3:07 pm

    #282860

    I am building a backup status report in SSRS 2008. Here is a screenshot of what I have so far:

    I want to change the font color of the Backup Status to red if the status is FAILED using this conditional logic:

    =IIF(Fields!backupstatus.Value <> "SUCCESS", "Red", "Black")

    What I want to do now is change the font color of the Instance Group value to red if any of the Backup Status values in that group are FAILED. So in the screenshot above, DEVSQL08 should be displaying in red as well in the left-hand column.

    Any assistance would be appreciated.

    Thanks,

    Frank

    blog skreebydba.com

    twitter @skreebydba

  • September 20, 2013 at 3:35 pm

    #1652065

    I have copied the same conditional expression into the text box for Instance Group with no luck.

  • September 27, 2013 at 2:21 pm

    #1654201

    I figured it out with the help of Jes Borland (Thanks, Jes!). The expression for the Instance Group font color needs to read

    =IIF(MIN(Fields!backupstatus.Value) = "FAILED", "Red", "Black")

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply