Resetting running totals to something other than 0 1

[NNIsarahd]

I have a report where I am showing x points assigned to a person, with multiple people listed on this report.

Using CR 7, I have a running total set up. I have it so that it resets on change of the person (Group 1).

However, I cannot seem to find what I'm looking for.

Here's what I need to do...

On change of person, I want the running total to reset to a number determined off of the database, not to 0.

Is there a way to tell the running total to reset to this other number? Or are running totals stuck at resetting to 0?

 

[lbass]

I think you would have to use a manual running total. Create three formulas:

//{@reset} to be placed in the group header:
whileprintingrecords;
numbervar sumamt := {table.field};
//plug in the field you want to the running total to reset to

//{@accum} to be placed in the detail section:
whileprintingrecords;
numbervar sumamt := sumamt + {table.amt};
//plug in the field you want to accumulate

//{@display} to be placed in the group footer:
whileprintingrecords;
numbervar sumamt;

-LB

 

[NNIsarahd]

Thanks! That seemed to do the trick!