Chris Barber shows how to create reporting which enables everyone within your organisation to see only the information for which they are authorised. The key benefits are:
1) Time saving – Maintenance of one set of data
2) Scale – The model is flexible as more individuals get added to the organisation
3) Secure – Leverages the current Microsoft infrastructure to maintain security by using the username of the logged in individual
4) Transparent – One set of data means that those who have the highest level of security can see exactly what everyone sees in the same report
The demo uses a fictional hierarchy to create commission numbers for each individual, limiting them to see only their data and that of anyone who reports into them directly or indirectly.
All files are in the link r