We now have well-prepared simple report after the 5th part of the series (Configuring parameter/filter in SSRS). This article is focused on report deployment in SSRS and covers how to get report on server so that other users can take a look at it. We will do a little configuration of the project and then the report Deploy itself. This post is shorter than others since there is nothing complicated about this procedure.
How To Deploy Report in SSRS
Let’s do a little recap of the state of our report after last part. We have set all connections, datasets and also a simple report reacting to filter “Rok” (year).
Configuring Report Server in Reporting Services
Final reports are usually deployed to a Report server and from there it is possible to browse through them in Report portal. Report server is located in address http://[someserverip]/ReportServer if installed in default. If you have SQL server express installed, then the address of your report server will be:
- http://[localhost]/ReportServer or
- http://[localhost]/ReportServer_LOCAL
It is the second possibility in my case. Address of Report Server can be changed in configuration manager. I will try to change the address so there will not be “_LOCAL” [2] on the end. We will commence execution [3] and new address operational check after the confirmation [4].
[1] Report server address now
[2] Change Report address in configuration manager
[3] SSRS report server address change confirmation
[4] Checking if the new address works
Project/Report Deploy in Reporting services
We already know the address of the report. All we need to do now is to deploy our report. But let’s configure the project first. We can do that by clicking on Project – Properties [5] and in Target server URL selection we will link to our report server address and confirm [6]. Last step is to click above the project and select Deploy [7]. Message on successful deployment is available in Output window [8].
[5] Project Deploy configuration
[6] Configuring the path to SSRS report sever
[7] SSRS Project Deployment
[8] Message on successful deployment
[9] Report deployed to the report manager
Next, we will take a closer look at Report manager/Report portal. We will set permissions for reports and folders containing reports.