New to Telerik Reporting? Download free 30-day trial

Alternate the Cell Background Color by Table Group


Product Version 14.2 20.1118
Product Progress® Telerik® Reporting


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


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:


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


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.


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.

In this article