Link to home
Start Free TrialLog in
Avatar of vbnetcoder

asked on

access report page break

I want a page break in my report for each new instance of a field [first name].  how do I do this?
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vbnetcoder


how do I do that?
To be more exact i need a sample...i reckon that you have grouped the records via [First Name]
so it should have a header and a footer (if not add) ...just go to the space in the Footer and put a Page Break
Here's a picture..  Add a group by name section.  The example picture groups by year.
User generated image
You accepted an answer that says to do this in the footer.  As you can see by my example, the setting is in my header and I am using Before Section.  I suppose the footer will work if you use After Section although you may end up with an extra blank page at the end of the report.