BI Publisher - Carry Forward & Page Totals
I am working on one report which has following two requirements:
1. Report has group on "Account". i.e. New account should always start on new page. I am able to do that. Problem is on last page of an account details (split) where I do not want to show "Page Totals". Is that any way to control page total display to all pages other than last page of account details (group).e.g. Account 100001 details (Dr & Cr) shown on 3 pages. So first two pages should only show Page Total. From page 4 new account 100002 starts.
2. Report is displaying table (Dr & Cr). I am doing carry Forward successfully. My requirement is last line shown on Page 1 should also repeat on Page 2 but should not be considered in calculation. E.g. my last line on page 1 for same account showing Cr: 100 and Dr 0. Next page 2 should show Cr 100 above table where we are displaying "Bought Froward". So I want to display Bought forward total as well as Last line content.