Cross-Tab Formatting Question

[GMAN33]

Hi All

CR XI

I have a crosstab within a header section of the report. Is there a way of splitting the crosstab so that it stays on one page? Almost like wrapping it to the edge of the page

Thanks for the help

 

[lbass]

So you want to eliminate the virtual pages? Please identify your row and column fields, and show a sample of how the column field displays--specifically, it would help to know whether columns have any consecutive numeric values.

-LB

 

[GMAN33]

Virtual Pages?

The crosstab is quite simple

ROW COLUMN SUMMARY
Page 1 Country Name Total People

So if I have it like this, the cross tab gets quite long and fills up multiple pages.

What I would like to do, is when it gets to the bottom of the page, continue in the next column, like it is reading within a book...so that the entire page is utilized

Thanks for the help/suggestions

 

[lbass]

I'm confused. This doesn't look like a crosstab. How could Page 1 be a rowfield in a crosstab?

A virtual page is a page that appears to the right of the usual page when crosstabs don't fit horizontally. Again, did you insert a crosstab or are you only calling your report a crosstab?

If instead you have a set of data that you want to appear in columns, go to the section expert->details->format with multiple columns and then set the layout in the layout tab.

-LB

 

[GMAN33]

Yep...I inserted a crosstab...Page 1 is the data

The crosstab looks like

Page 1 Germany 30
Page 2 UK 22
Page 3 USA 44

So what I would like to do is break the crosstab like below so that it fits on one page...I may have a couple of more columns that will be added...does it matter?

Page 1 Germany 30 Page 22 Germany 10
Page 2 UK 22 Page 23 Mexico 14
Page 3 USA 44 Page 24 USA 21
....

 

[lbass]

Crosstabs don't wrap like this, and I don't think you need a crosstab. Place the fields in the group header section for {table.page} (if that's your group), place the people field in the detail and insert a summary on it, dragging it into the group header, and then suppress the detail section. Then go to the section expert->details->format with multiple columns->layout tab->set width/gap, down then across, and check "format group with multiple columns".

-LB

 

[GMAN33]

Thank you LB...I will give that a shot...it was requested to have a crosstab...but what does management know ;-)

I appreciate the help

 

[synapsevampire]

Management drives software architecture?

Get your resume out there

-k