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)]
Problem with page totals in master detail report
-
- Posts: 7
- Joined: Tue Nov 11, 2014 1:48 pm
Problem with page totals in master detail report
- Attachments
-
- PrintVoucher.mrt
- (50.82 KiB) Downloaded 83 times
-
- response.pdf
- (119.05 KiB) Downloaded 84 times
-
- Posts: 6244
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problem with page totals in master detail report
Hello,
Please check the sample report in the attachment.
Thank you.
Please check the sample report in the attachment.
Thank you.
- Attachments
-
- cCount and sum of previous pages.mrt
- (783.61 KiB) Downloaded 135 times