Get cross-tab horizontal pages on the same page

[Former Member]

Hi there,

I have a report containing a cross-tab in a group header section so that there can be more than one cross-tab table in the resulting report. Any extra horizontal pages (if the number of columns exceed the page width) are always printed on the next page although there is enough space on the same page. The problem here is that the cross-tab table for the next header section does get printed on the same page, so u end up getting mixed tables:

Page 1:

Section header 1

Header 1	Header 2	Header 3	Header 4

Section header 2

Header 1	Header 2	Header 3	Header 4

Page 2:

Section header 1

Header 5	Header 6	Header 7	Header 8

Section header 2

Header 5	Header 6	Header 7	Header 8

So is there any way to force the next section always after the last section is completely printed or even better get Crystal to print the next horizontal page directly underneath the previous?

Many thanks in advance!

grt

[former_member11696 · Accepted solution]

Hi Robert,

The SDK will print the report the same way as CR Designer does so I moved your post to the CR Design Forum.

No, when you design crosstabs and the paper size is too small to fit horizontally it will push the rest of the crosstab to the second page. CR will then fill in the rest of the page with the rest of the report section info. It's always been this way and logical.

You may want to try enabling the New Page after in the first section and see if that works for you....

On screen this pushes the second cross tab to page 2 but you need to test to see if that works for your report....

Don

[Former Member · Accepted solution]

Hi Willie

Is there any way to limit the number of columns in a crystal report cross tab ? Or limit the number of columns per page when it expands into horizontal pages?