you can also make a subreport, calculate the value there and then display it in the header.
I never like this solution as it runs the report twice, but if the amount of data is small enough that the report doesn't appear overly slow, it might be a viable solution.
Of course, if you could move it to the footer, the you wouldn't need the subreport, but sometimes people are intractable.
HTH
IP Logged
