We have several reports in SSRS which will be available to various users through Report Manager. The reports are using drop-down lists to select company and department, both as parameters. The reports work perfectly.
But the challenge is, the drop-down list should only have the company(ies) and the department(s) the user is allowed to see.
As solution, my thoughts are:
a) create a usersTable and assign companies/dept to each user
b) users will log-in into the Report Manager
c) use username in log-in to search usersTable
d) create company & dept datasets and populate them with data from usersTable
e) use datasets for parameters
My problem is how and where to extract the users log-in information.
Is my proposed solution viable? If so, how to overcome the problem of extracting users info? Or, is there a better solution?
Thanks and will greatly appreciate any help.
But the challenge is, the drop-down list should only have the company(ies) and the department(s) the user is allowed to see.
As solution, my thoughts are:
a) create a usersTable and assign companies/dept to each user
b) users will log-in into the Report Manager
c) use username in log-in to search usersTable
d) create company & dept datasets and populate them with data from usersTable
e) use datasets for parameters
My problem is how and where to extract the users log-in information.
Is my proposed solution viable? If so, how to overcome the problem of extracting users info? Or, is there a better solution?
Thanks and will greatly appreciate any help.