Crystal Reports for Eclipse Designer Guide

IsNumeric (str)

IsNumeric and NumericText (str) are equivalent functions.
Description
IsNumeric returns True if the String argument can be converted to a Number and False otherwise.
Arguments
  • str is a text string.
  • Returns
    Boolean value (True or False)
    Action
    IsNumeric returns True if the String argument can be converted to a Number and False otherwise.
    Typical use
    If you store numbers (like weight) in a text String object, use IsNumeric to check the value of each record to make sure it is OK to convert using ToNumber or CDbl.
    Examples
    IsNumeric({file.REFERENCE})
    Returns FALSE where {file.REFERENCE} = "ABCDEFG".
    IsNumeric({file.IDNUM})
    Returns TRUE where {file.IDNUM} = "12345".
    IsNumeric({file.IDNUM})
    Returns TRUE where {file.IDNUM} = "12345443".
    IsNumeric({file.IDNUM})
    Returns FALSE where {file.IDNUM} = "12345-443".
    IsNumeric ({file.IDNUM} (1 to 5))
    Returns TRUE where {file.IDNUM} = "12345-443".
    IsNumeric ({file.IDNUM} (6))
    Returns FALSE where {file.IDNUM} = "12345-443".
    IsNumeric ({file.IDNUM} (7 to 9))
    Returns TRUE where {file.IDNUM} = "12345-443".
    IsNumeric({file.IDNUM})
    Returns FALSE where {file.IDNUM} = "12345T".
    You can use this function in combination with ToNumber or CStr to test for a Number in the Reference field, then return the string as a Number or return 0 if the text string is not a Number.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/