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?
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?