Background: There are 3 distinct views of the data I am usin. Each analyst is able to access one of these views based on their Active Directory group. The views were created to ensure that analysts using the back-end data directly could only access what they are allowed to access.
I have created 3 reports that are exactly the same, but each one reads from the view associated with what the end users are allowed to see. It was decided to do it this way so that the security model would be exactly the same between the views and the RLS would not need to be created twice. The reports are on Report Server now, but will be transitioning to Service soon.
Is it possible to create a parameter in the query that will look at the end-user's AD group and allow the report to access the correct view for the group?
