By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,309 Members | 1,452 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,309 IT Pros & Developers. It's quick & easy.

Setting Page numbers on copies of a report

P: n/a
I have a 1 page report which I want to print numerous copies of. The number
of copies will be specified by the user. My problem is that I want each
report to print the copy number of number of copies, e.g. 1 of 6. I can set
the report so the report prompts the user for the copy number and the number
of copies but this means they have to enter 1 then 6 then print, 2 then 6
print etc. How can I set it so that when the report is opened it asks for
how many copies/pages and then prints copy/page number and total copy/page
number on each page?

thanks

Will
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Look into help on FormatCount for the report.

Sorry to be so brief...limited time.

HTH
Paul

"Will" <wi*****************@f2s.com> wrote in message
news:cn**********@news.freedom2surf.net...
I have a 1 page report which I want to print numerous copies of. The
number
of copies will be specified by the user. My problem is that I want each
report to print the copy number of number of copies, e.g. 1 of 6. I can
set
the report so the report prompts the user for the copy number and the
number
of copies but this means they have to enter 1 then 6 then print, 2 then 6
print etc. How can I set it so that when the report is opened it asks for
how many copies/pages and then prints copy/page number and total copy/page
number on each page?

thanks

Will

Nov 13 '05 #2

P: n/a
Will wrote:
I have a 1 page report which I want to print numerous copies of. The number
of copies will be specified by the user. My problem is that I want each
report to print the copy number of number of copies, e.g. 1 of 6. I can set
the report so the report prompts the user for the copy number and the number
of copies but this means they have to enter 1 then 6 then print, 2 then 6
print etc. How can I set it so that when the report is opened it asks for
how many copies/pages and then prints copy/page number and total copy/page
number on each page?


You could have a table with numbers (just numbers--see article "Range"
on my site for ideas, section How to create a range of numbers). Include
that in the query for the report, no connection. You will get the
cartesian product: all your values occur together with all numbers.
Those numbers can then serve as page numbers.

Limiting the number of (numbered!) pages to print is done by filtering
the number table.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.