列的Crystal报表总和数据 [英] Crystal Report Sum of a Column data
问题描述
我在报表中显示的数据集中有GrandTotal字段.我想在页脚中显示所有数据的总和.
I have field GrandTotal in my dataset which I am showing in my report. I want show the total of all data in the footer .
我的列数据是字符串.
我试图做一个波纹管
SUM(ToNumber({Ds.Grandtotal}))
但它的说法是必填字段.
But its saying a field is require.
推荐答案
您必须将字段转换为数字,然后尝试获取总和.
You must convert the field into number, and then try to get the sum.
第1步:从字段资源管理器中创建一个新公式,为该公式命名(相关名称).
Step 1: Create a new formula from field explorer, give a name to formula (relevant name).
第2步:将该字段转换为数字.
Step 2: Convert the field into Number.
第3步:然后添加公式字段的总和
Step 3: Then Add Sum of the formula field
第4步:将公式"字段放入报表页脚".
Step 4: Place that Formula field into the Report Footer.
添加公式:
选择要转换为数字或货币的字段:
Choose Field to Convert into Number or Currency:
然后,在字段转换后,通过从报告"字段中选择公式的名称来获取公式"字段的总和.公式字段以fx作为前缀.
Then After Field Conversion, get the Sum of the Formula field by choosing name of the formula from the Report fields. Formula field has fx as prefix.
这篇关于列的Crystal报表总和数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!