来自vb.net的水晶报告 [英] crystal report from vb.net
问题描述
如何从sql server数据库的Crystal报表中设计总帐?
我使用vb.net 2008有这些字段
如下所示，在收据(DR)上显示有4笔针对特定用途的收款交易，例如入场费Rctamt 200 pmtant 0
，Bye-law 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
3 16/03/2011现金0001 Ar003正常储蓄1000 0
4 16/03/2011现金0001 Ar004圣诞储蓄2000 0
该报告应采用以下方式:每个上述目的(购买)现在都将成为一个组，并且其金额将位于pmt(CR)端，目的应全部显示为现金.
然后，现金"现在应该是一个组，它将显示所有组中的所有交易，并在收据(CR)端显示其金额，以便CR和DR上的总和相等.
在我的示例中为3300
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
普通储蓄
3 16/03/2011 0001 Ar008 Cash 0 1000
圣诞储蓄
4 16/03/2011 0001 Ar008 Cash 0 2000
现金
5 16/03/2011 0001 Ar001入场费200
6 16/03/2011 0001 Ar002细则100 0
7 16/03/2011 0001 Ar003正常节省1000 0
8 16/03/2011 0001 Ar004 Xmas Savings 2000
总计3300 3300
How can I design a General Ledger in crystal report from sql server database?
I have these fields using vb.net 2008
As shown below, there are 4 transactions for which money was received for specific purpose which appear on the receipt (DR) side eg Entrance fee Rctamt 200 pmtant 0
,Bye-law Rctamt 100 pmtant 0
transno date pmtmode acctno purcode pur rctamt pmtamt
1 16/03/2011 Cash 0001 Ar001 Entrance fee 200 0
2 16/03/2011 cash 0001 Ar002 Bye-law 100 0
3 16/03/2011 Cash 0001 Ar003 Normal Savings 1000 0
4 16/03/2011 Cash 0001 Ar004 Xmas Savings 2000 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, 3300
sno transdate acctno purcode pur rctamt pmtamt
Entrance fee
1 16/03/2011 0001 Ar008 Cash 0 200
Bye-Law
2 16/03/2011 0001 Ar008 Cash 0 100
Normal Savings
3 16/03/2011 0001 Ar008 Cash 0 1000
Xmas Savings
4 16/03/2011 0001 Ar008 Cash 0 2000
Cash
5 16/03/2011 0001 Ar001 Entrance fee 200
6 16/03/2011 0001 Ar002 Bye-law 100 0
7 16/03/2011 0001 Ar003 Normal Savings 1000 0
8 16/03/2011 0001 Ar004 Xmas Savings 2000
Total 3300 3300
推荐答案
您应该首先研究 ^ ]代码项目文章.
You should start by researching these[^] Code Project articles.
在Crystal报表中使用组.
在Visual Studio 2010的SAP Crystal Reports中使用组专家和分层分组 [使用ASP.NET和Crystal报表构建报表-第4部分:动态分组 [
Use Group in Crystal reports.
Using the Group Expert and Hierarchical Grouping in SAP Crystal Reports for Visual Studio 2010[^]
Building Reports Using ASP.NET and Crystal Reports - Part 4: Dynamic Grouping[^]
这篇关于来自vb.net的水晶报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
