Running total final result displayed in page header

[mmm76]

Hi,
I have created a report that is tracking number of calls recieved based on a customer id and the type of call. I have a running total that is working to show the amount of calls. I wanted to be able to bring the last value in the running total to my page header so when the user opened the report they would be able to see the total without having to look at the last page. Any suggestions on how I could do this?
Thanks,
Megan

 

[slicknick515]

Have you tried creating a summary that shows a sum of calls and put it in the grand total section, then move that summary object from the grand total section to the page header section? Or is it a deeper issue?

 

[Madawc]

Running totals can't be used in page headers or report headers, they are calculated at the same time as the details print.

As slicknick515 says, you could do it with a summary total, which will have accumulated its value before anything prints. (The use of Crystal's automated totals is outlined at FAQ767-6524.)

If your total is conditional, you can get the same result by doing a summary total of a formula field, e.g.

if {your.code} = "A" then 1 else 0

As a last resort, you could use a subreport. This will slow the report but will get the result.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

How is your running total set up? Are you sure you need to use one? If it is a simple count, try a formula like:

distinctcount({table.callID})

...and place this in the report header (which I think you mean). It would work in a page header, too.

-LB