列表视图中的日期明智总计 [英] Date Wise Total In Listview

问题描述

请帮帮我

我正在从数据库表凭单填充
的listview 显示现金簿

listview有5个标头
日期帐户名称借方贷方余额

我希望在每个新日期后执行listview填充数据的情况
插入一个新行，并记录日期的借项或贷项总额

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

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 

推荐答案

在VB.net中
您必须编写自我联接查询和一次日期总计总计查询

看. Cr到Anil的现金Cr = 15.00 =从Anil收到的金额
Anil帐户
----------
一个数据集，用于计算值并将值传输到另一数据集2
日期借方贷方余额
打开18.00 0.00 = 18.00Dr动态行到网格/数据集2

14-06-12现金0.00 15.00 = 3.00 Dr
总计18.00 15.00 = 3.00 Dr动态行至网格/数据集2

现金账户
--------------
14-06-12 28.00 0.00 = 28.00 Dr
阿尼尔15.00 0.00 = 43.00 Dr
和Totall与上述相同

您可以使用Crystal Report/Rdlc/并直接将其创建到DataGridview
我做同样的一个.一些报告类型是DateWise/MonthWise = Detials + Sum

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

这篇关于列表视图中的日期明智总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！