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

invoice with carry over

edited March 2012 in End User
Hi,
I want to define an invoice form where on the end of each page (if the
invoice has more than 1 page) a carry over ist printed. This value
should be also printed on top of the following page.

How can I do that?
Thank you for helping me

Helmut

Comments

  • edited March 2012
    Hi Helmut,

    I'm a bit unclear about the question. Do you simply need to print a
    running total at the end of a page, then show that value again at the
    beginning of the next. This can be done using a dbCalc component set to
    SUM.

    If you are printing numerous invoices and want to determine whether it
    is multiple pages or not, you could keep track of the master record and
    let that determine whether the running total is printed.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited March 2012
    Hi Nico,

    thank you for your quick answer.
    Yes, I need a total on teh end of each page and on the beginning of the
    next page. In simple reports this works as expected.
    But in my case I have global invoice data and invoice positions.

    pipeline INVOICE
    Detail: pipeline INVOICE_POSITION

    I want to print the sum of the prices printed so far on the end of each
    page and a carry over on the next page, like this:


    Invoice# 12345 page 1

    Pos. 1 AAAAAAA 111,00
    Pos. 2 BBBBBBB 222,00
    Pos. 3 CCCCCCC 333,00
    ..
    ...
    Sum 999,99

    -> next page

    Invoice# 12345 page 2

    carry over 999,99
    Pos. 1 AAAAAAA 111,00
    Pos. 2 BBBBBBB 222,00
    Pos. 3 CCCCCCC 333,00
    ..
    ...

    I don't know where to place the dbCalc field.
    I defined a footer for the positions an placed the dbCalc (sum) teher.
    But the footer ist not printed ?!?
    I'm a little bit confused :-)

    best regards
    Helmut



    Am 12.03.2012 15:06, schrieb Nico Cizik (Digital Metaphors):
  • edited March 2012
    Hi Helmut,

    If you are using subreports, be aware that the page header and page
    footer bands are not supported in Child style subreports. One option is
    to use Section subreports. Another is to use the main report's header
    and footer band's to display the running total. See the following
    article on showing subreport values in the main report.

    http://www.digital-metaphors.com/rbWiki/Delphi_Code/Calculations/How_To...Display_Subreport_Totals_in_the_Main_Report

    Best Regards,

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