Database

View All Threads First Prev Next

show Sum(Balance) as ob on Rows Header and add next rows balance in ob hadeed147227-Dec-12 6:52 hadeed1472 27-Dec-12 6:52  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 . . . . . . . . Re: show Sum(Balance) as ob on Rows Header and add next rows balance in ob Corporal Agarn27-Dec-12 7:53 Corporal Agarn 27-Dec-12 7:53  What you are looking for is running total. Example: Stackoverflow[^] Re: show Sum(Balance) as ob on Rows Header and add next rows balance in ob hadeed147227-Dec-12 8:03 hadeed1472 27-Dec-12 8:03  Thanks For reply the solution you provide help me lot and i am about to solve my problem..

Last Visit: 31-Dec-99 18:00     Last Update: 19-Apr-24 19:52 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.