Alternative row colors with different scope in SSRS
Alternative colors without any scope or condiction.
=iif(RowNumber(Nothing) Mod 2, “#ffffff”, “#f0f0f0”)
Alternative colors with scope or condiction.
=IIF(RunningValue(Fields!CustId.Value, CountDistinct, Nothing) MOD 2 = 1, “#ffffff”, “#f0f0f0”)
We can display alternative colors based on distinct running values or by parent groups or specific condition like
=IIF(Fields!Amount.Value > 35000 , “#ffffff”, “#f0f0f0”)
Even we can achive group with in group cases and Matrix cases by selecting particular cells.