client ledger report that show his last month balance as new month opening balance.

[bukhari]

can any one have example as mentioned in title.?

[June7]

Here is one method to get value from another record of same table http://allenbrowne.com/subquery-01.html#AnotherRecord

Are you saving balance to table? Saving calculated data, especially aggregate calcs, is usually a bad idea.