I have a crosstab in a grouped report. Because the crosstab width can vary between one and several pages wide depending on the current group value this means that when using Page layout mode or exporting to PDF I get lots of blank pages in the middle because although for most group values the crosstab is only a page or two wide in some groups it can be several pages wide and this is making each group print that wide. The attached image probably explains this better.
Is there a way to dynamically suppress the blank pages and alter the page numbering - basically in the attached screenshot to hide the pages marked with a blue X ? I'm assuming this is going to require code in the report itself.
(If any examples could be in VB rather than C# that would be extra helpful :) )