little help with report

  • Thread starter Thread starter SARL
  • Start date Start date
S

SARL

hi all
i need some help
I am printing an invoice and when i do that if i have fewer then 32 products
, the total of the invoice prints in the middle of the page...

I want the total of the invoice to print in the report footer or on the
bottom of the page , and if there are more then 32 products lets say 40 then
the first page gets a subtotal and the other 8 products are printed on the
next page with the subtotal and a grand total in the FOOTER of the report

does anyone have any sggestion i can use to accomplish this?
with best regards
 
Place your controls in teh report footer.
I suppose your invoice lines are coming from a sub report, and the invoice
totals are coming from the
subreport as well

If so,
Make the subtotals in the report invisible
then in the main report. place textboxes taht refer to the subreport invoice
totals and
point them to the subreport
for example, in the control source of the control on the main form
= Reports.RptSubReport.InvoiceTotal

As for adding continue if the number of records is greater than x number of
lines,
You will have to use the on retreat event of your section.

HS
 
Back
Top