Home >SQL Server >SSRS

SSRS alternate row color

If you after SSRS Alternate Row Color then you are in the right place.

The easiest way to apply alternate row color using SSRS is to use the following Expression:

=IIF((RowNumber(nothing) MOD 2)=1,"Gainsboro","Transparent")

How to do that exactly? Please follow the instructions below:
1. Select Entire Row

SSRS Alternate Row Color - Select Row

2. Go to Properties, Find Background property and click on ‘Expression...’

SSRS Alternate Row Color - Apply Expression

3.In ‘Expression’ window type:

=IIF((RowNumber(nothing) MOD 2)=1,"Gainsboro","Transparent")

SSRS Alternate Row Color - Expression sample

Hope that helps!
Katie

News & Updates: Follow @katieglownia Follow @emilglownia

You like it? Share it!

Comments Add Comment
No data was returned. Shere your thoughts, questions and suggest improvements:
Add Comment