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. 

    =Fields.site = =ReportItem.Parent.DataObject.site


    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.

    =Fields.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.

    -Jennifer
  2. Stef
    Admin
    Stef avatar
    3053 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.

    Regards,
    Stef
    Telerik

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

  3. DevCraft banner
Back to Top