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

subtotal - amount carried over

edited March 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 March 2005
    Hi Uwe,

    Which version of ReportBuilder are you using? Instead of using a DBCalc, try
    using two TppVariables and in the OnCalc of the variable in the detail band,
    update the value of the other variable inside the page footer. You can also
    suppress the visibility of a report component based on the page number using
    the Report.PageNo property. A good place to check this value and set the
    visibility of a component to false would be the Band.BeforePrint event.

    --
    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.