running total problem

[DaleMcIntosh]

I am reporting on a check transaction table with multiple bank accounts so I am grouping on the bank code.
Each record contains fields begin bal, check, deposit, end bal. The end bal is the begin bal + deposit - check so it is a running balance through the transactions. In the footer of the group I need to show the total deposits, checks and the ending balance. I can of course do running total fields for the deposits and checks but the ending balance is the same figure as the last record.
I need to show that end bal in the footer and then be able to sum the end bal of each group in the report footer to show the total ending balance of all accounts in the table.

I need to know how to put the end bal from the last record in the group into the footer of each group in a way that I can then sum them for the report footer.
Thanks All!

 

[kenhamady]

2 different things. Putting the value into the footer is easy. ANY field you put in the footer will display the value of the last record.

However, this wont affect sums. Also, automatic running totals can increment once per group, but they automatically pick up the FIRST record of the group, which doesn't help you.

Your only option is to use the 3-Formula technique described in faq149-182 to create a running total formula. The formula that does the accumulation should be put into the page footer so that is only picks up the last value of each group. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com