Print to a new page for each person

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have a report filtered by the "By" field and need to print the report
manually by changing the name of the "By" field one by one.

Is it possible to print the report to a new page automatically one by one
according to the "By" field? For example, John, Bill, Susan, ...etc. I
have a multiple sort on other fields in the report. Your advice is
appreciated.

Thanks,

Ray
 
Ray said:
I have a report filtered by the "By" field and need to print the report
manually by changing the name of the "By" field one by one.

Is it possible to print the report to a new page automatically one by one
according to the "By" field? For example, John, Bill, Susan, ...etc. I
have a multiple sort on other fields in the report. Your advice is
appreciated.
Click to expand...


Use the Sorting and Grouping window (View menu) to specify a
group header for the By field. Then select the new group
header section and set its Force New Page property to Before
Section.

Note that if you have not already used Sorting and Grouping
to specify your sorting fields, you will have to do so after
creating a group on the By field. Sorting and Grouping will
override any sorting specified in the report's record source
query.
 
Marshall,

Thanks for your advice. I have worked out the issue successfully. One
shortcoming is the page number. I have a page number: Page 1 of 3 on the
page footer. Is it possible to count the page in groups? For example,
Peter group = Page 1 of 2, John group = Page 1 of 3. I would be grateful if
you could offer me further advice.

Thanks,

Ray
 
Ray said:
Thanks for your advice. I have worked out the issue successfully. One
shortcoming is the page number. I have a page number: Page 1 of 3 on the
page footer. Is it possible to count the page in groups? For example,
Peter group = Page 1 of 2, John group = Page 1 of 3. I would be grateful if
you could offer me further advice.
Click to expand...


Here's an article that describes a way to do that:

http://www.mvps.org/access/reports/rpt0013.htm
--
Marsh
MVP [MS Access]


 
Marsh,

The code given works well until I add a hidden text control of =Pages in the
page footer that was suggested by you in the past (I got it from the
search). Thanks a lot!

Regards,

Ray
 
Ray said:
The code given works well until I add a hidden text control of =Pages in the
page footer that was suggested by you in the past (I got it from the
search). Thanks a lot!
Click to expand...

I don't understand Ray. Are you saying the code in that
article doesn't work with an =Pages text box in the page
footer? The article explains that an =Pages text box is
essential to making the whole procedure work, so I'm lost as
to what you mean here.
--
Marsh
MVP [MS Access]



 
Back
Top