如何获得水晶报表10中的组总和? [英] How to get sum of groups in crystal report 10?

问题描述

我有一些发票的报告，每张发票都有这样的几行:

I have a report with for some invoices and each invoice has some lines like this :

invoice1 2000
     line1   300
     line2   700
     line3   500
     line4   500
invoice2 1000
     line1   300
     line2   400
     line3   300

现在，当我对组#1 使用摘要时，我应该得到 3000 作为组金额的总和.但它显示了 11000 (4X2000)+(3X1000)，因为它是发票行的总和！
我该怎么办?

Now, when I use summary for group#1, I should get 3000 as sum of group amount. but it shows me 11000 (4X2000)+(3X1000) because it sums invoice lines!
what should I do?

推荐答案

你应该有放在你的'Group Footer #1'中的运行总计

You should have running total that is placed into your 'Group Footer #1'

如果您右键单击并选择编辑运行总计"，您应该有以下内容:

If you right-click and select 'Edit Running Total' you should have the following:

• 要汇总的字段应该是您希望汇总的值.我想这是正确的！
• 摘要类型 - 应为 sum
• 评估 - 应选择针对每条记录".
• 重置 - 应选择组更改时"并应选择第 1 组.

更新在这种情况下，如果汇总数据出现在源数据中，并且您对整个报告的总计将运行总计更改为仅评估每张发票(第 1 组)并且不重置.

Update In this case if the summary data appears in the source data and you a total for the whole reports change the running total to only evalute for each invoice (Group #1) and don't Reset.

注意:假设 第 1 组 位于 发票编号 上，并且所需的摘要适用于整个报告

Note: Assuming Group #1 is on Invoice Number and the summary required is for the whole report

所以现在的步骤是:

• 要汇总的字段应该是您希望汇总的值.我想这是正确的！
• 摘要类型 - 应为 sum
• 评估 - 应该选择On chnge of group".
• 重置 - 应选择 从不"，并应选择第 1 组.

• Field to summarize should be your value you wish to sum. I guess this is correct!
• Type of summary - should be sum
• Evaluate - 'On chnge of group' should be selected.
• Reset - 'Never' should be selected and Group #1 should be chosen.

这篇关于如何获得水晶报表10中的组总和?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！