How can I print 1 record per page?

G

Guest

Hi every one, I have a report that print a job of houndred of Orders at the
time,
some times the order has one record, some times many.
I have sorted the report by Order, it does the sorting fine but How can I
print each Order on its page(s) ?
The report does the sorting just fine but If the Order has only 1 record,
the next Order will print rigth after on the same page, and need to separate
the report by Order.

Thanks for your help. I have tried many things but I can not get it rigth.
 
G

Guest

When the Sorting And Grouping box is open, select for the order to add a
group footer.
In the Order group footer add a page break, that way a new page will start
for each order

The Page Break icon in the toolbar look like two half pages with a triangle
between them
 
F

fredg

Hi every one, I have a report that print a job of houndred of Orders at the
time,
some times the order has one record, some times many.
I have sorted the report by Order, it does the sorting fine but How can I
print each Order on its page(s) ?
The report does the sorting just fine but If the Order has only 1 record,
the next Order will print rigth after on the same page, and need to separate
the report by Order.

Thanks for your help. I have tried many things but I can not get it rigth.

In the Report's Sorting and Grouping dialog, include a GroupHeader on
the Order field.
Then in Design View Set the Order Group Header ForceNewPage property
to Before Section. It's found under the Format tab on the property
sheet.
 

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