Crosstab is too wide.

[pokerace]

C10
Interbase

I have a crosstab with only a couple of rows, but with a bunch of colums making the chart extend to several pages in width, but leaving a ton of white space below. Is there a way to have the cross tab stop before or at the right margin and contine on below, so that the data just appears on one page?

For example,

From this:
================
RRRRRRRRRRRRRRRR
C Name 123456789abcdefg
C Name 123456789abcdefg
================

To this:
================
RRRRRRRRR
C Name 123456789
C Name 123456789

C Name abcdefg
C name abcdefg
================

 

[lbass]

You could consider pivoting the crosstab. Or you could create a formula that clusters columns, and then insert a group on the formula, and move the crosstab into the group section. If the crosstab is a simple one, you could use a variable to count the columns and insert a group on that. For more help, please provide the column name, datatype, and a sample of what it looks like.

-LB