Running Sum on a Report

[Steve@GIHS]

Example :
Debit(+) Credit (-) Running Balance
Opening Balance $ 5000.00
Trans 1 $ 400.00 DR $ 50.00CR $ 4350.00
Trans 2 $ 25.00 DR $ 4375.00
.
.
. etc
Closing Balance $ 2595.45

The opening balance appears in the page header and the transactions in the detail section of the report. The Closing balance appears in the report footer.

I can get the values to add and subtract across correctly for the first entry but not the following entries.

Any suggestion on how to code this in VB for Application.

Thanks

[srinika]

Can u pls tell us ur environment
Eg.
1. U want to write a VB application ?
2. U want to maintain data in a database ?
3. U want to get the report to screen or get a printout ?
4. U will use a reporting software like Crystal Reports or VB Reports ?

[tipuse]

Hi
I am giving u solutions for Crystal Report. U could do this in crystal Report by the following way

just write a formula
formula=[opening balance]+Dr - Cr

and then Create a Running total of formula

then set Rtotal0 to detail band where u want running balance

and on page footer set Rtotal0 again

I think ur problem solved.

Thanx
Md. Mashiur Rahman Tipu