Post reply

SSRSColoring

  • June 19, 2017 at 3:44 am

    #326833

    I have 3 columns A, B and C.
    If Column A values is tempdb and column C has no value then color code entire row as green.
    If Column A value is  not tempdb  and col B value is  x  and column C has no value then color code entire row as green.
    If Column A values is not tempdb and col B value is Y and column C has no value then color code entire row as red.
    and rest all rows will also be green.
    Thanks

  • June 19, 2017 at 6:15 am

    #1947235

    Considering you only have one criteria for red, otherwise Green:
    =iif(Fields!ColumnA.Value <> "tempdb" AND Fields!ColumnB.Value = "y" AND IsNothing(Fields!ColumnC.Value), "Red", "Green")
    You'll need to put this expression in each cell's backcolour property in the row.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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