Date Wise Total In Listview

Question

0.00/5 (No votes)

See more:

Pls Help me

i am populating a listview from database table vouchers for
display cashbook

listview have 5 headers
Date AccountName Debit Credit Balance

when listview fill data i want to do after every new date
inster a new row and total debit or credit filed for date

VB

exp.
Date       AccountName    Debit   Credit  Balance

25/5/2012  X              200.00  
25/5/2012  c              200.00
25/5/2012  a                      300.00
           
           total          400.00  300.00 

27/5/2012  X              600.00  
27/5/2012  c              400.00
27/5/2012  a                       300.00
           
           total          1000.00  300.00

Posted 9-Jun-12 3:39am

Member 2844892

Add a Solution

Comments

Sandeep Mewara 9-Jun-12 13:30pm

So, what is the issue?

1 solution

Add a Solution

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

anilvyas1981 · Answer 1 · 2012-06-16T06:31:00

In VB.net
You have To Write Self Join Query and One Query For Date Wise total

See. Cash Cr To Anil = 15.00 =Amount Received From Anil
Anil Account
----------
One Data Set For Calculate Values and Transfer Values to another Dataset2
Date Debit Credit Balance
Opening 18.00 0.00 = 18.00Dr dynamic Row To Grid/Dataset2

14-06-12 Cash 0.00 15.00 = 3.00 Dr
Total 18.00 15.00 = 3.00 Dr dynamic Row To Grid/Dataset2

Cash Account
--------------
14-06-12 28.00 0.00 = 28.00 Dr
Anil 15.00 0.00 = 43.00 Dr
and Totall Like Same As Above

You can create It using Crystal Report/Rdlc/and Direct to DataGridview
I doing the same One. Some Report Type are DateWise/MonthWise=Detials + Sum

Date Wise Total In Listview

1 solution

Solution 1

Add your solution here

Preview 0

Date Wise Total In Listview

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us