Printing sections of reports at set locations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to print invoices on pre-printed forms, with totals to print in the
boxes in bottom-right corner of printed forms. I requested how to print a
group footer at a set location and received reference to view article 208979
in Knowledge Base. The first method in this article suggests using the page
footer. Invoices are often more than one page and I don't want totals per
page--I need for entire invoice, or report. I've moved my invoice totals to
the report footer, but when setting the print margins I can't get the bottom
margin to get small enough. I try to set it and it "re-sets" itself. The
methods 2 & 3 in this article are Visual Basic routines which are too complex
for my present skill level in VB.

Can anyone either give suggestion about using the report footer (Can't use
page footer because sometimes invoice may be more than one page) for printed
totals or can someone "simplify" the "Method 3: Setting Report Properties for
the Detail Section" of Knowledge Base 208979?

Thank you so much!
Vandy
 
Another alternative might be to use unbound controls in the Page Footer
section, and to programmtically assign the value in the Format event of the
Invoice ID group footer.

It's a bit messy, but presumably each invoice starts on a new page. You will
have an InvoiceID group header for the address panel, and the Detail section
will print the line items. You will also have an InvoiceID group footer. Set
its Visible property to No, so it is not printed. Use code in its Format
event procedure to write the total into the unbound text box in the page
footer.

If you are printing multiple invoices at at time, you will also need to use
the InvoiceID group header to assign Null to the unbound text box in the
group footer, so that the page footer is blank again if the next invoice
happens to span more than 1 page.
 
Thanks Allen, but my problem is getting the control to print in the boxes on
the pre-printed form. I don't know VB to write the code. I can get the
correct data to print in report footer, I just can't get it to print low
enough on page to "hit" the pre-printed boxes (i.e., subtotal, tax, freight,
total). Any ideas on this?
Thanks!
 
If the preprinted boxes are actually in the unprintable area of your
printer, then you are not going to get anything printed there.

If that is not the case, then it will be a matter of learning a little VB,
or possibly using the SetValue action in a macro to assign a value to the
control on the report.
 
Back
Top