How to Style Crosstab expanded cells differently

3 posts, 1 answers
  1. Daniel
    Daniel avatar
    3 posts
    Member since:
    Jun 2013

    Posted 28 Sep Link to this post

    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: 

    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!


  2. Answer
    Katia avatar
    240 posts

    Posted 30 Sep Link to this post

    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.

    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft R3 2016 release webinar banner
  4. Daniel
    Daniel avatar
    3 posts
    Member since:
    Jun 2013

    Posted 03 Oct Link to this post

    Thanks Katia, that does the trick beautifully!
Back to Top