Problem with report page break

Posted on 2010-01-05
Last Modified: 2012-05-08
I have created a report which groups on Division and department and has a summary group for each employee. I want the report to page break on each change of divison and department. It is doing this correctly in some parts of the report but not others. I have attached several screen dumps and the SQL Select which shows my selected data to be correct. I have tried playing about in section expert with page before/after but all to no avail. The left hand preview of the data in Crystal (see dumps), also looks fine to me? Your help is apprieciated
Question by:John_Merrick
    LVL 77

    Accepted Solution

    It looks like you need Page-break-after set for gf2.  
    I can't say anything else for sure because I don't know whether you are trying to keep certain sections together or not, although I suspect you would need a page break after gf1 as well.
    LVL 1

    Author Comment

    Hi Peter
    Thanks very much. That has had the desired effect, only one tiny problem is that it has also caused the DIVISION totals to print on their own page, I would have liked them to stay with the departmant totals. If you have any thoughts on that I'd be grateful, but it is much better now.
    LVL 100

    Assisted Solution

    Try using a formula for the new page after
    Something like

    Not OnLastRecord and  {DivisionField} = Next({DivisionField})

    LVL 77

    Assisted Solution

    You can make the pagebreak conditional.

    You might try a formula that looks something  like..

    if onlastrecord or (next({table.division})<>{table.division}) then
    false //no page break
    //page break
    LVL 1

    Author Closing Comment

    Thanks Guys, all working a treat...

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now