How would you alternate the color in a grid based on a grouping.
IE. (the 1000 Users should have background color of White and 2000 background would be WhiteSmoke)
ColumnUser ColumnNote
1000 Note1
1000 Note2
2000 Note1
2000 Note2
Try using the following expression for the BackgroundColor property.
=iif(RunningValue(Fields!ColumnUser.Value,CountDistinct,Nothing) Mod 2, "White", "WhiteSmoke")
|||nice...thanks!
No comments:
Post a Comment