Resetting running sum with change in customer name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report printing bills which contains several groupings - month and
customer name. I want to display a running sum of the values for each month
and then page on customer name and reset the running sum to zero to
reccalculate for the new customer. Example:

Customer 1
Month 1 Amt Running Sum
Month 1 Amt Running Sum

Month 2 Amt Running Sum
Month 2 Amt Running Sum

Customer 1 Totals Last of Running Sum

----------------------------------------------------------------- new Page


Customer 2
Month 1 Amt Running Sum

Month 2 Amt Running Sum

Customer 2 Totals Last of His Running
Sum


I have the running sum in the detail section (working fine), a month total
in the month footer (working fine), a customer total in the last name footer.
The first customer bill looks great, but when you look at each subsequent
customer, the running sum keeps accumulating for the entire report. I would
like it to reset for each customer. How do I do that?

Thanks,

Dianne
 
Set the Running Sum property to Over Group.

You could also get the total in the Customer footer as:
=Sum([Amt])
 
When I set the running sum property to "Over Group", the running sum resets
after each month. I want the running sum to reset after each customer.

Allen Browne said:
Set the Running Sum property to Over Group.

You could also get the total in the Customer footer as:
=Sum([Amt])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Dianne said:
I have a report printing bills which contains several groupings - month and
customer name. I want to display a running sum of the values for each
month
and then page on customer name and reset the running sum to zero to
reccalculate for the new customer. Example:

Customer 1
Month 1 Amt Running Sum
Month 1 Amt Running Sum

Month 2 Amt Running Sum
Month 2 Amt Running Sum

Customer 1 Totals Last of Running Sum

----------------------------------------------------------------- new Page


Customer 2
Month 1 Amt Running Sum

Month 2 Amt Running Sum

Customer 2 Totals Last of His Running
Sum


I have the running sum in the detail section (working fine), a month total
in the month footer (working fine), a customer total in the last name
footer.
The first customer bill looks great, but when you look at each subsequent
customer, the running sum keeps accumulating for the entire report. I
would
like it to reset for each customer. How do I do that?

Thanks,

Dianne
Click to expand...
Click to expand...
 
Then you may need to alter the order of the items in the report's
Sorting'n'Grouping dialog, and/or else move the control into the correct
group footer.

If you want a total for a grouping that does not match what is in the
Sorting'n'Grouping dialog, you could use a text box bound to a DSum()
expression.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Dianne said:
When I set the running sum property to "Over Group", the running sum
resets
after each month. I want the running sum to reset after each customer.

Allen Browne said:
Set the Running Sum property to Over Group.

You could also get the total in the Customer footer as:
=Sum([Amt])


Dianne said:
I have a report printing bills which contains several groupings - month
and
customer name. I want to display a running sum of the values for each
month
and then page on customer name and reset the running sum to zero to
reccalculate for the new customer. Example:

Customer 1
Month 1 Amt Running Sum
Month 1 Amt Running Sum

Month 2 Amt Running Sum
Month 2 Amt Running Sum

Customer 1 Totals Last of Running
Sum

----------------------------------------------------------------- new
Page


Customer 2
Month 1 Amt Running Sum

Month 2 Amt Running Sum

Customer 2 Totals Last of His
Running
Sum


I have the running sum in the detail section (working fine), a month
total
in the month footer (working fine), a customer total in the last name
footer.
The first customer bill looks great, but when you look at each
subsequent
customer, the running sum keeps accumulating for the entire report. I
would
like it to reset for each customer. How do I do that?

Thanks,

Dianne
Click to expand...
Click to expand...
Click to expand...
 
Back
Top