Crosstab drilldown not working

2 posts, 0 answers
  1. Jennifer
    Jennifer avatar
    16 posts
    Member since:
    Aug 2012

    Posted 19 Jul 2013 Link to this post

    I have a report where I am using a crosstab in the report header section to display summary test data for all "sites"  My crosstab has 1 row group and 3 nested Column groups (Category, Testtype, Sitegrp).  The testtype field has a toggle visibility action that will display the site group columns when expanded.  Everything works as planned in the report header section.

    When I try to duplicate this same table in the site group header section and add a filter to the new crosstab's sitegrp2 to restrict the site group columns to just the site in the group instead of displaying all sites, I have problems. 

    When I use the following expression to filter the sight group in the second crosstab, the toggle will not work.  It will display correctly if I have no toggle and have everything visible. =

    The toggle WILL work in the group header crosstab if I hard code the filter. Which is a problem, since it shows the one site's data for each site. = ='Mysite'

    If the page refreshes, the crrosstab in the group header section no longer displays the sitegrp2 columns for either scenario, even though I have the visibility property set to True.

    Is this a bug or am I doing somthing wrong.

  2. Stef
    Stef avatar
    3610 posts

    Posted 24 Jul 2013 Link to this post

    Hello Jennifer,

    Basically in your scenario you do not need to set a filter expression, but supply only the current group data to the Crosstab item. This can be done setting ReportItem.Parent.DataObject to the Crosstab.DataSource property with binding.

    I hope this helps.


    Have you tried the new visualization options in Telerik Reporting Q2 2013? You can get them from your account.

Back to Top