更新时间:2023-02-03 08:11:57
在Crystal中,您可以创建一个公式, code> ToNumber 函数。编写该字段可能包含非数字数据的可能性可能是个好主意,例如:
Within Crystal, you can do it by creating a formula that uses the ToNumber
function. It might be a good idea to code for the possibility that the field might include non-numeric data - like so:
If NumericText ({field}) then ToNumber ({field}) else 0
以转换报表中使用的查询中的字段的数据类型。
Alternatively, you might find it easier to convert the field's datatype within the query used in the report.