Numeric strings and toNumber function

[Former Member]

Hello,

I'm having problems with Crystal Reports for Eclipse when using some reports.

The problem comes with reports that contain toNumeric function with a data that is get from the database, it gives an error that says the string is non-numeric even if it is a numeric string. The formula in the reports looks like this:

...
numberVar cantidad_dias := ToNumber({MYVIEW.NumericText});
...

I know that using isNumeric condition it works well, but it works well too when using Crystal Reports 2008 without any condition, so I think it should work for Crystal Reports for Eclipse and return error only in the case that the string isn't numeric. Is it a bug?

Thanks

[Former Member]

I have printed all the values that are used by the function and are OK, but it still return error when using Crystal Reports for Eclipse.

Thanks for answering.

[ted_ueda]

Then I would try printing out the function

    IsNumeric({MYVIEW.NumericText})

to see if any field comes up as false.

Sincerely,

Ted Ueda