In our earlier articles, we have seen how to design a report and connect to the database to pull out the values based on the requirement to be shown in the report. Also, we have seen the configuration section on how to configure the SQL Server Reporting Services manually by providing the Report Server name. In this article, we will cover how to deploy the application to the SQL Report Sever and access it online using the web browser.
To start deploying a report to the server first we need to design and develop a report based on the requirement. Since we have already prepared some samples from the earlier articles, we will be using the Part 2 sample and start deploying to the server gradually.
Once we have opened our project, we can see the design in the IDE as shown in the screen below.
Now we are ready with the design. Since we need to publish the report to the server, click on the ‘solution explorer project name’ and right click to select the Deploy option as shown in the screen below.
Once we click on the Deploy button, the Visual Studio starts deploying the application report to the server and we can see the status from the output window as shown in the screen below.
Once the report is deployed to the server we can see the output message indicating that the deploy is completed and we can access the report as shown in the screen below.
Once we are done with the deploy, in order to access the report just copy the path from the output window of the Visual Studio IDE. This path will be the server path to access the list of reports as shown in the screen below.
Copy and paste the URL on to the browser and navigate through the URL. This will allow us to see the list of projects deployed as shown in the screen below.
In this article, we have deployed the Part2sample application so click on the Part2Sample project. It will navigate to the next page where we can see the report name listed (Report1) as shown in the screen below. Similarly, for all the other projects we can see the report listed in the respective folder.
Clicking on the report name (Report1) we can see the report being generated in the web browser with the complete formatting along with the data as shown in the screen below.
Therefore, in this article we have seen the options to deploy the report on to the reporting server to access it online across the client.