Running total keeps doubling up when switching pages?
Hi,
I have a report which displays on two pages. Due to some complexities, the
grand total report is calculated by using variables within the report.
In summary, I have a group with calc variables which has a running total of
a variable that I have defined. Timing is set to calculate on the footer
end of the group. Then the grand total simply displays this. The first
time the report is run and I go to the second page, the total is correct.
If I go back to first page and then the second again, the grand total
doubles. If I do it again, it is tripled.
I didnt realise the report gets recaclulated once it has been created. Is
there a way to stop calculations once report has run for the first time, or
any other solution?
Thanks
Alex
I have a report which displays on two pages. Due to some complexities, the
grand total report is calculated by using variables within the report.
In summary, I have a group with calc variables which has a running total of
a variable that I have defined. Timing is set to calculate on the footer
end of the group. Then the grand total simply displays this. The first
time the report is run and I go to the second page, the total is correct.
If I go back to first page and then the second again, the grand total
doubles. If I do it again, it is tripled.
I didnt realise the report gets recaclulated once it has been created. Is
there a way to stop calculations once report has run for the first time, or
any other solution?
Thanks
Alex
This discussion has been closed.
Comments
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com