How to get previous total of filtered amount

See more:

VB

CrystalReports

I have created the following report in Crystal Report using VB.Net 2012. The OPENING BALANCE & NET TOTAL rows are not in my report but my question is there.

TR_ID | TR_DATE   |DETAILS | EXPENSE | INCOME   |   BALANCE
OPENING BALANCE                                         0.00
1005   08/24/2015 CASH RTN       0.00  10,000.00   10,000.00
1013   08/25/2015 PURCHASE   3,500.00       0.00    6,500.00
1014   08/25/2015 DEPOSIT    5,000.00       0.00    1,500.00
1015   08/27/2015 SALES          0.00   4,000.00    5,500.00
NET TOTAL                                           5,500.00

I filtered the specific records within the date range of 08/25/2015 and 08/26/2015 & it works well. My question is how do I get the previous balance (10000) of the specific date (08/25/2015) in "OPENING BALANCE" row and the total balance in "NET TOTAL" row?

I expect your great help
Thank you