Solved

Alternating background color of group header in MS Reporting Services

Posted on 2008-06-11
1
2,967 Views
Last Modified: 2012-06-27
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

0
Comment
Question by:ryanvb83
1 Comment
 
LVL 12

Accepted Solution

by:
jgv earned 250 total points
ID: 21762161
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.
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/rch7rptslnpatternrecipes.mspx
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
How to increase the row limit in Jasper Server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question