Alternating Group Colors and Alternating Row Colors

Who is online?  0 guests and 1 members
Home  »  Blogs  »  briankmcdonald  »  Alternating Group Colors and Alternating Row Colors
 
0
/5
Avg: 0/5: (0 votes)

Comments (4)

karlb
karlb said:

Hi Brian,

Your method is great for a simple report that doesn't use a matrix/tablix. With a multi dimensional source and a dimension on the columns you can run into trouble, because SSRS treats the rownumber() not by what is displayed but by the order of the tuples returned from SSAS.

There is a method that uses report level custom code to create an EvenRow() function, then a row group variable that references the function and finally sets the text box shading property based on the variable value.

Have a look at this link http://www.powerpivotblog.nl/alternating-backgroundcolor-in-tablix-for-rows-of-a-group

Karl Beran

Senior Business Intelligence Consultant - IMGroup UK

http://karlberan.spaces.live.com/

6/4/2010
 · 
 
by
briankmcdonald

Karl,

As we all know, there are many ways to "skin a cat" and my example is no different. Of course you can programmatically modify the report and I have many times in the past, but my post was simply just showing one method of delivering the desired result. As far as the linked example, I would like to see what would happen if there were more than one group? I would suspect that all of the groupings would be WHITE and only the colors within the group would alternate. My example was to show multiple groups and alternating the colors within those groups AND the rows inside each group.

Thanks,

Brian

6/5/2010
 · 
 
by
lvcamvn
lvcamvn said:

This works for aggregate columns as well. Thanks Brian!

Cam

7/6/2011
 · 
 
by
briankmcdonald

Glad you liked it Cam!

7/7/2011
 · 
 
by
Blogs RSS Feed

briankmcdonald's latest blog posts

Blogs RSS Feed

Latest community blog posts