如何总结每个组在水晶报告的运行总字段？ [英] How to sum running total field for each group in crystal report?

问题描述

我在结晶报告中有问题，

这是我的代码在google中有许多参考网站，

  // {@reset} 
 //放在组头
 whileprintingrecords; 
全局numbervar Sum_Cumm_Sum：= 0; 
 
 // {@increment} 
 //放入节详细信息
 whileprintingrecords; 
 global numbervar Sum_Cumm_Sum：= Sum_Cumm_Sum + {@ getIP}; 
 
 // {@display} 
 //放在组页脚
 whileprintingrecords; 
 global numbervar Sum_Cumm_Sum; 
  

where getIP is Formula，

  {＃sumKN} / {＃sumSKS} 
  

正在使用重置更改组运行总字段，

  {＃sumKN}字段KN 
 {#sumSKS} =字段SKS的运行总字段
  

=== ==================================================== =======

我使用所有这些代码，但在 Sum_Cumm_Sum：= Sum_Cumm_Sum + {@ getIP}

=http://i.stack.imgur.com/CSmsB.png =nofollow> http://i.stack.imgur.com/CSmsB.png

解决方案

使用手动运行总计或运行总计字段，而不是两者。顺便说一句，运行总字段只能在 footer 部分中使用。

更好的方法：

  {＃sumKN}  - 字段为{table.KN}总结所有记录;在组
 
 {#sumSKS}  - 字段为{table.SKS}后更改复位;总结所有记录;复位后更改组
 
 //位于`footer`部分
 // {@ ratio} 
 
 //可选
 // EvaluateAfter {#sumKN}）; 
 // EvaluateAfter（{＃sumSKS}）; 
 
 {#sumKN} / {#sumSKS} 
  

i have problem in crystall report,

Here is my code following many reference site in google,

// {@reset}
//place in group header
whileprintingrecords;
global numbervar Sum_Cumm_Sum:=0;

// {@increment}
//place in section detail
whileprintingrecords;
global numbervar Sum_Cumm_Sum:=Sum_Cumm_Sum+{@getIP};

// {@display}
//place in group footer
whileprintingrecords;
global numbervar Sum_Cumm_Sum;

Where getIP is Formula,

{#sumKN}/{#sumSKS}

and code in it is running total field with reset on change group,

{#sumKN} is running total field for field KN 
{#sumSKS} = is running total field for field SKS

============================================================

I use all this code, but in Sum_Cumm_Sum:=Sum_Cumm_Sum+{@getIP}, I can't get the right value.

Here is my report view:

http://i.stack.imgur.com/CSmsB.png

解决方案

Either use a manual running total OR a running-total field, not both. By the way, a running-total field only works in a footer section.

A better approach:

{#sumKN} - field is {table.KN}; summarize for all records; reset after change in group

{#sumSKS} - field is {table.SKS}; summarize for all records; reset after change in group

// place in `footer` section
//{@ratio}

// optional
// EvaluateAfter({#sumKN});
// EvaluateAfter({#sumSKS});

{#sumKN} / {#sumSKS}

这篇关于如何总结每个组在水晶报告的运行总字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！