Removing blank page after crosstab object

[Former Member]

http://stackoverflow.com/questions/16901682/removing-blank-page-after-crosstab-object

I posted my question on Stack Overflow but no responses.

I have a large (height-wise) crosstab object in Crystal Reports 2011. There's months on the column grouping and on the row, there is just a dummy grouping (constant value). There are about 25 KPIs (constant number). Although the width is dynamic length, the height is constant. See first image below for the general layout.

I've set Show Summarized Labels to True and I've hidden the Totals. This has worked well, except that CR outputs a blank page in Preview after the cross tab. The first page in Preview shows the cross tab fitting nicely in the page but there's a blank page after. My suspicion is that in design view, the crosstab spans longer than the page size due to the Totals (which I've suppressed). See the second image below for Design View. Why is CR including the Totals when figuring out the page size? I'd need to make the page size up to 15 inches in height even though the totals are hidden. Any suggestions?

I've suppressed/deleted all subsequent sections. I need this to be in landscape as well..

[abhilash_kumar · Accepted solution]

Hi Gabe,

I just tested this and it seems you're right! In the Preview Mode, when I click (in the blank space on the top left) the crosstab, the outline stretches all the way towards the end of the page.

I get the same feeling that it tries to take into account the suppressed Grand Totals too and leaves behind as much space as the Grand Totals would have occupied.

I've tried various options and ways to get rid of that space and it stop it from printing the new page, to no avail. If you have a Support License with SAP, I would suggest that you should let them know by way of a Support Ticket.

I'll think on some more ways to get rid of it in the meantime.

Take care.

-Abhilash

[Former Member · Accepted solution]

Abhilash,

Have you found anyway around the issue with blank pages appearing after using the crosstab function? I've tried a number of things but I've had no luck.

Regards,

Bill

[abhilash_kumar · Accepted solution]

Hey Bill,

I did not spend much time on this after answering this thread.

I'll let you know if I find anything.

-Abhilash