Hi All,
One of the basic attempt by reporters is is to make their report look good and they would achieve this by adding colors to the rows. It is easy to change the background color of the reports, but if you have to apply colors to the alternate rows in SSRS reports. Then follow the below steps
Choose the row in design mode
Then choose expression under BackgroundColor
Choose Expression and then paste the below
One of the basic attempt by reporters is is to make their report look good and they would achieve this by adding colors to the rows. It is easy to change the background color of the reports, but if you have to apply colors to the alternate rows in SSRS reports. Then follow the below steps
Choose the row in design mode
Then choose expression under BackgroundColor
Choose Expression and then paste the below
=IIf((RowNumber(Nothing) MOD 2) = 1, "Gainsboro", "Transparent").
The RowNumber will return the count of the row and MOD (modulus) will determine
if the row is even or odd and apply color accordinglyNOTE - This will work only in SSRS 2008 and not in 2005 or 2000
