Report record exclusion needed
I have 2 tables:
Status (text) -- Holds values like: "Deceased" "Active" etc...
Proficiency: -- holds values like: "programming" "accounting" etc.
I have created a sub summary report grouped and sorted on Proficiency. It works. But it also includes members who have a status of "Deceased". (not desired)
Do I need to first perform a 'find' on a subset of the data where Members::Status <> "Deceased".... ???
Your thoughts are appreciated.
I'd suggest you start by finding the members you want to report on, in the Members table e.g.
Go to Layout [ Members ]
Perform Find [Restore; Omit Records; Criteria: Members::Status: “Deceased" ]
Then use the Go to Related Record [ Show related only; Match found set ] step to create the found set in Proficiencies.