• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2993
  • Last Modified:

Alternating background color of group header in MS Reporting Services

I'm looking for a way to alternate the background color of a group header in reporting services.  I'm currently using this code to alternate the detail rows to create a "green bar" effect, but it doesn't work in the group header because its still counting the number of rows, instead of the group headers.
=iif(rownumber(nothing) mod 2 = 1, "AliceBlue", "White")

Open in new window

1 Solution
Have a look at this article which should work for what you are trying to do. Follow up here if you have problems getting it to work properly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now