Keeping objects together on a print

[jwaldner]

I have a cross tab that I am working on that groups data by month and then week on the rows and other data on the columns. everything sums fine. The problem shows up when I print. The month group is printed as shown so I have room for more columns across the page [for custs].

The problem is, on a page break, the month is split. I have that object set to stay together but it still gets split on a new page. is there a way to control this?

the rows are set up this way:
Cust1 Cust2 Cust3 Total
M week1 1 2 3 6
o week2 2 1 1 4
n Week3 4 2 3 9
t Week4
h
1

M Week1
o Week2
n week3
t Week4
h
2

On a print I get:
Cust1 Cust2 Cust3 Total
M week1 1 2 3 6
o week2 2 1 1 4
n Week3 4 2 3 9
---------page break---------
t Week4
h
1

 

[MCuthill]

jwaldner,

If your crosstab is at a group level; right-click on the group header (or footer), select "Change Group" from the menu, click the options tab in the dialogue box and then check the "Keep Group Together" option (these steps are from Crystal 10).

I hope this helps.

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[jwaldner]

I already have that option checked. The cross tab is in the Report header.

 

[jwaldner]

I need it to print like this:
the month is an actual group printed at 90 degrees. its only function is to contain the weeks group.

Cust1 Cust2 Cust3 Total
M week1 1 2 3 6
o week2 2 1 1 4
n Week3 4 2 3 9
t Week4 1 1 1 3
h
1
---------Page break------------
Cust1 Cust2 Cust3 Total
M week1 1 2 3 6
o week2 2 1 1 4
n Week3 4 2 3 9
t Week4
h
2

M week1 1 2 3 6
o week2 2 1 1 4
n Week3 4 2 3 9
t Week4
h
3

 

[lbass]

The only way I think you can control that is to adjust the page footer or page headers to force the crosstab to display a little differently. This means you will need to move it to the report footer so that these sections are available to you.

I understand the issue as I work with crosstabs a lot, but you must remember that a crosstab is a single object and therefore you don't have control over page breaks.

The only other option would be to consider placing the crosstab in a group section maybe based on months and then format the page break after a certain number of groups--but this messes up any grand totals you may have.

-LB

 

[jwaldner]

Thanks all, don't have the exact solution I want but it gives me some options to think about.