HSI_guelph
asked on
SSRS reports for parameters for admin vs users
I've got an employee summary report running that we send each week to the team leader and administration and will be rolling it out to employees as well. My boss wants lots of extra options and customizations that we would allow someone of his rank but we would restrict the general users options to what is specific to them alone. I'm wondering what would be the best way to handle this situation?
I can get the user's id from the Built-in Field User ID and I know I can restrict datasets and such but would it be better to have seperate reports as opposed to one report with restrictions? If I use one report then I only need to change one file if I update it but the parameters my boss wants should not be available to individual employees (who should only see themselves and their team). Is there a way to make a parameter visible if a certain condition is met and not visible as a default so that team members can't choose a different team in the drop down?
I've created webpages with Admin and regular User options in JSP before in external include files and headers, should I try to do the same thing in SSRS? Is there a standard practice that is preferred by report designers that optimizes report generation while maintaining security for confidential data?
I can get the user's id from the Built-in Field User ID and I know I can restrict datasets and such but would it be better to have seperate reports as opposed to one report with restrictions? If I use one report then I only need to change one file if I update it but the parameters my boss wants should not be available to individual employees (who should only see themselves and their team). Is there a way to make a parameter visible if a certain condition is met and not visible as a default so that team members can't choose a different team in the drop down?
I've created webpages with Admin and regular User options in JSP before in external include files and headers, should I try to do the same thing in SSRS? Is there a standard practice that is preferred by report designers that optimizes report generation while maintaining security for confidential data?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both for your input!! I truly appreciate it!
ASKER
Does this sound like a good approach?