We help IT Professionals succeed at work.

access report page break

vbnetcoder
vbnetcoder asked
on
47 Views
Last Modified: 2019-02-25
I want a page break in my report for each new instance of a field [first name].  how do I do this?
Comment
Watch Question

Software & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
how do I do that?
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
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
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Here's a picture..  Add a group by name section.  The example picture groups by year.
Group.JPG
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.