Alternating Row Colors in SSRS
Alternating Row Colors in SSRS
Here is a simple report with alternating row colors; in this case, PaleGoldenRod and LightSteelBlue:
In order to create alternating colors, we start by going to the Design tab and selecting the detail row in the tablix data region.
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…
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.
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!
SQL Server Instructor – Interface Technical Training
You May Also Like
A Simple Introduction to Cisco CML20 3703 0
Mark Jacob, Cisco Instructor, presents an introduction to Cisco Modeling Labs 2.0 or CML2.0, an upgrade to Cisco’s VIRL Personal Edition. Mark demonstrates Terminal Emulator access to console, as well as console access from within the CML2.0 product. Hello, I’m Mark Jacob, a Cisco Instructor and Network Instructor at Interface Technical Training. I’ve been using … Continue reading A Simple Introduction to Cisco CML2
How to Build in a PSMethod to your PowerShell Code0 68 0
In this video, PowerShell instructor Jason Yoder shows how to add Methods (PSMethod) to your code using free software that’s added into the PSObject. For instructor-led PowerShell courses, see our course schedule. Microsoft Windows PowerShell Training Download the Building Methods PowerShell script</a> used in this video. <# ╔══════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ Building Methods ║ ╟──────────────────────────────────────────────────────────────────────────────╢ … Continue reading How to Build in a PSMethod to your PowerShell Code
Configuring Windows Mobility Center and How to Turn it On and Off1 1413 1
Video transcription Steve Fullmer: In our Windows training courses, we often share information about the Windows 8.1 Mobility Center. Mobility Center was introduced for mobile and laptop devices in Windows 7. It’s present and somewhat enhanced in Windows 8. Since we don’t have mobile devices in our classrooms, I decided to take a little bit … Continue reading Configuring Windows Mobility Center and How to Turn it On and Off