I am trying to alternate row colors in SSRS but I want each group to start with the same color, independent of the amount of rows in the previous group. I know that the function =IIf(ROWNUMBER(NOTHING) MOD 2, "Transparent", "Gray") allows me to alternate the rows, but this creates
Which is not what I want, since group 2 now starts with a grey row. Below an example of the desired output where the first row in each group starts with a white background.
Any idea how to solve this? Thanks in Advance!