如何在水晶报表中汇总公式字段?

本文介绍了如何在水晶报表中汇总公式字段?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何在水晶报表的公式字段中添加累计或汇总字段?

How do I add a running total or summary field on a formula field in crystal reports?

// Sample Report Serial No. Premium Commission Net (Premium-Commission) ----------------------------------------------------------------------------- 1. 10 4 6 2. 40 30 10 --------------------------------------------------------------------------- Grand Total 50 34 16

在示例报告中，Net (Premium-Commission) 是一个为每一行评估的公式字段?如何为我的公式添加总计/汇总字段?看来我们只能在 Command 字段中添加汇总字段.

In sample report, Net (Premium-Commission) is a formula field which gets evaluated for each row? How do I add a grand total/summary field for my formula? It seems we can add a summary field to only Command fields.

推荐答案

假设 Net (Premium-Commission) 公式字段名称为 {@Net}.现在您必须创建另外三个公式字段.

Suppose Net (Premium-Commission) formula field name is {@Net}. Now you have to create another three formula fields.

Initializer:这个公式文件将被放置在标题部分以重置所有变量.

增量:此公式字段将放在详细部分以汇总值.

总计:此公式字段将放置在页脚部分以显示 {@Net} 的总计.

Initializer: this formula filed will be placed in header section to reset all variables.

Increment: this formula field will be placed in detail section to summarize the value.

Total: this formula field will be placed in footer section to show total of {@Net}.

代码将写在公式字段中，如下所示.

Code will be writen in formula fields as below.

{@Initializer}同时打印记录；Numbervar dSum :=0;

{@Increment}同时打印记录；Numbervar dSum;//不初始化零dSum:=dSum+{@Net};//{@Net} 公式字段必须是返回数值

{@Total}同时打印记录；Numbervar dSum;//不初始化零dSum;

将所有公式字段放在相应的部分并禁止 {@Initializer} 和 {@Increment} 公式字段.

Place all formula fields in their appropriate section and suppress {@Initializer} and {@Increment} formula field.