There is the potential to vastly improve upon reporting if we could execute stored procedures or sql queries in te context of the current user rather than the service account. This could be simply facilitated by allowing the use of parameters such as '@Username' which would be replaced in the query prior to execution.
As an example, you could find all the users in the same office as the logged in user with a simple query like:
select ad.username, ad.name, ad.email from tbladusers ad left join
tbladusers me on me.username = '@Username'
where ad.office = me.office
