Missing #s in a list

[ChipF]

I need a report that shows all the missing applications (didn't go through the system) for the day, I have a daily query that runs all the apps in numerical order and produces a huge list, the ones that are missing just don't show, I want this report to show those missing numbers

here is a sample of the list of applications received:

20030552400001
20030552400002
20030552400003
20030552400005

in other words, I would want the application 2003055240004 to show up on the report, any help is appreciated

 

[butkus]

You'll need a couple of formula's and a supression formula

First formula

@from
{table.yournumber}+1

Second formula
@to
{table.yournumber}-1

(this assumes your fields are numberis otherwise - val({table.yourfield})

Place both of these fields on your details line

And enter the following in the format scetion supression formula editor

{@from}=next({table.yournumber})

Note, this will return a range of missing numbers like this

from to
20030552400004 20030552400004 (per your example)

hope this helps.

 

[ChipF]

since the application # field is a character, how do you write the format suppression formula?

my two formulas

@from
1+val({DLY_APPLICATION.OPR_APPLICATION_NR})

@to
1-val({DLY_APPLICATION.OPR_APPLICATION_NR})

format section suppression formula (this doesn't work)
{@from}=next({DLY_APPLICATION.OPR_APPLICATION_NR})

 

[synapsevampire]

I think there was an omission in part of that:

@to
val(next({DLY_APPLICATION.OPR_APPLICATION_NR}))-1

It should have next, and you shouldn't be subtracting it from 1, you subtract 1 from it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[ChipF]

thanks everyone, this just saved us 2 hours, very very appreciated!