String field containing characters 0-9 only

[ehk]

Crystal 8.5
Datasource: Advantage SQL

Can you please tell me how to select records that contain only numbers within the field {Payldgr.Invoice} which is String/10?

I would like to exclude any invoices containing characters other than 0-9. Valid records can contain any combination of numbers in varying lengths, representing patient account numbers.

Thanks,

Ellen

 

[dgillz]

In your record selection formula:

Isnumeric({YourField})

The above will only return strings that are all numbers, no spaces, letters, punctuation marks, etc. allowed.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[ehk]

Thanks so much for the quick response. That's exactly what I need.