Alternating Table Row Colors in SSRS

By
roopesh.valluru
-
22
16791

Friends,

One common question from many of those who are relatively new to Microsoft SQL Server Reporting Services is how to alternate the background color of detail rows in a table data region. We also call it as Zebra Striping. To demonstrate the same I designed a table report and PFB the preview of the same.

Now, to change the background color of alternate row, follow the steps given below.

  • Select the complete row as shown below and select Expression in the Backgroundcolor property.

  • When the expression page opens then copy the below given expression.

=iif(RowNumber(Nothing)  Mod 2,”Silver”,”White”)

  • Click on OK and Preview the report. You can see Zebra Striping as shown below.

That is it. You can see the beautiful Zebra striping report. Try it !!

Regards,
Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

22 COMMENTS

  1. Hello roopesh i have been follwing your vidoes those are good.. will you please help me in some quries in rs .

    question is
    I need to remove Tim Jordan from one dept manager as he is no longer part of the Team. He should be moved under differnt person in reporting.
    please mail me

    thankyou
    Regards
    Krishna

  5. cialis 5 mg Aside from all that, whether it s learning to orgasm, relieving aches and pains, releasing stress and tension, or rebuilding clitoral nerve endings so that orgasms are possible , this statement completely ignores and downplays the therapeutic use of vibrators before, during, and after a relationship ends

  12. 10 Leiomyomas can cause a wide array of symptoms, including menorrhagia, iron-deficiency anemia, pelvic pain and pressure, and subfertility. nolvadex pct for sarms I have held out all this time on taking the clomid because I thought if I just lose some weight.

  17. Plenty of well-known crypto personalities are taking part in the tournament. (Image: cryptocovid19) In a recent poker club review report, I mentioned that poker club reviews can often be biased. That’s true, but not necessarily in a bad way. Poker club reviews are usually written by people who have a stake in the poker club that they’re reviewing, either because they work there or because they have made significant investments with the club. Another aspect of poker club reviews that is often overlooked is that the poker club review report that is published is just a snapshot of the poker club at a specific time and place. If you would like to play for real money on a club-based poker app and get access to the softest real money poker clubs, please CONTACT US HERE or via Skype at: vip-grinders.asia. http://essexgigguide.co.uk/forum/profile/madonnawanliss Get 20 Free Spins No Deposit!*The welcome bonus contains 20 free spins in Book of Dead and 100% bonus (up to €300). Bonuses must be wagered 30 times. At the start of 2020 we have added a brand new offer to our website. From now on you can collect free spins no deposit at Betchan Casino. The great thing about this offer is that you will receive the free spins on one of the most popular slots around, the Book of Dead. When you sign up your free account today you will receive a total of 50 free spins. There is no deposit required to receive your free spins. All you have to do is open a free account. Once done, the casino team will add the spins to your account. This can take up to 24 hours since it is done manually. Although this is the case the free spins will arrive in your account within 3 to 4 hours in most cases.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

+ 3 = 13