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.
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.
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.
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):
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.
Comments
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.
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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):
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
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com