report problem

  • Thread starter Thread starter Sewkaransing
  • Start date Start date
S

Sewkaransing

Hi all
I have a problem with a report i am trying to print
I have an invoice application and print invoices with it
What i get now , is that the TOTAL amount is displayed right under all the
products.......
I need the TOTAL amount to display in the page footer.
If there are 32 records , the amount is displayed correctly at the page
footer
but when there are fewer records , the amount prints right under ( like in
the middle of the page )
How do i let the amount print in the page footer no matter how many records
there are?

Another question , is it possible to have a lable change when it is only on
the LAST PAGE of the report?
What i mean is , lets say there are 3 pages ....the label on the first page
says subt total for that page , the label on the second page subtotals for
that page and the label on page 3 shows the grand total?
How do i do this?

regards
 
Sewkaransing said:
I have a problem with a report i am trying to print
I have an invoice application and print invoices with it
What i get now , is that the TOTAL amount is displayed right under all the
products.......
I need the TOTAL amount to display in the page footer.
If there are 32 records , the amount is displayed correctly at the page
footer
but when there are fewer records , the amount prints right under ( like in
the middle of the page )
How do i let the amount print in the page footer no matter how many records
there are?

Another question , is it possible to have a lable change when it is only on
the LAST PAGE of the report?
What i mean is , lets say there are 3 pages ....the label on the first page
says subt total for that page , the label on the second page subtotals for
that page and the label on page 3 shows the grand total?
Click to expand...

Take a look at KB article 210261 and see if that answers
some of your questions.

As for changing a label on the last page of a report, you
need to have a text box the refers to Pages. Then the
Format event procedure for the section (page footer?)
containing the label would look like:

If Me.Page = Me.Pages Then
' This is the last page
Me.thelabel.Caption = "Grand Total"
Else
Me.thelabel.Caption = "Subtotal"
End if
 
Back
Top