Page break for a sales report

[jim schlutnick]

This seems simple, but i can't get it to work.

I have a database of orders from different customers. I would like to be able to print all of the orders for a particular day sorted by the sales rep who took the order with a page break for each sales rep. So if i had 15 sales reps, i would wind up with 15 pages - one to give to each sales rep with only their orders on it.

Any suggestions?

[BobWeaver]

You need to place a sub-summary part on your print layout under the body part. The sub-summary is grouped by sales rep, and you can select the option to have a page break after each occurrence. Then, all you have to do is sort by sales rep and print.