Solved

Alternating background color of group header in MS Reporting Services

Posted on 2008-06-11
1
2,955 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now