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.
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.