Page break question

  • Thread starter Thread starter erick-flores
  • Start date Start date
E

erick-flores

Hello, here is my question: whenever I print a report (usually 40-100
pages long) sometimes the sum of one field (e.g.sales) will go over the
next page and the total will appear on that next page but I will loose
the field Name so I will not know from which field that total is coming
from unless I go back one page and see it on that page.

e.g.
Cars $34.444
$65.665
$45.546
----------jump to next page--------
$23.3453
$45.563
Total: $4352345

I will like to see the "Cars" field again when ONLY this happen on the
next page, like:

Cars $34.444
$65.665
$45.546
----------jump to next page--------
Cars $23.3453
$45.563
Total: $4352345

Please help, thanks
 
If you are grouping by the "Cars" field, you can set the group header's
repeat section to Yes.
 
How do I do that? I am guessing is in the Sourting and Grouping>Group
header "Yes". That's what I did and still showing me the reports the
same way. Any clues?
 
Did you place the Cars" field in the group header and then set the Repeat
Section property of the Cars field header to Yes?
 
Yes, I think you do not understand my question. I know what that option
does. It will put the name of each field under that category group. But
my question is when the results past to the next page, the header
category will not past to the next page, so you have to go back to the
previous page and see the name of that group/category.

I tried using a Text Box and then set the Control Source to whatever
the field name is and then I put this under the Page Header so I will
show it everytime I pass to the next page. But this is not very usefull
because sometimes I get the same name repeated twice. I was wondering
maybe using an If statement but I really do not know

Any help or comments please let me know
 
I don't think you understood my suggestion. If you set a group header's
Repeat Section property to Yes, it will display the group header contents
after a page break.

I never suggested you use the page header 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

Reset running sum on group level 2
Printing report for Invoice 0
Windows 7 Internet Links 13
Carry the page total to another page first line 2
Min and Max for Date Range in Report 4
Group last line of details and report footer 0
One and One-half Columns and Grand Total on Same Page (?) 3
MSAC2K: Reporting Sum of Items Printed on Page 1

Back
Top