Search code examples
sqlreporting-servicesssrs-2008reportbuilder3.0

Changing multiple row colours in Report Builder

I would like to change the row colours in the attached image so all rows match with the value in NAME column.enter image description here

So I want the related 2 rows in CUST CODE, DEL TO, CUST NAME and then the related 3 rows in ORDER NO to be the same colour.

Then i would like the colours to alternate for the next NAME value and so on.

Is this possible? I know how to alternate row colour when each result is one row only, but unsure how to do it with this kind of result.

So to clarify, for NAME (AHe) all rows to be 'lightgrey', NAME (AHO) all rows to be 'whitesmoke', NAME (JH) all rows to be 'lightgrey' etc...

Solution

  • I've used something similar to the following in the background color expression:

    =IIF(RUNNINGVALUE(Fields!Name.Value, COUNTDISTINCT,"MainDataSet") MOD 2 = 0, 
       "LightGrey", 
        "WhiteSmoke")

    There may be another way to do this using ROWNUMBER() or another alternative as well.