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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress Orphaned Group Header at Bottom of Page

Status
Not open for further replies.

MrBillSC

Programmer
Aug 6, 2001
592
US
I have a report with three group headers. Occasionally one or more of the group headers will print at the bottom of a page with no detail records, then print again at the top of the next page (I have 'Repeat Group Header on Each Page' on). Is it possible to suppress print at the bottom of a page if there will be no room for detail records?
 
no...this is the bane of all report page splitting.

You can try first to see if enabling the Group "Keep together" solves your problem (to do this right-click on the group header in the grey margin and select "Change Group" then enable the "Keep together"

But sometimes this will leave ugly gaps in your printouts.

Another thing you can do (in the same dialog box as enabling the Group "Keep Together" is to remove the check for "repeat Group header on new page"

but this sometimes doesn't look good if there is just the header on one page and the information on the next page.

THE PROBLEM IS that Crystal doesn't know where it is on the page as it prints the information.

If you knew you were near the bottom of a page with just enough room to print the Group header, then you would split to a new page before printing it.

In the quest (at customer's request) for the perfect page split, I created formulas that estimated the position of the printing by adding up the report lines as they printed taking into account that some lines were bigger than others. Then by trial and error I arrived at a number which I could use to "prematurly" split to a new page.

It worked pretty good but was time consuming and I would only do it for things like legal documents, invoices or other reports that the client wanted to look "perfect" (and they were willing to pay for this perfection ^-^) Jim Broadbent
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top