test for consecutive numbers 1

[Mikele]

in a single database table I wish to test a single field for consecutive numbers and report (print) the missing entries. i.e table contains:- 11, 12, 14, 16, 17
the report would print 13, 15

cheers

 

[kenhamady]

Here is a simple technique that does what you want. It identifies the gaps in a sequence and shows the width of the gap. If three consecutive records are missing it will print the first and last ones missing:

Create 2 formulas called PrintFrom and PrintTo:

PrintFrom: {field} + 1
PrintTwo: Next ({field}) - 1

Put these on the detail band with the word "to" between them.

Now, suppress you details with the following condition:

{PrintFrom} = Next ( {field} ) Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Mikele]

Thanks Ken
That was V useful, Just wondering if you could expand it slightly to allow me to print the range of missing entries (if applicable) i.e

Missing entries are:-
1
7
8
9
16
21

anyway
cheers