How do I only show only a particular job title in the report

[pectin232]

An employee can have one or more roles [sometimes even up to 4-5 roles] sometimes a dozen more. The data comes in a tremendous amount. I tried to use Group expert to remove the duplicates but it still shows. I am trying to 'Show' only if the employee is a Supervisor and a Primary Worker.

name John, Smith
Role Supervisor
Address XXXXXXXXXXXXXXXXXXXXXXXXXX

name John Smith
Role Data Transfer Worker
Address XXXXXXXXXXXXXXXXXXXXXXXX


name Jessica Lange
Role private nurse
Address XXXXXXXXXXXXXXXXXXXXXXXXX

name Jessica Lange
Role Primary worker
Address XXXXXXXXXXXXXXXXXXXXXXXXXXX

 

[lbass]

You should be able to use a record selection formula like:

{table.role} in ["Supervisor","Primary Worker"]

-LB

 

[pectin232]

Thanks so much that helped...