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

[Joan]

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?

[Momchil]

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