Post reply

How to update a column value based on other columns background color?

  • February 14, 2014 at 9:04 am

    #288230

    Can someone help out this issue? I am using SSRS 2008 R2

    I have a table

    col1 col2 ol3 col4

    row1 bg color "red" bg color "red"

    row2 no color for all three columns

    row3 bg color "red"

    I want to update col4 = 1 as long as any one of the column at the row has background color = "red". So it means I want to update col4 like:

    col4

    row1 1

    row2 0

    row3 1

    Thank you.

  • February 14, 2014 at 11:11 am

    #1689157

    Are you conditionally setting the cells background color? Something like:

    =IIF(Fields!Amount.Value < 0, "Red", "Green")

    You could use the same type of expression to set the value of your column 4.

    HTH,

    Rob

  • February 14, 2014 at 11:47 am

    #1689162

    Thank you for your response.

    Yes I conditionally setting the cells background color using swich. Since there are more than 70 columns, each column has complicated condition to get background color, I would like use the color result to update this column value.

    Another question is hidding property.

    I tried to hide a row as long as any columns in this row has background color = "yellow". It doesn't work if using statement as

    IIF(fields!col1.backgroundcolor = "Yellow", true, false).

    Can you help?

    Thanks again.

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

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