Problem with page totals in master detail report
Posted: Sat Jun 19, 2021 6:22 am
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)]
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)]