如何在水晶报表中汇总公式字段? [英] How to summarize a formula field in crystal reports?

问题描述

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

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.

1. Initializer:这个公式文件将被放置在标题部分以重置所有变量.
2. 增量:此公式字段将放在详细部分以汇总值.
3. 总计:此公式字段将放置在页脚部分以显示 {@Net} 的总计.

1. Initializer: this formula filed will be placed in header section to reset all variables.
2. Increment: this formula field will be placed in detail section to summarize the value.
3. 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.

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