On the left is a list of teams. The rightmost column contains a count of errors, if you click on count of errors you will drill-through to a detailed report that lists individual errors.
The report works and is fully functional!
However, I am trying to apply a security model that will restrict users to only view detailed error data for their own teams.
To illustrate: members of the Core Team can view details of the 943 errors but cannot view details of any details for the Adult Antenatal team.
I have created a lookup table that lists all users and the TeamCodes they can access.
Any thoughts on how I can look up the CurrentUser, lookup the team name compare it to two tables and validate if they can access the drill through or not?
I also have a table that lists all TeamCodes e.g. VHCAB and their corresponding Team Names e.g. CORE