Access 2K report question - page break issue

R

Ray W.

I have a little report that I need to be broken out by manager.

The report is grouped by Manager, then by department, with the detail
following the department. I would like the report to generate a page break
after each manager's department's data has been printed. How do I make this
happen?

E.g. Manager A, Department A - page break
Manager A, Department B - PB
Manager B, Department A - PB
Manager B, Department B - PB... etc.

Thanks,
 
M

Marshall Barton

Ray said:
I have a little report that I need to be broken out by manager.

The report is grouped by Manager, then by department, with the detail
following the department. I would like the report to generate a page break
after each manager's department's data has been printed. How do I make this
happen?

E.g. Manager A, Department A - page break
Manager A, Department B - PB
Manager B, Department A - PB
Manager B, Department B - PB... etc.


Set the Department group's header sectiom's ForceNewPage
property to Before section.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top