Alternate colors when row and column grouping

Question

Post reply

Alternate colors when row and column grouping

russellxup

SSC Veteran

Points: 265
More actions
May 16, 2012 at 1:57 am

#392268

Hi,
I would like to have alternate colors, but in my report I have both row and column grouping.
So in my case expression "= IIf(RowNumber(Nothing) Mod 2 = 0, "Silver", "Transparent")" counts rows like in following example:
|No| C1 | C2 | C3|
| 2 | aa | bb | &nbsp &nbsp |
| 5 | aa | bb | cc |
where "No" is row number and C1,C2,C3 - column names.
Do you know how to number rows one by one in my case?
I also tried this expression: "=IIF(RunningValue(Fields!DepartmentName.Value,CountDistinct,Nothing) Mod 2, "Silver", "White")", but because of report specification it also doesn't count rows correctly.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

I think one of these might give you what you want:

http://www.bidn.com/blogs/briankmcdonald/bidn-blog/717/alternating-group-colors-and-alternating-row-colors

http://www.bidn.com/forums/microsoft-business-intelligence/reporting-services/1189/alternating-color-on-rows

russellxup SSC Veteran Points: 265 More actions · Answer 2

Thank you for your reply. Actually I found solution of my problem.

I modified expression "=IIF(RunningValue(Fields!DepartmentName.Value,CountDistinct,Nothing) Mod 2, "Silver", "White")". Before Fields!<name>.value I added "Max" item and now it's not summing values for each column group, but it takes only one value for each row.