I have a crosstab table with an unknown number of rows and columns, and my reports are ending up with blank pages because the crosstab table grows off the page to the right.
Is there any way to limit the number of columns per page in a crosstab table?
I have read the article, How to: Create Multi-Column Report - Across the Page and Then Down, but the steps aren't working for my crosstab table. I can make it work for regular tables and list items, but not crosstab tables.
Is there anything I can do to prevent the blank pages from being added to my report?
Thanks!
Ps. I asked a very similar question 18 months ago, and Stef suggested using a custom PageSettings' PaperKind and PaperSize. Unfortunately, I only have access to the standalone Report Designer, and I don't seem to have access to those fields. Maybe there's something I'm missing?
2 Answers, 1 is accepted
Rank 1
You may use Column Grouping in the Crosstab so that each group contains number of columns that can fit on a single page. Note that starting with Telerik Reporting R2 2018 (12.1.18.516) Table/Crosstab items support page breaks before and/or after each TableGroup instance. This is supported in both horizontal and vertical direction and is controlled using the TableGroup.PageBreak property. More information can be found in Understanding Pagination article.
The solutions suggested by Stef in Tall and Wide table causing extra pages in report forum post are also valid. The PaperKind and PaperSize properties can be modified in the Standalone designer - check the attached screenshot.
Regards,
Todor
Progress Telerik