使用水晶报告生成摘要报告 [英] generate summary report using crystal report
问题描述
我想用水晶报表10创建一个销售摘要报表.
请帮忙,因为我是最新报告.
产品名称销售(2009)销售(2010)
ProdA 250561
ProdB 360 150
----------------------------------------------
Grand Totral 610711
我有两个桌子
1.产品负责人
2.销售
ProductMaster
-------------
ProdName ProdCode
ProdA 01
销售
-------
ProdCode销售城市年
01 35孟买2009
01 60德里2008
02 150 Delhi 2009
I want to create a summary sales report with crystal report 10.
please help as i am new in crstal report.
ProductName Sale(2009) Sale(2010)
ProdA 250 561
ProdB 360 150
----------------------------------------------
Grand Totral 610 711
I have two table
1. product master
2. Sales
ProductMaster
-------------
ProdName ProdCode
ProdA 01
Sales
-------
ProdCode Sale City Year
01 35 Mumbai 2009
01 60 Delhi 2008
02 150 Delhi 2009
推荐答案
您需要 PIVOT [ ^ ]以获得结果.也许交叉表报告会为您提供帮助.
You need PIVOT[^] to get the result. Or may be a cross tab report will help you.
尝试一下,
http://csharp.net-informations.com/crystal-reports/csharp- crystal-reports-stepbystep.htm [ ^ ]
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-without-database.htm [ ^ ]
Try this,
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm[^]
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-without-database.htm[^]
您可以在Crystal报表中使用Crosstab Report来实现.
不错的文章,并提供逐步说明.来吧.
使用Crystal Reports在Visual Studio 2005中创建交叉表报表 [
You can achieve that using Crosstab Report in Crystal reports.
Nice article with step by step explanations. Go ahead.
Creating a Crosstab Report in Visual Studio 2005 Using Crystal Reports[^]
Do customizations based on your need.
这篇关于使用水晶报告生成摘要报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!