preloader-matrix

Alfasith

Alternative color in SSRS 2012

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.

Leave a Reply

Your email address will not be published. Required fields are marked *