Thursday, August 05, 2010

SSRS 2005 : Different color for Alternative Rows

Problem : You want each row in your tabular data to have different color, like zibra cross.
Solution :
1. Select the Row
2. Go to Properties
3. in BackgroundColor property Choose, Expression



4. Write in the Expression window :



=IIF((RowNumber("dataset_name") mod 2 =0),"Gray","White")



And you are done.
Keywords: SQL Server Reporting Services, SSRS, SSRS Alternative Row Color

No comments: