Prevent Page Breaks

[tdiboll]

How do I set up a page break formula to keep data from a single record from printing over two pages?

Thanks,
Tracey

 

[ChiTownDiva]

Hi, Tracey...

Is it printing over two pages because you're running out of room at the bottom? If that's the case, then there's nothing you can do except change the margins.

Try to figure out at what point it's rolling over to the next page. Is it because of the size of the field? You might need to write a formula to Trim() the field or you may need to use a smaller font.

If none of that works, then you may need to create a summary that counts the field and then group them and check the "Keep Group Together" box.

ChiTownDivaus

 

[Madawc]

In Crystal 8.5, right-click on a section to get [Format Section], which includes 'Keep Together'.

If you are using several detail sections for a single record, you'll find you can set the format for [Details] as well as [Detaila] etc.

On individual fields you can right-click for [Format Field] and check [Keep Object Together]

Madawc Williams
East Anglia, Great Britain

 

[kenhamady]

If you have a 'can grow' object on the details, the section keep together might not work. You can use an invisible group. Create a group for each Detail and hide the GH and GF. Then set the "keep group together" property for this group (not for the sections). This will force the Detail to either fit ALL on the current page or print ALL on the next page.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Ngolem]

If you are concerned about an individual field only splitting across a page then all you have to do is enable the "Keep Object Together" for the field itself.

If it is too big to fit on the page Crystal will put the whole field on a new page....this can make for unwanted blank space at the bottom of the page....this is always a tradeoff.

Jim Broadbent