Write in the expression in SSRS
=iif(RowNumber(Nothing) Mod 2, "White", "WhiteSmoke")
or use
=IIF(RunningValue(Fields!BuildingId.Value,COUNTDISTINCT,NOTHING) MOD 2 = 0,"WhiteSmoke","White")
//Here BuildingId is the group by value to have alternative color for every group.
=iif(RowNumber(Nothing) Mod 2, "White", "WhiteSmoke")
or use
=IIF(RunningValue(Fields!BuildingId.Value,COUNTDISTINCT,NOTHING) MOD 2 = 0,"WhiteSmoke","White")
//Here BuildingId is the group by value to have alternative color for every group.
No comments:
Post a Comment