Cross Tab Multiple Columns

[jasonhuibers]

Is there a way to keep multiple columns on one page. I have the cross tab in a subreport and when I use the dhtml viewer I can not scroll to see the other columns...

Any suggestions

 

[lbass]

Some simple fixed might be to narrow the columns by either unchecking "show cell margins" in the customize style tab or to rotate the column headers 90 degrees and stretching them in height and then minimizing the summary cell width. Otherwise, the only way to make the crosstab "wrap" is to create groups based on ranges for the column field (it helps if you have a standard number of columns or at least one with sequential values), and then move the crosstab into a group section.

-LB

 

[jasonhuibers]

Do the columns have to expand horizontally onto another page - is there a way to have the columns wrap vertically?

 

[lbass]

That's what I meant. In the main report, you would create a formula that establishes ranges, and then place the crosstab in the group based on that formula.

-LB

 

[jade1977]

I have found the same solution here:

http://www.chelseatech.co.nz/samples.htm