如何在Crystal Report 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?

推荐答案

您应该已经将运行总和放入了组页脚＃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:

• 要汇总的字段应为您希望累加的值。我想这是正确的！


• 摘要类型-应该是总和


• 求值-应该选择对于每条记录。


• 重置-应选择更改组，并应选择第1组。

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

更新
在这种情况下，如果摘要数据出现在源数据中，并且您的整个报告总数总计将运行总计更改为仅评估每张发票（第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.

注意：假设 Group＃1 位于发票编号上，并且需要摘要是用于整个报告的

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

所以现在的步骤是：

• 字段总结应该是您希望总结的价值。我想这是正确的！


• 摘要类型-应该是总和


• 评估-'在组中更改'


• 重置-选择从不 ，并选择组＃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.

这篇关于如何在Crystal Report 10中获取组总数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！