Apply Conditional Formatting Rules to Expandable Areas

Environment

Product

Progress® Telerik® Reporting

Description

How can I alternate the row style when I have grouping in the table and the group content is expandable?

Solution

To solve this issue, refer to the demo report and use the following approach:

1. Add a CSV DataSource with Group and Item columns.

2. Add a table that displays only the items and add a row group based on "= Fields.Group".

3. Set the Toggle Visibility action on "= Fields.Group".

4. Set conditional formatting to the "= Fields.Group" cell as follows:

    **Expression** `= RowNumber()%2`
   
    **Operator** `=`
   
    **Value** `= 0`

5. Set the conditional formatting to the "= Fields.Item" cell:

    **Expression** `= Exec("group", RowNumber())%2`
   
    **Operator** `=`
   
    **Value** `= 0`