Row Color depending on if cell value same as prev
Hello,
Here's what I'm trying to do in psuedocode:
If(cell.value == previous.cell.value)
{
cell.color = previous.cell.color
}
else
{
if(previous.cell.color == "White")
cell.color = "Orange"
else
cell.color = "White"
}
I have a table in SRS and I want the row colors of rows with a cell that is equal (I order by this cell) to be grouped as the same color.
I know I can alternate rows by:
=IIf(RowNumber(Nothing) Mod 2, "AliceBlue", "White")
And I know there is a previous function
=IIf(Previous(Fields!MyValue.Value ) = Fields!MyValue.Value,
(HERE'S WHERE I'D NEED TO CHECK THE PREVIOUS COLOR), ??)
Is there any way to access a row's color?
Thanks.
|