I have a table that displays employee data, some of which is sensitive. We want to hide the employee name for users who don't have the proper security. I already have the following datasources. I am just not sure how to link them together to get the results I want.
| Employee Data: | | |
| Name | Salary | PayGroup |
| Jane Doe | 20000 | 1 |
| John Doe | 15000 | 2 |
| Jim Smith | 10000 | 3 |
| Joe Shmoe | 5000 | 4 |
| Tom Thumb | 25000 | 1 |
| Current User Name: |
| UserName |
| =USERNAME() |
| User Security Info: | |
| Username | PayGroup |
| mydomain\Donald | 1 |
| mydomain\Donald | 2 |
I have 2 users in my example - Donald and Nancy. When they view the report, the table should look like so:
| User Donald should see: |
| Employee Name | Salary |
| Jane Doe | 20,000 |
| John Doe | 15,000 |
| Tom Thumb | 25,000 |
| ***** | 15,000 |
| User Nancy should see: |
| Employee Name | Salary |
| ***** | 75,000 |
Any ideas?
