Hi all - I'm only a new registered user here, but the forum has helped me out a lot - but I'm stuck with this one!

I've been searching everywhere for an answer to this but no luck. I've only got limited abilities in Crystal Reports. Using CR 2008.

I've got an invoice that is split into Services and Expenses. Expenses are detailed in a sub-report.

What I want to do is force a new page at a section before the Expenses sub report if the whole invoice is more than 1 page.

I'm currently doing this by a setting "New Page After" in section expert if Services are Not $0 and Expense are not $0. along the lines of New Page After: {Table.Services} <>0 and {Table.Expense}<>0

Problem is if there is only a couple of entries for services and a couple for Expenses, this may fit on one page, but since both are not $0 it will still force a new page. I can't really do it by forcing new page if there are more than 3 service entries, as 1 service entry could in theory take up the same space as 5 small service entries.

I've tried the following workaround, but still no luck.

Created a Page count formula that will only show the total page, so if it's 2 pages, then the number 2 will show.

NumberVar startNum := 0; ToText((TotalPageCount + startNum), 0)

I then tried to conditionally force a new page using section expert with the following:

{@PageCount}>'1'

End result is that the page will break at the section even if all info will fit on 1 page.

Hope above makes sense and hoping someone may be able to help!

Thanks

Collo

Problem is that total page count is determined after all of the records are loaded. So you don't know how many pages in total there are for your main report until after all the records have been processed.

Thanks for that - sounds about right to me.  Looks like no way around it.

One way of doing this would be to create a record count formula with a Global variable that counts the lines per page. Reset this variable in each report header, then base you new page creation on the record count formula. You would need to play with the new page after formula to see what will fit on each page.