I know how to alternate the background color of individual rows in a Report Builder 2.0 table, but what I want is to have all rows within a row group to have the same background color, and I want that color to alternate with row groups.
---------------------------------------------------------
group 1 | row 1 in group 1 - white background
| row 2 in group 1 - white background
---------------------------------------------------------
group 2 | row 1 in group 2 - gray background
| row 2 in group 2 - gray background
| row 3 in group 2 - gray background
---------------------------------------------------------
group 3 | row 1 in group 3 - white background
---------------------------------------------------------
group 4 | row 1 in group 4 - gray background
...And so on. By "row groups", I guess I really mean the different values. Say if I had a row group on the 'Category' field, and there were 'Category' values Tall, Skinny, Fat, and Long (in that order). I would want all rows with 'Tall' to have a white background, all 'Skinny' rows to have a gray background, all 'Fat' white, and all 'Long' gray.
I've tried various Iif(RowNumber('Category') Mod 2 = 0, "#eaeaea", "Transparent")-types of expressions for the background color, but that doesn't give me what I want.