Alternating Row Colors in SSRS

Home > Blogs > SQL Server > Alternating Row Colors in SSRS

Alternating Row Colors in SSRS

Like This Blog 0 Peter Avila
Added by May 17, 2013

Here is a simple report with alternating row colors; in this case, PaleGoldenRod and LightSteelBlue:

Altering row colors in SQL Server SSRS

In order to create alternating colors, we start by going to the Design tab and selecting the detail row in the tablix data region.

Tablix data region altering row colors in SQL Server SSRS

Next, find the BackgroundColor property in the Properties Window (if you do not see the Properties Window, press F4). Click the BackgroundColor property’s dropdown button and select Expression…

BackgroundColor altering row colors in SQL Server SSRS

Type the following expression into the Expression Builder window (ignore the red squiggly line; it complains but it works just fine). Use whatever colors you prefer.

Expression Builder window altering row colors in SQL Server SSRS

Here’s how that expression works: RowNumber() is a function that returns the current row number when the report runs. Inside the parenthesis, we specify the scope, or when we want the row number to reset to 1. By using “Nothing,” we tell it that the scope is the entire report, so that row numbers start with 1 on the first row and just keep counting up through the entire report (if we had wanted to reset row numbers at the start of every group, for example, we would have put the name of the group in the parenthesis, delimited in double quotes). The Mod operator stands for “modulo,” which returns the remainder of a division. In this case, the expression returns the remainder of a division in which the row number is divided by two. If the remainder is 1, then the row number is odd, and if it is two, the row number is even. In VB.Net, which is the language used in the Expression dialog, 0 is False and any other number is equivalent to True. So, when the row number is odd, the remainder is 1, or True, which causes the PaleGoldenRod color to be returned. When the row number is even, the remainder is 0, or False, which causes the LightSteelBlue color to be returned.

Once you’ve entered the expression, click OK, preview your report, and enjoy the alternating colors!

Peter Avila
SQL Server Instructor – Interface Technical Training
Phoenix, AZ

Videos You May Like

Creating Users and Managing Passwords in Microsoft Office 365

0 642 3

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

JavaScript for C# Developers – September 24, 2014

0 487 3

Is JavaScript worth taking the time to learn if I’m a server-side .NET developer? How much of C# carries over to JavaScript? In this recorded video from Dan Wahlin’s webinar on September 24,2014, Dan answers these questions and more while also discussing similarities between the languages, key differences, and the future of JavaScript (ES6). If … Continue reading JavaScript for C# Developers – September 24, 2014

Detailed Forensic Investigation of Malware Infections – April 21, 2015

4 606 5

How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.