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
2. Go to Properties, Find Background property and click on ‘Expression...’
3.In ‘Expression’ window type:
=IIF((RowNumber(nothing) MOD 2)=1,"Gainsboro","Transparent")
Hope that helps!
Katie
|
Share:
Comments Add Comment
Name:
Rich
Comment:
Thanks for the approach. The formula provided generated a report, but the following warning was also generated for every other row:
[rsInvalidColor] The value of the BackgroundColor property for the text box ... is “Transparent”, which is not a valid BackgroundColor.
Changing the expression slightly provided the desired result without the warning messages:
=IIF((RowNumber(nothing) MOD 2)=1,"Gainsboro", Nothing)
Thanks again!
Date Posted:
05/12/2012 9:58:58 PM
Share your thoughts, questions and suggest improvements:
Add Comment
