suppressing empty pages

[apirker]

Hello List!

I have a Report with a Cross-Tab. The Reports shows multiple Cross-Tabs among each other. If one of the Cross-Tabs gets to wide (if too many products are chosen) it preads to a second page.
All the other Cross-Tabs are smaller than one page, but all have a second empty page besides them.

Now if i want to print the Report i have a lot of empty pages...

Can i force BO not to print empty pages?


cheers
Anton

 

[promero]

You can stretch the report to fit in one page with. Go to the File menu, Page Properties option.

A more complex, and probably inviable, solution is to add a vertical break to the crosstab from a variable derived from the dimension you use in the horizontal edge. Then replace the horizontal dimension with another variable that will return adequate values.

For example, supose you have a table with <Order> as horizontal key, and <K> as vertical key. The table could look like this:
[tt]
----------------------------------
K \ Order 0 1 2 3 4 5 6 7
A x x x x x x x x
B x x x x x x x x
C x x x x x x x x
----------------------------------
[/tt]
We know that <Order> will have all values between 0 and some integer (no gaps).

Suppose you want to show only 5 columns for <Order>, breaking to a &quot;new table&quot; each 5 values of it, like this:[tt]
-------------------------
K \ Order 0 1 2 3 4
A x x x x x
B x x x x x
C x x x x x
-------------------------
K \ Order 5 6 7
A x x x
B x x x
C x x x
-------------------------
[/tt]
To acomplish this, follow this instructions:
[ol][li]Create a dimension variable <Order Column>=Remainder(<Order>,10).[/li]
[li]Make an horizontal break by <Order Column>, without header nor footer.[/li]
[li]Create a dimension variable <Order Row>=<Order>-Remainder(<Order>,10).[/li]
[li]Make an vertical break by <Order Row>, showing the header.[/li]
[li]Put the expression =Max(<Order>) in the header of the <Order Row> break.[/ol]
Note that this example is easy to solve, because <Order> has known values. Other cases can be more complex.