heres the sample of the report

 

Date   Time     transaction      debit           credit             balannce

 

John

***    ***         buy                  10.00                                20.00

***    ***         add value                            10.00             30.00

                          Total for John 10.00          10.00 

 

mary

***    ***            buy                 15.00                               45.00

***    ***            buy                 10.00                               35.00

                          Total for mary   25.00         0.00

etc

 

 

Then at the report footer we sum the totals of the debit and credits.

 

What i need to do is to find the formula for the opening balance which will be the first transaction balance plus debit minus Credit.(20.00+10.00-0.00=30.00 for John) which needs to be shown just above 20.00 for john.

The other formula Iam after is to sum the last record of the balance for each group in the report footer. eg. last record for john is 30.00 and last record for mary is 35.00  so the total in the report footer will be 65.00.

 

Iam new to crystal reports and dont know much of the basic formula. Iam working on the existing report which was created for other reasons so Iam trying to modify the reports .

I will really appreciate if I could get some help please.