Conditional Formatting Not Applied to the Entire Row

Environment

Product

Progress® Telerik® Reporting

Description

When the Crosstab contains both dynamic row groups and dynamic column groups, the Conditional Formatting set to an entire Crosstab row with an Expressioin like:

= Fields.DataFieldName  =   SomeValue

may not be applied to particular cells. These cells are in column groups that do not contain data for the specific row.

Solution

The observed behavior is expected. The Conditional Formatting is applied to report items like TextBoxes and not to table cells or rows. The Reporting engine determines the data for the report item in the cell by the intersection between the row group and the column group it belongs to. When one of the groups has no data, the intersection is also empty. For that reason, all the data fields in the Expression Scope will be null and the Conditional Formatting rule will return false.

The solution is in the formatting rule to take the data field value in the scope only of the group that contains data. For example, when this is the row group :

= Exec('rowGroupName', Fields.DataFieldName)  =   SomeValue