Click here to Skip to main content
15,921,174 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
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
Posted
Updated 4-Sep-15 5:22am
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900