水晶报表中的会计分类帐制作 [英] Accounting ledger making in crystal reports
问题描述
如何从sql server数据库的Crystal报表中设计总帐?
我在使用C-sharp.net 2010的这些字段
如下所示,在收据(DR)上显示有2笔针对特定用途的收款交易,例如,维护费Rctamt 200 pmtant 0
,升降机维护Rctamt 100 pmtant 0
跨日期pmtmode acctno purcode pur rctamt pmtamt
1 16/03/2011现金0001 Ar001维修费200 0
2 16/03/2011现金0001 Ar002电梯保养100 0
该报告应采用以下方式:每个上述目的(购买)现在都将成为一个组,并且其金额将位于pmt(CR)端,目的应全部显示为现金.
然后,现金"现在应该是一个组,它将显示所有组中的所有交易,并在收据(CR)端显示其金额,以便CR和DR上的总数相等.
在我的示例中,AS为300
sno transdate acctno purcode pur rctamt pmtamt
维修费
1 16/03/2011 0001 Ar008 Cash 0 200
升降机维修
2 16/03/2011 0001 Ar008 Cash 0 100
现金
1 16/03/2011 0001 Ar001维护费200
2 16/03/2011 0001 Ar002提升机维护100
总计300300
How can I design a General Ledger in crystal report from sql server database?
I have these fields using C-sharp.net 2010
As shown below, there are 2 transactions for which money was received for specific purpose which appear on the receipt (DR) side eg Maintenance charges Rctamt 200 pmtant 0
,lift Maintenance Rctamt 100 pmtant 0
transno date pmtmode acctno purcode pur rctamt pmtamt
1 16/03/2011 Cash 0001 Ar001 Maintenance charges 200 0
2 16/03/2011 cash 0001 Ar002 lift Maintenance 100 0
The report should be in a way that each of the above purpose (pur) would now be a group and their amounts will be on the pmt(CR) side and Purpose should all read Cash.
Then Cash should now be a group that will show all the transactions in all the groups with their amounts on tne receipt (CR) side so that the total will be equal on both CR and DR.
AS in my example, 300
sno transdate acctno purcode pur rctamt pmtamt
Maintenance charges
1 16/03/2011 0001 Ar008 Cash 0 200
lift Maintenance
2 16/03/2011 0001 Ar008 Cash 0 100
Cash
1 16/03/2011 0001 Ar001 Maintenance charges200
2 16/03/2011 0001 Ar002 lift Maintenance 100
Total 300 300
推荐答案
在报告中使用Groups
,请选中此
Crystal Report中的组 [
UseGroups
in your report, check this
Groups in Crystal Report[^]
这篇关于水晶报表中的会计分类帐制作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!