Click here to Skip to main content
12,883,272 members (38,865 online)
Click here to Skip to main content
Add your own
alternative version


1 bookmarked
Posted 26 Aug 2010

How to set an alternate row color in SSRS 2005

, 26 Aug 2010 CPOL
Rate this:
Please Sign up or sign in to vote.
First you will have to select the details row in the design mode, then from the Properties panel select the BackgroundColor property and go to edit its Expression, you will find the default value is Transparent, so replace it with this line of code:
=IIF(RowNumber(Nothing) mod 2, "Wheat", "White")
and click OK.

This line of code is telling the SSRS that if the row number was an odd number then make the row background color is White, else make it Wheat.
Run the solution and Have fun with colors :)


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer Asset Technology Group
Egypt Egypt
I'm a professional components designer, web developer, UX engineer and 3d designer as well, I'm 4 years experienced .net software engineer and 7 years experienced 3d designer using 3D Max. I'm very interested in RIA technologies, prototyping and UX engineering.

Ahmed Said
Senior .Net Software Engineer

You may also be interested in...

Comments and Discussions

QuestionProblem with SSRS Authentica​tion - don't want to use Custom Authentica​tion - Please guide Pin
Member 1069685125-Mar-14 4:22
memberMember 1069685125-Mar-14 4:22 
GeneralMy vote of 5 Pin
Paulo Künzel18-Sep-13 1:09
memberPaulo Künzel18-Sep-13 1:09 
GeneralMy vote of 3 Pin
G.Suman Babu15-Jan-13 19:40
memberG.Suman Babu15-Jan-13 19:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170422.1 | Last Updated 26 Aug 2010
Article Copyright 2010 by Ahmed_Said
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid