如何在水晶报表中的汇总字段中创建总和或运行总和？ [英] How do I create a sum or running sum on a summary field in crystal reports?

问题描述

我有一份报告，查看案件的周转时间。每个案例都有多个部分。我想总结时间，但仅限于2个或更少部分的情况。

因为要表示少于3个部分的字段是摘要字段，所以我不能将其用作运行总计或其他摘要的条件。

关于如何解决这个问题的想法？



例如，

case123 20min partA

case123 22min partB

来电的总和是42



case558 20min partA

case558 20min partB

case558 20min partC

rec-call总和是60

我想总结只有那些<< 3部分。由于总和是在小组级别计算的，所以不允许我选择该字段。



我尝试过的方法：



运行总计，公式和各种方法的摘要

解决方案

查看以下内容：

Crystal Reports组选项 [ ^ ]

如何在Crystal Reports中对数据进行分组| UniversalClass [ ^ ]

Crystal Reports在组中运行总和 [ ^ ]

I have a report that looks at turn around times for cases. Each case has multiple parts. I want to sum the times, but only for those cases with 2 or less parts.
Because the field to denote less than 3 parts is a summary field, I can't use it as the condition for a running total or other summary.
Thoughts on how to crack this?

For example,
case123 20min partA
case123 22min partB
sum of rec-call is 42

case558 20min partA
case558 20min partB
case558 20min partC
sum of rec-call is 60
I want to sum up all the totals for only those that have <3 parts. Since the sum is calculated at the group level, it won't let me choose that field.

What I have tried:

Running totals, formulas and summaries of various means

解决方案

Check out these:
Crystal Reports Group Options[^]
How to Group Data in Crystal Reports | UniversalClass[^]
Crystal Reports Running Total Sum on Group[^]

这篇关于如何在水晶报表中的汇总字段中创建总和或运行总和？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！