How to share a report in SQL Server Reporting Services

Question

I need to create a link to share a report that I created in SQL Server Reporting Services with other users. What is the best way to do this?

Answer 1

Once the report is created you need to deploy/publish the report for users to be able to visit it via link, here is the document with the steps for it:

https://learn.microsoft.com/en-us/sql/reporting-services/reports/publishing-reports-to-a-report-server?view=sql-server-ver16

Steps in short:

• Right click on the project and go to properties which will open the window like shown in screenshot below taken from link provided above
• There you have option (TargetServerURL) to enter the base URL
• You can find base url of your reporting server from panel which you can open by searching for Reporting services configuration manager in start menu for windows for your reporting services server.
• Make the changes accordingly for different options in properties of your report and click ok.
• Then right click on the project again and select deploy.
• Open the browser enter your reporting server base url/browse, browse for the report and clicking its name should load it.

Answer 2

Hi @Susan Moore,

You may deploy the report to web portal url and give the user access to open the report.

Or you may use subscription to send the report for the user.

Subscriptions and delivery (Reporting Services)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.