Alternating the Cell Background Color by Table Group

Environment

Product

Progress® Telerik® Reporting

Description

What conditional formatting can I use to alternate the detail cell background color based on table groups?

Cause

For alternating detail rows in a table, I use conditional formatting based on the following Expression and set different colors for odd and even rows:

RowNumber()%2

The % is the remainder after the division operator. Then, I set the Expression to depend on the group:

=RowNumber('groupName')%2

However, in the group, the row numbers increase within the group. That's why the color will alternate within the group rows, whereas my requirement is the rows of each group to have the same color and for this color to change between groups.

Solution

To handle the issue, use the following Expression:

=RunningValue("tableName", CountDistinct(Fields.groupingFieldName))%2

The RunningValue data function assures that only the values up to the current one get respected. The CountDistinct aggregate function counts the distinct grouping values, in this case, up to the current one. This approach will leave 1 for the first group, 2 for the second, and so on. Hence, the Expression will return 0 for the even groups within the table and 1 for the odd ones.