Printing many records double sided

[Lupson2011]

Hi, I have a report I have created which I need to bulk print



However, depending of the amount of content of each record, some are 2 page long and some are 3 pages long. This poses me a problem as I want to print double sided.

So, in my example, the first record is two sides long, which is fine for double sided. However the record following that is three sides long, with the one after that two sides long. This means when I print, the first one prints fine on double sided, however, the next two become merged, with the first page of the third record starting on side four of the second record? Hope that makes sense?

What i need is something which distinguishes between records and starts printing on a new page for each record. I have a unique key being the field ProjectURN. Is this an impossible ask?
Help

marc

[June7]

Could try a page break control in the Detail section.

[Lupson2011]

thanks for that, alas I have tried that. What it does is create problem the other way round. The first record still prints fine, but then you have a blank page and the first page of the next record which prints on two sides..so same problem again

thanks for suggestion though

Marc

Could try a page break control in the Detail section.

[June7]

Possibly the complication is that a record extends over multiple pages.

Try setting the following properties of Detail section:
Force New Page: Before Section
Keep Together: No

If that doesn't work, only suggestion I have is to print records as separate reports. This would mean code that loops through a recordset, pulls ProjectURN value from each record and use it to filter the report to that one record and print.