Wouldnt you just omit those records and run the report?
To expand on that a bit:
Enter find mode
# enter any search criteria you need here
Set field [Yourtable::terminated ; "Yes"]
The omit record script step, when executed in find mode, does the same thing that clicking "omit" does when setting up a manual find.
this is what my script looks like. I added the enter find mode and omit records step to the script automatically created when I created report. am I not putting it in the right place or doing something glaringly wrong?
go to layout ["studies"(main study page)]
enter findmode [here is said omit records if termianted=yes]
enter browse mode
show all records
and then it creates the report, but it still includes thestudies that are terminated.
You have a script step that shows all records, that step completely eliminates any found set of records created by your script. You also don't perform the find, you simply enter find mode and then return to browse mode.