Home Forums Reporting Services Reporting Services 2008 Development Color code column values RE: Color code column values

  • January 25, 2016 at 2:30 pm

    #1854301

    sqlnewbie17 (1/25/2016)

    By evaluating 2 columns(Blocked and Current_Overdue) and then color coding 2nd column.

    Can I have somethinglike this to color code a column (Current_Overdue)

    =IIF(Fields!Blocked.Value=1 And Fields!Current_Overdue.Value = 0, "Red", "Green")

    =IIF(Fields!Blocked.Value=2 And Fields!Current_Overdue.Value = 10, "Red", "Green")

    =IIF(Fields!Blocked.Value=3 And Fields!Current_Overdue.Value = 20, "Red", "Green")

    =IIF(Fields!Blocked.Value=4 And Fields!Current_Overdue.Value = 30, "Red", "Green")

    =IIF(Fields!Blocked.Value=5 And Fields!Current_Overdue.Value = 40, "Red", "Green")

    That syntax is not correct. I assume you means something like this:

    =IIF( (Fields!Blocked.Value=1 And Fields!Current_Overdue.Value = 0)

    OR (Fields!Blocked.Value=2 And Fields!Current_Overdue.Value = 10)

    OR (Fields!Blocked.Value=3 And Fields!Current_Overdue.Value = 20)

    OR (Fields!Blocked.Value=4 And Fields!Current_Overdue.Value = 30)

    OR (Fields!Blocked.Value=5 And Fields!Current_Overdue.Value = 40), "Red", "Green")

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/