Omitting Records

[skbrimer]

I'm trying to omitt records that I use for tracking my jobs. Once a job is complete I would like to Omitt it from the report.

I wrote a script that omits the jobs that are complete and it works. Each job has multiple records under each job title and it gets rid of them all. Woot!

My problem is the jobs that are not complete it omits some of the records in them as well. It still lists the job as not complete, but some of the related records are gone. There is nothing in the fields that I told it to compare with to find out if the job is complete, but it still omits them.

Has this happened to anyone else?

[Ender]

Welcome!

Can you share what the actual script is that you use for this report? Also, give us some sample data for the relevant fields.

[skbrimer]

I can give you the script but not the actual data. I can probably give an eample.

Here is the script

>show all records

>goto first record

>Loop

>Omit Mulitple Records[no dialog; isempty(Fill:serial number)]

>next record. exit after last

>End Loop

>sort[restore,no dialog]

>show omited only

>goto preveiw mode

thats it, short simple, and I had hoped little errors but something is wrong in it.

[skbrimer]

Figured it out. Thanks