How to Style Crosstab expanded cells differently

[B]

I have a basic crosstab on a report.  Everything works fine and appears as desired when all is collapsed.

When a group is expanded (based on Action = ToggleVisibility ), it works as expected, but everything blends together visually, with no visual distinction between the expanded cells and the cells that were visible before expanding.

What I'd like to do is style the expanded cells with a different background so they'll easily stand out.

This crosstab is similar to this demo: http://demos.telerik.com/reporting/product-sales 

In that demo, when one of the Years is expanded, the newly visible cells are the same in appearance as those before expanding.  e.g. If you expand 2002, the quarter values are visible and appear the same as the year values that were already present... The Q1 value of 4.9 appears the same as the 2001 value of 20.2 - is there a way to style the 4.9 cell differently?

Attached is picture of my crosstab and the desired results.

Thanks much!

 

[Katia]

Hello Daniel,

You can insert additional column (outside column group) and apply the white background to this column. The cells that need to be expanded can be initially hidden and with a different background applied.

Check the report attached here as a demonstration of this approach. This report is a simplified version of the ProductSales demo report where the additional column is inserted to show the sum for the column group that needs to be with white background. When you expand the group the detail cells are with a different background.

I hope this will be useful to you.


If your scenario or requirements are different please attach the report definition and the data for the crosstab in a support ticket so we can provide you further suggestions.


Regards,
Katia
Telerik by Progress

[B]

Thanks Katia, that does the trick beautifully!