My current report has a Category header and footer. The cat footer shows the accumulated amount of items eg. Sum([Balance]*[Price])
There's two things i need help in.
1) Move the cat footer to page footer so it shows the sum of the whole page's items. It gave me an error when i shifted it whole from cat footer to page footer.
2) With no 1 solved, is it possible to show a balance brought forward to the next page?
Eg Pg 1 footer: total for this page is $100.
Pg 2 header: balance brought forward $100
Pg 2 footer : total for this page is $150
Pg 3 header: brought forward $150
and so on.. accumulating till the end of the report making it a report Sum amount in the report footer.
There's two things i need help in.
1) Move the cat footer to page footer so it shows the sum of the whole page's items. It gave me an error when i shifted it whole from cat footer to page footer.
2) With no 1 solved, is it possible to show a balance brought forward to the next page?
Eg Pg 1 footer: total for this page is $100.
Pg 2 header: balance brought forward $100
Pg 2 footer : total for this page is $150
Pg 3 header: brought forward $150
and so on.. accumulating till the end of the report making it a report Sum amount in the report footer.
