var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to calculate an overall total for each report page and final total?
I want to be able to generate an over all total for each page of my report and then a final total for the over all report.
For the overall total for the page, I have tried using the running sum and I noticed that this carries the total for each line over and so on.
Is there a way to just create an overall total at the end of each report page and then to generate a final total for the whole report?
Any suggestions pls.
Many Thanks for ur help in advance.
Try to make instead of page sum Groupe Sum. Then make another text box to sum this Groupe's sum to get the total sum.
re how to calculate report total on page
Many Thanks for ur replies to my messages . Much appreciated.
sorry what did u mean by groupe ?
is this what u mean instaed of = sum(amountinpounds) this
Many Thanks for ur help.
No, what I meant is make a new Group in the Report (a part as your Details one)
then put a text box there, set its value to =1, and adjust its to property to be sum over all or sum over the group.
Sum your fields in Page footer and Report Footer to get the page totals and the final report totals
re total on report pages
Many Thanks for ur reply.
Summing total on page footer seems to give an error like this #error anytime I try to do this , however the report footer works fine.