Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

amount carried over

edited May 2005 in General
Hello,

for a invoice report i need to print the subtotal of a page on the end of
each Detailband of a page (but only if there is more than one page) and of
the beginning of the next page i need to print the "amount carried over".

I tried using a calculated field (sum of field). This works fine at the end
of each page (Detail Footer), but on the next page it adds the first value
of the next page (sum previous page + fist value actual page.

How can i avoid to print the Label "?bertrag" (which is german for "amount
carried over") and a value, if there is only one page?

Thank you for any help and suggestion.

Uwe P?tzold

Comments

  • edited May 2005
    Hi Uwe,

    1. At the end of each page (perhaps in the OnEndPage event) try storing the
    total page value in a separate private field. Then in the next page, set
    the carried over amount equal to that saved value. This way you can be sure
    the value has not been changed when the page break has occured.

    2. If you do not want to print a certain lable when you are on the first
    page, simply check the Report.PageNo property inside the Band.BeforePrint.
    If the PageNo is 1, set the Label.Visible to False, else set it to True.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.