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
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
0
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
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.