Group Header Alternating color
I am trying to get alternating colors on group headers.
The rownumber() doesn't work; that only seems to be the count of rows in the group.
Does anyone have any great ideas for this?
Thanks!
BobP
April 28th, 2006 11:19pm
Have you tried CountDistinct(<group expression fields>)?
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2006 12:55am
Yes, I get a "1" for each group header row.
I have also tried countrows.
BobP
May 1st, 2006 7:51pm
I realize this was a year ago, but was wondering if anyone had figured out a solution. I am trying to alternate colors at the group level and am not having any luck...
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2007 3:52pm
If I understand you correctly, this should give you the desired result:
Add this to your code window:
Code Snippet
Dim numFooterRow as Double
Function GetRowNumber() as Double numFooterRow += 1 Return numFooterRowEnd Function
Add a new column to the table and mark it as not visible. On the group header row (the invisible column), add this expression:
Code Snippet=Code.GetRowNumber()
You will need the name of the textbox that you just entered the expression into for the final part. In the header row background color add the following expression:
Code Snippet=iif(ReportItems!textbox18.Value Mod 2 = 0,"LightCoral","RosyBrown")
You now have alternating colors at the group header level.
Simone
May 8th, 2007 5:01pm
Wow, thanks so much, Simone! I've been banging my head against the wall on this one for the last hour, trying to think up ways to do it in SQL, using the Previous() function, etc. This worked like a charm!
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2007 5:15pm
I am trying to do something where I say look through the row. When you come across the word "Start" color that box green and color all other boxes to the rightin that row green as well until you come upon the word "stop". Is this possible? If I am not making sense just let me know and I will try to explain better. Thanks in advance for any help that I get.
May 17th, 2007 6:14pm
You might want to start a new thread, although somewhat similar, it seems to me its a different topic...
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2007 6:28pm
Ok will do.
May 17th, 2007 6:37pm
HelloThank you for sharing this information it had been a big help.I have mulitple group headerson my report. How do I get this to work for all of them? I have carried out this process on the first group and it works fine but I am having problems when I try to do the others. What exactly is the process?K
Free Windows Admin Tool Kit Click here and download it now
March 4th, 2009 2:19pm
Try this:
http://durrenajaf.blogspot.com/2011/05/urdu-hay-jis-ka-naam.html
June 10th, 2011 6:17am
http://durrenajaf.blogspot.com/2011/05/urdu-hay-jis-ka-naam.html
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 6:18am