Can I display a crosstab ONLY on last page, but not in the PageFooter?

1 Answer 114 Views
CrossTab Report Designer (standalone)
Joan
Top achievements
Rank 1
Joan asked on 15 Dec 2022, 05:04 PM
I have a report that can potentially contain multiple pages.  I have a crosstab in the detail section that contains a total that I would like to display on only the last page of the report.  My plan was to make the grand total row of that crosstab not visible until the last page.  I know that in the footer, I would need to check PageNumber and I believe CurrentPage to see if they match to determine if its the last page.  The issue I'm having is that you can only access PageNumber from the report header and/or footer, but you cannot put a crosstab in a footer.  Is there a way to display a crosstab on only the last page?

1 Answer, 1 is accepted

Sort by
0
Momchil
Telerik team
answered on 20 Dec 2022, 02:05 PM

Hi Joan,

Thank you for reaching out.

Only the Page Header/Footer sections cannot contain data items, while the Report Header/Footer sections can. Since the Report Footer Section is printed only once at the end of the report, as described in the Report Structure documentation article, you can place your Crosstab there as long as it contains aggregated data.

To make sure that you are in the Report Footer section, right-click on the empty space surrounding the design surface and verify that the Report Footer button is toggled on (highlighted). Afterward, go to the Report Explorer Tab, click the Report Footer Section, and you should be able to add a Crosstab item.

I hope this information helps you achieve the desired result.

Kind Regards,
Momchil
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
CrossTab Report Designer (standalone)
Asked by
Joan
Top achievements
Rank 1
Answers by
Momchil
Telerik team
Share this question
or