本文介绍了如何在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组),请勿重置。

UpdateIn 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中获取组总数?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-26 15:19