>I have a set of record with the running
>ticket number. Can the Crystal report or foxpro report find out the missing ticket number from running ticket number ? How?
>
>Any coding or help will appreciate. Thanks

Do you mean, you have numbers like "1, 2, 3, 5, 6" and want to find what numbers are missing (in the example, "4")?

There is no fast way to do this with Visual FoxPro reports. However, you can easily write a loop to copy the missing numbers into a cursor.

Pseudocode:

Get the lowest number.
Get the highest number.
Create cursor
for i = lowest to highest
   if not seek()
      insert into cursor
   endif
next

You could get faster performance by scanning through the table, and checking if the difference between one record and the next is greater than 1.

Is this what you mean?

Hilmar.