printing "blank" pages

J

John

Hi

I need to print "blank" invoices with invoice numbers only at the top. I
have a table full of invoice numbers which I am using as the record source
for the invoice report. I have placed the invoice number field on the page
header and nothing in detail as there are no transactions. The problem is
that even though there are several invoice number records in the source
table, the report displays only one page. How can I make the report print
one page per source table record in this situation?

Thanks

Regards
 
J

Joseph Meehan

John said:
Hi

I need to print "blank" invoices with invoice numbers only at the
top. I have a table full of invoice numbers which I am using as the
record source for the invoice report. I have placed the invoice
number field on the page header and nothing in detail as there are no
transactions. The problem is that even though there are several
invoice number records in the source table, the report displays only
one page. How can I make the report print one page per source table
record in this situation?
Thanks

Regards

If I understand you correctly, it should be printing the report, one
page for each Invoice number in the number field in the record source.
Have you actually tried printing it?
 
J

John

In the preview it shows only one page.

Joseph Meehan said:
If I understand you correctly, it should be printing the report, one
page for each Invoice number in the number field in the record source.
Have you actually tried printing it?
 
W

Wayne Morgan

You say your are placing the Invoice Numbers "at the top". Which report
section have you placed the textbox in that contains the invoice numbers?
 
R

Rick B

If your invoice number is used as the sort and grouping, just add a group
header. In the header, put the invoice number. In the group header or
footer properties box, look at the "force new page" feature.
 
J

John

page header

Wayne Morgan said:
You say your are placing the Invoice Numbers "at the top". Which report
section have you placed the textbox in that contains the invoice numbers?
 
J

John

Done, no luck. Still one page. The only thing that makes any difference is
to add anything in detail. Either the invoice number filed or anything else
such as a box or line.

Regards
 
R

Rick B

Well, if you are printing "blank invoices" I'd think you'd have lots of
stuff in the detail section. You aren't trying to simply print a page with
nothing on it but a number are you?

Just add some controls to the detail section. Make them invisible if you
really don't want to see them.

OR,

Put your invoice number in the detail section and include a PAGE FEED after
it. There is one in the report toolbox.
 
R

Rick B

You could also put your invoice number in the detail section and then use
the "force new page" property.
 
J

John

What I have noticed is that if I don't put anything in details and gradually
increase its height then the number of pages start to increase from 1 and
eventually come to the number of pages required. If I increase it further
then more pages than are records come up!!! So one number appears on more
than one page. Very weird. Is there a sure short way to get the exact number
of pages without resorting to trial and error?

Thanks

Regards
 
J

Joseph Meehan

John said:
Now I have. Only one page. It seems that the number of pages printed
are somehow related to the height of the detail section. As I
increase height of detail section I get more and more pages until I
have all the pages. If I increase height further I get more pages
than are records!! One number appears on more than one page. What is
this black magic?
Thanks

Regards

PS: A screen shot is attached. At this detail height I get 3 pages
while there are 5 records in the source table.

Rick is likely right, but if I remember all the stuff I read, you don't
have anything in the detail section. I suggest you the invoice number to
the detail section. Just make the font white so it will not show.
 
J

Joseph Meehan

John said:
Now I have. Only one page. It seems that the number of pages printed
are somehow related to the height of the detail section. As I
increase height of detail section I get more and more pages until I
have all the pages. If I increase height further I get more pages
than are records!! One number appears on more than one page. What is
this black magic?
Thanks

Regards

PS: A screen shot is attached. At this detail height I get 3 pages
while there are 5 records in the source table.

Forgot to add, make sure you have force new page selected as Rick
suggested.
 
J

John

Ok, putting the invoice no and the page feed control worked. Thanks for all
the help.

Regards
 

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


Top