Add "nickname" to user accounts. Then display nickanme on reports. This would allow a user to create duplicace users (e.g. same provider twice) and add a locationa as a nickname. As an example.
Bob Location A Smith
Bob Location B Smith
Then when running a report based on provider, you would filter based on the appropriate provider for that "location".