Create Report Parameter Sets

Because report parameter sets reside on the Reporting Services server, security on the server determines who has access to these reports from outside the program. Those permissions could be set up to be different than role-based security as defined in the program. Security on the Reporting Services server is inherent based upon the security of the folders on the server. You could set up a folder structure to mimic your roles in the program. That way, permissions for report parameter sets accessed directly from the server can be similar to the role-based permissions in the program.

If two different roles need access to a report parameter set on the Reporting Services server, you need to have a parameter set in each of those folders. However, report parameter set names on the Reporting Services server must be unique. If you set up folders on your Reporting Services server to mimic roles in the program, a report in two different places must have two different names, even if those reports are the same.