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

Share on email
Share on facebook
Share on twitter
Share on linkedin
Share on pinterest

Leave a Reply

Your email address will not be published.