Click here to Skip to main content
15,885,925 members
Articles / Programming Languages / SQL
Tip/Trick

How to set an alternate row color in SSRS 2005

Rate me:
Please Sign up or sign in to vote.
4.25/5 (4 votes)
26 Aug 2010CPOL 37.8K   1   3
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 :)

License

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


Written By
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

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
Member 1069685125-Mar-14 4:22 
​Good Morning Sir,

Please guide me.
I am working with SSRS 2008 and I am having problem with Report server Authentication.
I am getting prompted to pass credentials to execute the report.

I am using SSRS report server to display the report information with passing below URL to
iframe control.
"http://<<servername>>/reportserver....."

With the help of Custom Authentication type I am able to generate reports but its not valid authentication.

Please Please guide me.

Thanking you Sir.

Asif .S

hiasifsyed@gmail.com
GeneralMy vote of 5 Pin
Paulo Augusto Kunzel18-Sep-13 1:09
professionalPaulo Augusto Kunzel18-Sep-13 1:09 
GeneralMy vote of 3 Pin
G.Suman Babu15-Jan-13 19:40
G.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.