OK. Thanks to the google machine I found a nice little block of code to put into the background color property for use in SSRS:
=iif(RowNumber(Nothing) Mod 2, "LightGrey", "White")
The issue I have is I don't want to alternate lines, I want to alternate groups. I have a sub report that pulls its parameters from both the data that is generated at the parent level and the parameters that were passed to the report to start with.
My report loads perfectly, I just want to alternate colors based on the value changing in a specific field. This column is currently set up to hide repeat values in this column, so it does help identify the data but an alternating color would be the icing
on the cake.
I want to make it change colors at the CoilSeqNo. Any thoughts or ideas? Is this possible or am I just chasing windmills?
mkruluts
Member
62 Points
22 Posts
Alternate cell color based on grouping?
Jan 31, 2012 06:03 PM|LINK
OK. Thanks to the google machine I found a nice little block of code to put into the background color property for use in SSRS:
=iif(RowNumber(Nothing) Mod 2, "LightGrey", "White")
The issue I have is I don't want to alternate lines, I want to alternate groups. I have a sub report that pulls its parameters from both the data that is generated at the parent level and the parameters that were passed to the report to start with. My report loads perfectly, I just want to alternate colors based on the value changing in a specific field. This column is currently set up to hide repeat values in this column, so it does help identify the data but an alternating color would be the icing on the cake.
I want to make it change colors at the CoilSeqNo. Any thoughts or ideas? Is this possible or am I just chasing windmills?