Hi,
I'm trying to create a report that's very similar to the Crosstab example in the Telerik Reporting demo. (Please refer to that demo) Except that what I need to do is I want to hide Quarter columns for lets say year 2001, 2002, 2003 and only show the Totals columns for those years. For the 2004 grouping it should not hide the Quarter columns. I tried to set the hide each textbox in the ItemDataBound event by setting Visible=false on all the textboxes for that those years but it's not working. Does anyone know how to do it?
Thanks.
I'm trying to create a report that's very similar to the Crosstab example in the Telerik Reporting demo. (Please refer to that demo) Except that what I need to do is I want to hide Quarter columns for lets say year 2001, 2002, 2003 and only show the Totals columns for those years. For the 2004 grouping it should not hide the Quarter columns. I tried to set the hide each textbox in the ItemDataBound event by setting Visible=false on all the textboxes for that those years but it's not working. Does anyone know how to do it?
Thanks.
1 Answer, 1 is accepted
0
Hi Brian Ho,
The Crosstab (also Table and List report items) depend on the data and thus visibility of columns/rows can be controlled by their presence. To illustrate the approach I will use the ProductSales report from our examples. The steps are:
Hrisi
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items.
The Crosstab (also Table and List report items) depend on the data and thus visibility of columns/rows can be controlled by their presence. To illustrate the approach I will use the ProductSales report from our examples. The steps are:
- Open the report in the designer and show the Group explorer (see GroupExplorer.png)
- Define new Report Parameter DetailsForYear as shown on ReportParameter.png. Use the same DataSource as for the report. The parameter should be MultiValue parameter.
- Select the Crosstab (or any cell in it) and invoke the Edit Filter dialog for the Qtr Column group. Enter the filter expression as shown on SetFilter.png.
- Preview the report - see the Preview.png. Now it is possible to select for which year to show Quarter columns and hide it for the rest.
The same can be used for the row dynamic(autogenerated) groups such as ProductSubCategory.
Kind regards,Hrisi
the Telerik team
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 Public Issue Tracking system and vote to affect the priority of the items.