asked on

Crosstab at the Report Footer

Hi! I have a Crosstab showing the totals of my companies at my report footer. The problem is: I don't want the crosstab to be cut in half at the end of the paper, and to throw the rest of the information to next page. Is there anyway for me to set the cross tab to go to the other page automatically?

Thanks in advance

Mike McCracken

Is that the only thing in the report footer?
If so you can use the KEEP TOGETHER option on the Report Footer in the Section Expert

Right click the RF in the left margin
Click SECTION EXPERT
Check the KEEP TOGETHER box

If there is other information in the report footer
Create a second report footer and put the cross tab in it.
Use the above trick on the cross tab section

mlmcc

Gabriell Porto

ASKER

Nice! One more thing: Is there a scenario where I can make the crosstabs continue the data display on the side when it reaches the end of the page?

Mike McCracken

What do you mean?

Are you trying to do 2 columns?
As far as I know only the detail section can have multiple columns

mlmcc

Gabriell Porto

ASKER

Image I have a Crosstabs with 5 Clients and their totals

Total Total
Client 1 xxxxx Client 4 xxxx
Client 2 xxxxx Client 5 xxxxx
Client 3 xxxxx
____________________
--- END OF PAGE ---

Like it pushes the rest of the crosstabs to the side?

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gabriell Porto

ASKER

"I assume the report footer available space is variable so sometimes all 5 fit and other times it is split?"

That's exactly what I meant, altought I'm having to much work with the report. I'm gonna leave it the way it is.

Thank you very much for your support, mlmcc!