Invoice - Report

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

Hello,

I've got a project where I have created an Invoice (Access
Report)for Products that are shipped. The report is a
simple query that can contain 1 to many records.

Question:

Part I
How can you program a report to have a fixed detail length
for 1 page with only 3 - 5 records. Then if the report
should contain for than 1 page will hold, I would like
this to continue onto the second page.

Part II
Is there a way to program the Report footer to remain on
the bottom of the page rather than following the detail.

Any suggestions would be appreciated!

Thanks.
 
Actually, if you fix part I, then Part II is done!

Simply set the detail size to what you want. Then in the properties for the
detail section, simply turn off the can grow, and the can shrink.

You have now fixed the length of the detail section.

If the detail gets full, you will get another page. And, yes, you footing
will stay on the bottom of the page (in fact, it should be
anyway...regardless if the detail section can grow, or shrink...the page
footer should stay on the bottom).
 
Thanks Albert,

But when I fix the detail to a desired size, the records
that are returned are far away from each other. Not one
line after another (like several spaces between each
returned record). Does this make sense? I need to keep
each record one after another. Any suggestions?

Tony
 
Gee, dummy me! (sorry about the brain freeze on my part!).

Yes, if you expanded the white space, then the records are very far apart.

First, lets get the report fixed:

The page header, and the page footer are the ones that you can REALLY use to
control the layout. Don't confuse the page header/footer with the report
header/footer.

The page header/footer ALWAYS print at the top, and the bottom in the same
location.

So, un-check the can grow option in the detail,a and shrink it back down to
the one line of details.

You will note how the page heading/footer always prints at the top and
bottom REGARDLESS of how many detail lines. So, if you want to "limit" the
number of lines in the detail, you can simply expand the size of the page
heading, and the page footing. As (set their can shrink to no).

The above works quite sell. Another great trick is to simply size the detail
to what you want, and THEN USE A SUB-REPORT. The sub-report can be set to
can grow, but the detail second of the main report can be set to not grow,
not shrink. So, you fix the size of the detail, and let the sub-report
expanded to fill the details.

I used either of the above.

Sorry about that wrong advice. I hope the above can/will help...

I have even used the above idea on pre-printed forms with great success.
 
Back
Top