Hi, I'm sure you guys are fed up listening to my tales of whoa, but here we go again.

I have a four page report that works fine, each footer displays the pupil name and class at the bottom of each page. This works perfectly, until we select the option to print without the first and last pages (effectively only printing pages 2 and 3). What happens then is that the first pupil's name appears on the first page, then the second pupils name prints on the third and fourth (which is effectively the second page of the first pupils report and the first page of their own), the sequence from there on is correct, albeit a page out.

I've tried changing the page breaks, that doesn't work. I've treid grouping the footers, that doesn't work, all that happens is that I end up with blank pages at the beginning of the document.

Any suggestions please??:eek:

Try using the "Page footer" as opposed to the "report footer." The last student's name should appear in then page footer.

Try using the "Page footer" as opposed to the "report footer." The last student's name should appear in then page footer.

Thanks, but it is page footers we are using for them. We don't use report footer, although we do use report header.

It looks like we are going to have to create a separate report so that the current one will print all four pages and the new one will print only the middle two pages.

We have tried everything, inserting page breaks etc. A page break after page 2 sorts that problem, but creates a blank page (with the footer) after page 2. It's driving me nuts.

Page 3 starts formatting before the 2nd pupil is identified.

Try hiding the first and last page via the report OnFormat event. You'll probably have to hide each section of the report, then display eachy section for pages 2 and 3.

Where there's a will, there's a way to get into it.