How to Print one Record per Page in a Report

stevid
stevid used Ask the Experts™
on
I am trying to create a report that is basically a quote. It is based on two tables, one table has things like date, customer, job etc and the other table has the order details,

I have all of this working fine and displaying correctly except when i go to view it or print it all of the records are on top of each other,

Also i have added a few lines that i want at the end of the quote such as discount, total and that but i only have a Page footer so it only appears at the end of the page,

I am using Access 2010 and cant seem to find many options for headers and footers so am not getting too far,

Im sure it is a fairly easy thing to do but i cant work out how,

Any ideas how to solve this as its driving me mad, Thanks,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
You probably need to setup a Group on the Order#.  

Then in the Group footer property "Force new page", set the value to "After Section"

This should force each order to print on its own page.

Author

Commented:
how do i go about grouping the order??

I have spent ages at this stage laying the whole thing out so dont want to mess it up at this stage,

Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
I don't have 2010 on my current computer, and I know the interface (ribbon) is different than 2007 (thank you Microsoft - NOT) , but give this a try:

Open the report in design view.

There should be a Group/Sort option on the ribbon that when clicked displays a window at the bottom of the screen.  In that window, click the "Add a group" option and select your OrderID (or other appropriate column) to Group by.  

You should see a bar in your report that reads "Order_ID Header".  You don't actually have to put any controls in this section, but it is common to put the control that is being grouped by in that section.  If you don't put anything there, then just size that section to height = 0"

You will also see a bar in the Group, Sort, Total window at the bottom of the page.  Click the "More >" button in the bar in the Group, Sort, Total section and change "without a footer section" to "with a footer section".  Then go back to the report, click on the Order_ID Footer" bar and display the properties.  Then go to the Format tab, and set the ForceNewPage property.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
Without knowing what the final output is supposed to look like, (or even what the report looks like now) we are just guessing here.
(ex.:What records exist for a "Quote")

So I agree with fyed on the Force new page setting, but I am a bit hazy on what you need when you say "headers and footers" (Page Headers? Group Headers? Report Headers?...etc.)

Can you post and example of what you have currently and also post a graphical example of the exact output you are expecting?

<I have spent ages at this stage laying the whole thing out so don't want to mess it up at this stage,>
So make a copy of the report as a backup...

To Group a report in Access 2010:
Open the report in design view
Right click on any part of the report
Select "Sorting and Grouping"
Click the "Add A Group" button
Select the field you want to group
A Group Header for this new group will appear.
If you want a Group Footer as well, click the "More>" button and select: With A footer Section
Then Right Click in the empty Group Footer section and select "Properties".
Then set the "Force New Page" property of this footer to: After Section
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
^
If you are not up for all of this, then simply use the Report Wizard to recreate the report, it will walk you through all the steps.


;-)
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
sample DB with report is attached for reference
Database201.accdb

Author

Commented:
Have it sorted now, Turns out all i needed to do was select the option to display the report footer and then enter my details there,

Thanks for all the help,

Regards

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial