Running Total

[hbussell]

I am trying to print the sum of a field that is printing on my report. I am using a Running total field, but am not getting accurate data.
As an example lets say I have multiple clients and each client has received multiple services. I want to see the last service for each client.
I am sorting the report by Client ID and date of service..
I have then use a suppression formula in the detail section of “Clientid = NEXT(Clientid)” to get the last service each client has received.

This part works OK. I then want to see the total amount of time spent with the clients that are printing out. I entered a Running total field. I used my duration field to sum this amount and I said to add the sum for each change in my Clientid field.

The Running total does not agree with the individual amounts on the report. What it appears to be doing is using the duration from the last suppressed record rather than the record that is printing.

Any help would be appreciated.

 

[lbass]

Instead of evaluating on change of field, evaluate based on a formula:

{table.clientID} <> next({table.clientID})

-LB

 

[hbussell]

I used the above formula and now my Running Total includes everything except the last entry. Is there any way to let Crystal know to include the last entry?

 

[lbass]

Please check whether you used &quot;<>&quot;. Also, this formula belongs inside the running total--select your field, sum, then check evaluate based on a formula and enter the formula there. There's no way that using this formula in the correct place could result in all records BUT the last one being counted.

-LB