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
SQL Server Reporting Services
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
Yes, I get a "1" for each group header row.
I have also tried countrows.
BobP
If I understand you correctly, this should give you the desired result:
Add this to your code window:
Dim numFooterRow as Double
Function GetRowNumber() as Double
numFooterRow += 1
Return numFooterRow
End 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:
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:
You now have alternating colors at the group header level.
Simone