Page 1 of 1

Problem with page totals in master detail report

Posted: Sat Jun 19, 2021 6:22 am
by faridprogrammer
Hi guys.
I have a master-detail report in which I need to show the Accounting voucher and its items. The resulting report should have the following semantics.

There is two important notes in the semantics below that I would like to share.
One: All sums of in the context of voucher not entire report pages.
Two: At the last page of a voucher's items listing there is a total sum of current voucher in the footer instead of [sum from current page].

The question is how can I achieve this. I have implemented a half way report but I couldnt get to expected result.
I have uploaded the mrt and resulting pdf in this message attachments.

Thanks.

------------------
Page1
------------------
Voucher1
VoucherItem
VoucherItem
VoucherItem
VoucherItem
VoucherItem
[Sum of debit and credit values from this page (in the current voucher)]
------------------
Page2
------------------
[Sum of debit and credit values from the previous page (in the current voucher)]
VoucherItem
VoucherItem
VoucherItem
VoucherItem
VoucherItem
[Sum of debit and credit values from this page (int the current voucher)]
------------------
Page3
------------------
[Sum of debit and credit values from the previous page (in the current voucher)]
VoucherItem
VoucherItem
[Sum of total debit and credit values from voucher]
------------------
Page4
------------------
Voucher2
VoucherItem
VoucherItem
VoucherItem
VoucherItem
VoucherItem
[Sum of debit and credit values from this page(in the current voucher)]
------------------
Page5
------------------
[Sum of debit and credit values from the previous page(in the current voucher)]
VoucherItem
VoucherItem
VoucherItem
VoucherItem
VoucherItem
[Sum of debit and credit values from this page(in the current voucher)]
------------------
Page6
------------------
[Sum of debit and credit values from the previous page(in the current voucher)]
VoucherItem
VoucherItem
[Sum of total debit and credit values from voucher(in the current voucher)]

Re: Problem with page totals in master detail report

Posted: Tue Jun 22, 2021 10:08 am
by Lech Kulikowski
Hello,

Please check the sample report in the attachment.

Thank you.