Sequential Numbers

[mmwdmr]

Does anyone know of a good formula for finding gaps in sequential numbers? Thanks!

 

[emcevoy]

Hello

Could you give more detail as to what version you have, as there is differences in the formula features in the versions.

Also, if you could give some detail on how the data is set up (the sequence), report, what you have already, etc, perhaps we can come up with something.

I look forward to your reply. Eileen McEvoy
Crystal Reports Consultant and Trainer

http://www.pacificridge.ca

emcevoy@pacificridge.ca

 

[kenhamady]

You could suppress the details with the following formula:

{field} - Previous ({Field}) = 1 Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mmwdmr]

Thanks Ken! I'll answer Eileen's questions to see if she comes up with something. It never hurts to have multiple solutions.

I'm on 8.5 and have not started the report yet. The data is just a series of sequential numbers (assigned to applicants)that were manually entered into a database. My client wants to make sure no applicants were missed in the data entry process. Gaps in the sequence will indicate that. Thanks!

 

[emcevoy]

Hi

Actually, Ken has a good idea. What the formula would do is suppress all the records that are in secquence, and if there are any that are not in sequence, you will see the next number.

The only thing with this is that you would also have to check for first record.

if (not(onfirstrecord) and {field} - Previous ({Field}))= 1

for example if your numbers were

1
2
3
5
6
8

then in the report,you would only see 5 and 8, you would know that the number 4 was missed and the number 7 was missed.

Hope this helps and thanks Ken.
Eileen McEvoy
Crystal Reports Consultant and Trainer

http://www.pacificridge.ca

emcevoy@pacificridge.ca

 

[mmwdmr]

This worked perfectly - thanks everyone!