I have created a radio button value list for our project status (estimate, developement, awaiting approval, in production, completed) and have used this value list to sort the records in a report. I would like to create a report showing all records, except completed, sorted by category. I can't seem to create a script that will do this and am left to performing multiple find commands to do so at this point.

Allow User Abort [Off]

Set Error Capture [On]

Enter Find Mode [ ]

Set Field [status; "complete"]

Omit Record

Perform Find [ ]

If [not Get(FoundCount)]

Show Custom Dialog ["All records are complete."]

Show All Records

Else

Sort [by Status]

{rest of reporting steps}

End If