How to alternate row colors in SSRS Tablix reports?

Asked 7 hours ago Updated 7 hours ago 22 views

0

Creating readable reports often requires zebra-striping (alternating row background colors) across data rows in a Tablix control.

How to set alternating colors in SSRS:

Select the detail row of your Tablix table, open the Properties window, and set the BackgroundColor property to an expression:

=IIF(RowNumber(Nothing) Mod 2 = 0, "Gainsboro", "White")

How it works:

  • RowNumber(Nothing) returns the sequential row index for the current scope.
  • Mod 2 calculates the remainder when divided by 2.
  • IIF assigns "Gainsboro" for even rows and "White" for odd rows.

0 Answers


Write Your Answer