Alternating Group Colors

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

Comments (2)

tferrara
tferrara said:
Hi Brian - Thanks very much for this, it was exactly what I was looking for. However, I found that I had to make a small change to the code in order to make it work. When I used your statement, BIDS complained about NOTHING. Of course, what else is new? Seriously though, I had to replace NOTHING with the name of the group in quotes. So... This did not work: =IIF(RunningValue(Fields!Item_Nbr.Value,COUNTDISTINCT,NOTHING) MOD 2 = 0,"PaleGreen","White") This DID work: =IIF(RunningValue(Fields!Item_Nbr.Value,COUNTDISTINCT,"GroupName") MOD 2 = 0,"PaleGreen","White") Thanks again for putting me on the right track.
8/30/2011
 · 
 
by
briankmcdonald
You're welcome! Just out of curiosity, which version of SSRS are you on?
8/31/2011
 · 
 
by
Blogs RSS Feed

briankmcdonald's latest blog posts

Blogs RSS Feed

Latest community blog posts