检查Crystal Reports中的数值 [英] Check for Numeric Value in Crystal Reports

问题描述

我需要检查数据库字段中是否包含数字值。这里是一些伪代码：

I need to check if a database field contains a numeric value in it. Here is some pseudo code:

if {myField} is numeric
    // do something
else
    // do something else

我正在寻找一个函数，

I'm looking for a function that will allow me to do the check '{myField} is numeric'.

为了帮助，下面是{myField}的一些可能的值，结果应该是什么：

To help, here are some possible values for {myField} and what the result should be:

{myField} = ''          returns false
{myField} = 'abc123'    returns false
{myField} = '123abc'    returns false
{myField} = '123'       returns true

推荐答案

使用Crystal语法

Using Crystal Syntax

NumericText({field})  //Returns a Boolean

使用基本语法

IsNumeric({field})  //Returns a Boolean

这篇关于检查Crystal Reports中的数值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！