I have a table of employees that includes their login email address and a field that indicates if they can see confidential information (Yes/No).
I have a report with each record marked if it contains confidential information.
When a report is opened I want to show only records that are non confidential unless the employee is allowed to see confidential information. In creator version 4 I would use a custom action that fetches the employee record based on the login ID. Then an openurl statement is used to open the report with criteria to exclude the confidential records based on the employee record. In C5 is that the best approach?