Friday, May 13, 2011

Alternating Color for GROUP HEADERS

I am hiding detail row and just showing group header in SSRS and needed alternating color, this is what i used
=IIf (RunningValue (Fields!SomeField.Value, CountDistinct, Nothing) Mod 2 = 0,
"Silver", "White")
it worked !
astu...

1 comment:

Unknown said...

'Nothing' if there is only one group otherwise put in 'parent group' name for alternating group header within the 'parent group.'

astu...