在Crystal报表中分组. [英] Grouping In Crystal Report.
问题描述
我在表中有一些字段,其中也有"ID"列.我想根据相同的记录对它们进行分组.例如,
表1
ID开头 总计
----------------------
1 200 100nbrsp;
1 201 300 100< 100
2 400 100nbrsp;
2 100
这是一张表,我要在该表上生成如下的Crystal Report,
分组将在"ID"列上进行,总计将被添加.
ID 开始 结束 总计
--------------------
1 300 200< b 200
2 301 500 200
请尽快提供帮助,感谢adv.
I have some fields in a table, in which ''ID'' column is also there. And I want to group the records according to the same.eg,
Table1
ID Start End Total
----------------------
1 101 200 100
1 201 300 100
2 301 400 100
2 401 500 100
This is a table, on which I want to generate Crystal Report as follows,
Grouping will perforn on column ''ID'', Total will get added.
ID Start End Total
--------------------
1 101 300 200
2 301 500 200
Please help asap, thanks in adv.
推荐答案
首先在您的应用程序中准备ADO.NET数据集.
然后拖放U所需的列.
&in code发送带有Group by子句的SQL Select语句.
First prepare ADO.NET Dataset in your Application.
Then Drag & Drop the Column required for U.
& in code Send the SQL Select Statement with Group by Clause.
在Crystal报表中为ID列创建一个组.
在组标题和页脚之间将列ID,开始",结束"拖到Crystal报表上.
之后,为列合计创建运行合计.
然后将运行中的总计变量拖动到水晶报表上
Create a group for ID column in crystal report.
Drag column ID, Start, End on crystal report between the group header and footer.
After that create a running total for column total.
Then drag the running total variable on crystal report
这篇关于在Crystal报表中分组.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!