preloader-matrix

Alfasith

Alternative row colors with different scope in SSRS

Hi,

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.

 

Regards

Leave a Reply

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