如何在水晶报表中合并相同的行。 [英] How to merge same rows in crystal report.
问题描述
先生,我的报告现在看起来像: -
ID - 金额
1 - 250
1 - 555
1 - 350
2 - 666
2 - 100
但是我希望显示我的数据: -
ID - 金额 - 总计
1 - 250 - 1155
555
350
2 - 666 - 766
我尝试过的事情:
i已经做了所有。只需要显示我的数据。
在您的报告中执行以下操作;
a)在报告中添加一个组 - 按您的ID分组
b)添加一个公式字段,按您的ID汇总金额 - 公式应如下所示
Sum({ TableName.Amount},{TableName.ID})
c)将您的公式字段添加到组标题 - 将字段置于金额字段右侧
d)打开Section Expert并选择Group Header
e)选择Underlay以下部分选项
亲切的问候
sir, my report are now look like :-
ID - Amount
1 - 250
1 - 555
1 - 350
2 - 666
2 - 100
but i want to show my data look like :-
ID - Amount - Total
1 - 250 - 1155
555
350
2 - 666 - 766
100
What I have tried:
i have done all. only need to show my data look like that.
Within your Report do as follows;
a) Add a Group to the Report - Group by your ID
b) Add a Formula field that Sums the Amounts by your ID - the formula should look like below
Sum({TableName.Amount},{TableName.ID})
c) Add your Formula field to the Group Header - position the field to the right of your Amount field
d) Open Section Expert and select the Group Header
e) Select the option "Underlay following sections"
Kind Regards
这篇关于如何在水晶报表中合并相同的行。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!