Print a Report for each record in a table

  • Thread starter Thread starter David Peterson
  • Start date Start date
D

David Peterson

I have a form based on a table. I can print a report on each record one at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer on
each record's report?
Right now I would have to select each record and print it.
 
Hi David

move the information out of the report header & footer into the page header
& footer (if you can't see it its under the view menu)

Cheers
JulieD
 
Thanks, Tried that.
There are Report Totals in the header/footer that don't work when I do that.
More suggestions?
 
Hi David

haven't tested this but what about placing a "sub-report" in the page footer
section that contains the information that you would normally show in the
report footer section (ie create a "totals" query and use that as the source
for the page footer) -do the same for the header section if necessary.

Cheers
JulieD
 
David,

Check your expression for report totals. You should be able to write expressions
for totals on the page header and footer to give you totals just for the page.
Julie had the right idea to give you a report for each record.
 
I tried. Most now work.

Need help getting page number correct.
Should say page 1 of 3, page 2 of 3, page 3 of 3 on each report.
Actually says page 1 of 180, page 2 of 180, page 3 of 180, then next report
says page 4 of 180, page 5 of 180, page 6 of 180 (should say 1 of 3, 2 of 3,
3 of 3 each time)
 
a.. Group the report by RecordID
b.. Set the Group's ForceNewPage property to Before Section
c.. In the Group Header Format event, write:
[Page] = 1
 
For page numbering, see
http://www.mvps.org/access/reports/rpt0013.htm.
I have used this code successfully.

With the code, everything above Private Sub etc. goes at
the very top of the code window, in the Declarations
section. If you just paste the code I think this will
take care of itself, but I'm not sure.
For group totals, I used a hidden text box in the report
detail with its control source set to the field for which
you need totals, and its Running Sum set to Over Group.
In the group footer I referenced the control.
I have by now lost track of the origin of some of the very
helpful suggestions I have received while learning about
this stuff, but I know that most of them came from this
group. The two previous responders to your post are among
those who have been especially helpful. If I am now in a
position to contribute from time to time, it is due in
large part to this group.
 
Back
Top