Post reply

Highlight every other row based on group

  • May 1, 2017 at 12:19 pm

    #321189

    I have a report with the Parent group, DeliveryDate and a Child group, AccountNumber. The AccountNumber group has two lines for each record. How can I set up the report to highlight every other AccountNumber along with both lines?

  • May 1, 2017 at 2:23 pm

    #1940609

    NineIron - Monday, May 1, 2017 12:19 PM

    I have a report with the Parent group, DeliveryDate and a Child group, AccountNumber. The AccountNumber group has two lines for each record. How can I set up the report to highlight every other AccountNumber along with both lines?

    Usually you can use the RowNumber function and use an IIF expression for the background color - an example is here: 
    Report Builder Functions - RowNumber Function

    That doesn't always work for every situation though . This thread has several different options listed - pretty good reference for the alternating colors:
    Add alternating row color to SQL Server Reporting services report

    Sue

  • May 2, 2017 at 4:30 am

    #1940672

    Thanx.

  • May 17, 2017 at 3:24 pm

    #1943010

    =Switch(RowNumber(AccountNumber) Mod 2 = 0, "HoneyDew", RowNumber(AccountNumber) Mod 2 <> 0, "White")

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply