R
Running Sum
Hello,
I have set up a report that shows delinquent payments.
In the report I have information grouped under client
name, then all items purhcased to which they are
delinquent on payment...
ex.
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
"y" $30.00 $80.00 $50.00
John Doe
etc.
I am doing a running sum, in an unbound text box, in the
detail section to add the total balance per client. I
would like to only see the balance at the end of each
group as opposed to seing it after every instance.
Here's what I'm seeing in the report...
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
Total Balance $25.00
"y" $30.00 $80.00 $50.00
Total Balance $75.00
Here's what I'd like to see:
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
"y" $30.00 $80.00 $50.00
Total Balance $75.00
Any suggestions on how to set this up so I only see 1
Total balance per client? Thanks in advance.
I have set up a report that shows delinquent payments.
In the report I have information grouped under client
name, then all items purhcased to which they are
delinquent on payment...
ex.
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
"y" $30.00 $80.00 $50.00
John Doe
etc.
I am doing a running sum, in an unbound text box, in the
detail section to add the total balance per client. I
would like to only see the balance at the end of each
group as opposed to seing it after every instance.
Here's what I'm seeing in the report...
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
Total Balance $25.00
"y" $30.00 $80.00 $50.00
Total Balance $75.00
Here's what I'd like to see:
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
"x" $25.00 $50.00 $25.00
"y" $30.00 $80.00 $50.00
Total Balance $75.00
Any suggestions on how to set this up so I only see 1
Total balance per client? Thanks in advance.