Showing posts with label grid. Show all posts
Showing posts with label grid. Show all posts

Tuesday, March 27, 2012

Alternate item color

How do I change the row background color for table items?
In data grid control, I can use
<AlternatingItemStyle BackColor="#FFFFCC"></AlternatingItemStyle> but I am
not able to find this attribute in report services? Thanks for help.If the row has grouping
=iif(RunningValue(Fields!Grouped.Value,CountDistinct,Nothing) Mod 2,
"Cornsilk", "White")
or if it has no grouping
=iif(RowNumber(Nothing) Mod 2, "Cornsilk", "White")
"Help is in the way" wrote:
> How do I change the row background color for table items?
> In data grid control, I can use
> <AlternatingItemStyle BackColor="#FFFFCC"></AlternatingItemStyle> but I am
> not able to find this attribute in report services? Thanks for help.
>
>

Alternate color on groups.

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!