page breaks in reports

R

ronmalt

I have a report based on a query that totals deliveries for each
customer. For example customer Bob Smith delivers x bs. of #1 grade
product, x lbs. of #2 grade product, and so on. My query sums the lbs.
of each grade delivered for each customer. I am trying to make a report
based on each customers totals something like this:
Bob Smith
#1 324,400lbs.
#2 255,500lbs.
#3 115,520lbs.
All that info is in the query. When I make my report it wants to print
a page for each grade.
It will print the name and the first grade on one page then print no
name and the second grade and weight on the next page, and so on. I'm
sure I'm missing something simple but can't figure it out. Any help
would be appreciated.

rkg
 
V

Van T. Dinh

Use the Report's Sorting and Group to group by the [Grade #] and in the
Group Header for the [Grade #], set the "Force New Page" 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

Similar Threads

matching price to item 2
page break in report 4
Subreport Madness 7
hide controls 7
Help needed for using charts in reports 0
New page for subreport 1
showing totals in reports 1
Total certain records 1

Top