Script to find and omit in a report

[Drusus]

Hello, I hate to ask a question that has been answered. I always try to find the answer by searching but just havent been able to find one for this task I need to accomplish.

 

What I am trying to do is write a script that will search fields on a report layout in several fields then omit those records that have the found values.

 

Example:

 

I have two fields.

 

Department and Status

 

I have a report with my records sorted by Last Name.

 

I need the script to search for records that have the value 'Service' in the department field and omit all records with the value 'Service' from my report.

 

At the same time I also need that script to search the Status field and omit all records that have the value 'incomplete'

 

I may need it to also search the Status field to omit all records that have the value 'not attempted'

 

I have attempted to have the script do a search of a single field and then do an 'omit multiple' but is simply doesnt omit what I am wanting it to and I am just not sure the correct way to go about structuring the script.

 

Any ideas? I can do this manually by doing a find / omit then constrain found set but I can seem to script it correctly...

 

I found this which seems as though I can save a manual find and omit sequence but its not clear to me how the script it shows is referencing to a saved find or if this is even a good way to accomplish wha I am looking to do.

 

http://help.filemaker.com/app/answers/detail/a_id/4641

 

Thanks

[doughemi]

Try

 

Enter Find Mode

Set Field[department; "service"]

Omit Record

New Record/Request

Set Field[status; "incomplete"]

New Record/Request

Set Field[status; "not attempted"]

Omit Record

Perform Find

 

Make sure the "specify find requests" checkbox is not checked on either the enter find mode or perform find steps

[Drusus]

Thanks for the reply...

 

this eliminated ALL records with 'Not Attempted' in the Status from every category from the report which is good...

 

It also removed all the reports that showed 'Completed' for 'Service' which is good...So it is trying to remove all Service

 

However... it left all the 'Incompletes' from ALL categories including the 'Service' 'Incompletes'...

 

While it needs to remove ALL records where department is 'Service'...ALL Not Attempted accross the board...and ALL Incompletes across the board for Status.

 

I think I got it though. I just inserted another 'Omit Record' and it seems to be omitting everything I needed to omit...

 

Enter Find Mode

Set Field[department; "service"]

Omit Record

New Record/Request

Set Field[status; "incomplete"]

Omit Record

New Record/Request

Set Field[status; "not attempted"]

Omit Record

Perform Find

 

My problem before was I wasn't setting the feild incorrectly and trying to use omit multiple records.

 

thanks for the help.