We have clients wishing to build custom reports on their data.
Is there a way where we can give them a web forms to authenticate (like our current web app uses e.g User Table including Username and password) which will then pass the username to the report model and filter the underlying dataset?
They will be coming in over the web.
We are running SQL 2008 R2
Any help or pointers would be greatly appreciated...