467,894 Members | 1,761 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,894 developers. It's quick & easy.

Setting Page numbers on copies of a report

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
  • viewed: 2641
Share:
2 Replies
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
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.

Similar topics

8 posts views Thread by Hank Reed | last post: by
3 posts views Thread by TDIOwa | last post: by
8 posts views Thread by David Lozzi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.