how to eliminate empty page on "page break before"

[Simon K]

Its probably been asked before...

If I have a report that is sorted and summarised by 3 fields

In this case Customer/Project/Deliverable

I would like a page break before each customer and before each project - but not the "first" project for each customer as that creates an empty page?

How do i configure the part set up?

Many thanks

[comment]

What do you mean "an empty page"? There shouldn't be any empty pages, if there is anything in a leading sub-summary by customer. Otherwise, you'd need only a page break before each project.

[Simon K]

Yes - I agree "empty" was a misnomer see below

In each sub summary part is the relevant field (eg customer name in the customer sub summary part) and a subtotal of hours.

What I would like is each customer to start on a new page and each project to start on a new page unless its the first project when it should start on the same page as the customer sub summary.

As you say if you put a page break in before each customer and before each project it does that literally - which means the first page for each customer is "nearly" empty just containing the customer name - which is a waste of paper - (especially for all the single project clients) and divorcing the customer name from its projects.

Its not the end of the world I just wondered if there was a way of making the report slightly more digestible

[comment]

I think you could get rid of the sub-summary by customer part, and replace it with a calculation field along the lines of =

Case (

Customer ≠ GetNthRecord ( Customer ; Get (RecordNumber) - 1 ) ;

Customer & " " & GetSummary ( sTotalHours ; Customer )

)

Place this at the top of the sub-summary by project part, and make the rest of the fields slide up and reduce the enclosing part.

[Simon K]

Many thanks Michael - I will try that - I can see that the calc field needs to go into the timesheets table