Hello Arie
I think in these cases it is important to always get the total from the report rather than calculate it separately, as you are then protected from any changes that might occur in the data gathering methods.
You could run the report twice. Once invisibly to a file to get the total from the footer and store that value and then again to display it. You can use variables to determine which is the second print run and show the total in the header rather than the footer for the second run.
Regards
Al
Edited 1 time(s). Last edit at 07/06/2009 11:44PM by Al.