I have reports in SSRS where I'm able to alternate the row colors using this expression:
=IIF(ROWNUMBER(NOTHING) MOD 2, "LightSteelBlue","WhiteSmoke")
This works great. However, I have a report that has a column grouping, and this seems to mess up the alternating row colors.
The grouped columns will alternate column colors instead of row colors. I've searched and found possible solutions with row groupings but nothing with column groupings, or at least nothing I can get to work. I'm just trying to have every other row be "LightSteelBlue" or "WhiteSmoke," nothing fancy.
Any ideas?