show Sum(Balance) as ob on Rows Header and add next rows balance in ob
-
Hi i want to show results something like this... First row contain the opening balance calculated by this i.e: Sum(Balance)where datefield <= DateByUser and next rows shows the records between dates given by user & evaluate balance on each row output should like this.. VchrNo___DrAmnt___CrAmnt___ Balance 00 --------00---------00--------1570 113--------10---------00--------1580 115--------15---------00--------1585 123--------10---------00--------1595 123--------12---------00--------1607 . . . . . . . .
-
Hi i want to show results something like this... First row contain the opening balance calculated by this i.e: Sum(Balance)where datefield <= DateByUser and next rows shows the records between dates given by user & evaluate balance on each row output should like this.. VchrNo___DrAmnt___CrAmnt___ Balance 00 --------00---------00--------1570 113--------10---------00--------1580 115--------15---------00--------1585 123--------10---------00--------1595 123--------12---------00--------1607 . . . . . . . .
What you are looking for is running total. Example: Stackoverflow[^]
-
What you are looking for is running total. Example: Stackoverflow[^]
Thanks For reply the solution you provide help me lot and i am about to solve my problem..