运行总计字段给出了Min，Max等选项，但不是Sum [英] Running total field gives options for Min, Max, etc. but not Sum

问题描述

我想要如下设计水晶报表

名称//（群组）

---

 日期金额
 
 12/04/2010 100 
 
 12/05/2010 200 
 
 Total ...。 300 
  

但是插入时出现问题通过更改组字段运行总计。

我试过右键点击字段Insert + Running Total。但夏季类型中没有

总和的选项。

夏季类型

最大

最小

计数

独特计数

第N小

如何添加/减少/增加Group Wise？ >

解决方案

将数据类型列转换为整数类型， 。在水晶报告中，总和将只出现在数字字段，并且您的帖子说，最大，最小，计数，区别计数，第N最大，第N最小将仅适用于 varchars 。检查水晶语法

I wants to design Crystal Reports as follow

Name //(Group)

---

Date                   Amount

12/04/2010             100  

12/05/2010             200

Total….                300

But there are problem on insert Running Total summarize by change of group fields.

I have tried by right clicking on field Insert + Running Total. But there are no option of

Sum in Type of Summery. There are following option :

Type of Summery

Maximum

Minimum

Count

Distinct count

Nth largest

Nth smallest

How can I add/minus/multiply Group Wise ?.

解决方案

Convert the Datatype of Amount column into an integer type and check with database again. In crystal reports the sum will appear only to the number fields and as your post says the Maximum, Minimum, Count, Distinct count, Nth Largest, Nth Smallest will comes only for varchars. check crystal Syntax

这篇关于运行总计字段给出了Min，Max等选项，但不是Sum的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！