Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can I limit number of columns for a cross tab per page
- Thread starter JSeidel
- Start date
synapsevampire
Programmer
Not sure what the difficulty is with virtual pages, but you can select any row and resize it (height and width), so by increasing the height you will have less rows.
-k
-k
This is based on a suggestion by Ken Hamady in thread 149-575997 as fleshed out by Carynbo. Create a group based on your crosstab column field. Let's say it's a simple field that contains values from A to Z. Then write a formula {@colsperpage}:
if {table.field} in ["A" to "M"] then 1 else 2
Group on this formula in your main report, and then place the crosstab in the group header or footer. Then go to format section and for the section where you placed the crosstab, check "new page after."
-LB
if {table.field} in ["A" to "M"] then 1 else 2
Group on this formula in your main report, and then place the crosstab in the group header or footer. Then go to format section and for the section where you placed the crosstab, check "new page after."
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question