String Problem

[sl71]

I have a Database which uses a String Data Type for an Invoice Number. I have designed a Crystal Report to prompt for value(s) which are used as Invoice numbers to query the Database.
I have based the Group Sort on the Invoice Number.
My problem is during a print preview numerals which are not in the record set are displayed.

i.e Invoice Number 200 to 220 will display the following:

200
201
202
203
204
205
206
207
208
209
21
210
211
etc

I understand why this is occuring (because the number is stored as a string) but was wondering if there is a way to filter the non required numbers out.

Thankyou for your help.

 

[Madawc]

For the above case, you could suppress using mid({your.field}, 3, 1) = " ".

You could also try ToNumber({your.field}) to turn it back into a numeric value.

Madawc Williams (East Anglia, UK)