How to share a report in SQL Server Reporting Services

Susan Moore 0 Reputation points
2024-05-08T15:58:59.96+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,884 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,823 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Shivam Kumar 541 Reputation points
    2024-05-08T19:11:24.4733333+00:00

    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.ssrs_project_properties
    0 comments No comments

  2. ZoeHui-MSFT 33,551 Reputation points
    2024-05-09T02:03:38.2433333+00:00

    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.

    0 comments No comments