This is a migrated thread and some comments may be shown as answers.

Crosstab drilldown not working

1 Answer 64 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Jennifer
Top achievements
Rank 1
Jennifer asked on 19 Jul 2013, 04:57 PM
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

1 Answer, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 24 Jul 2013, 02:26 PM
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.

Tags
Report Designer (standalone)
Asked by
Jennifer
Top achievements
Rank 1
Answers by
Stef
Telerik team
Share this question
or