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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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