I have an SSRS report that looks something like this:
Row1 2 A
Row2 2 B
Row3 2 C
Row4 6 A
Row5 11 E
How can I color the rows with the same value in Column1 with the same color? for example Row1 to Row3 would have one color, Row4 would have a different color, then I'd go back to Row1's color for Row5?
note: I don't know in advance the numbers returned in Column1. I query for them and then I hide them from the user so Column1 shouldn't show on the report, but I want to use it for the coloring only.
View Complete Post