Missing number in a string sequence

[turtlepatch]

I have a problem similar to thread149-912093 except that my sequence of invoices are strings.

Basically I have a list of InvoiceID's that are sequential, however, I need to identify the one's that have been deleted. For example...

10001
10002
10004
10005
10007

I need to be able to have the missing 10003 and 10006 displayed.

I've tried using the solution in the thread mentioned above, changing my InvoiceID to number with tonumber(), but it tells me that the string is non-numeric.

I am using Crystal Reports 11 and am using an ODBC connection to our Hagen database.

 

[CR85user]

Is the invoice ID a string? Does the ID have any other text that forms part of it?

Try using VAL() which will take the numeric value from the left up until it reaches any non-numeric characters.

'J

CR8.5 / CRXI - Discovering the impossible

 

[dgillz]

ToNumber(Trim({YourField})) or Val({YourField})

One or both of these should work.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?