Hi I4QR1A,
According to your description, you want to deploy report to report manager, so other users can access the report.
After we create a report in report designer, we need to publish it to a report server to make it available to users. In Report Designer in Business Intelligence Development Studio, we must specify the report server as well as folders for reports and shared
data sources so that we can publish the items in a project. For detail information, please refer to the following steps:
- Right-click the report project, and then click Properties.
- In the Property Pages dialog box for the project, select a configuration to edit from the Configuration list.
- In OverwriteDataSources, select True to overwrite the data source on the server each time reports are published, or select False to keep the data source on the server.
- In the TargetDataSourceFolder text box, type the folder on the report server in which to place the published shared data sources.
- In the TargetReportFolder text box, type the folder on the report server in which to place the published reports.
- In the TargetServerURL text box, type the URL of the target report server, then click OK.
- Right-click the report in the project, then click deploy, after the report is successfully deployed, you can preview the report in report manager.
For more information about Publishing Reports to a Report Server, please refer to the following document:
https://msdn.microsoft.com/en-us/library/ms159270(v=sql.110).aspx
Reporting Services uses role-based security to grant user access to a report server, and there are two types of roles: Item-level roles and System-level roles. On a new installation, only local administrators have access to a report server. If the user need
to have access to reports, folders, models and shared data sources, a local administrator must create a role assignment to define the tasks a user can perform by following steps:
- Start Report Manager by going to URL http://servername/Reports as administrator.
- Click drop-down arrow next to the folder.
- Click Security in the drop-down list.
- Click New Role Assignment. In user, enter the user account.
- Select appropriate access, and then click Apply.
For more information about Role Assignments, please refer to the following article:
http://technet.microsoft.com/en-us/library/aa337471(v=SQL.105).aspx
If you have any more questions, please feel free to ask.
Thanks,
Wendy Fu
If you have any feedback on our support, please click
here.