Tuesday, January 17, 2012

How to Deploy a report in SSRS(SQL Server Reporting Services)

In my last post i discussed how to group a report in SSRS. Today I am going to explain how deploy the reports in SSRS. We can do it using SQL Server Management Studio environment and also using the Report Manager. First let's do it using SQL Server Management Studio development environment.

Open your report server project in SQL Server Management Studio. I assume that you can create a report under a report server project and if you are not aware of it refer to my previous posts. In your project right click on solution and click on the properties.



Then you can see a popup window comes out.



You have to change TargetReportFolder and TargetServerURL as in the window. If you wish to deploy reports to another server you can give its name. Sometimes it would ask for more permission. You can give any name for TargetReportFolder. Then click ok.

Now you can deploy reports by right clicking on solution and clicking Deploy.



Open the browser and type this URL (http://localhost/reports) 
This is the  URL  of Report Manager. You can see their your MyReports folder. It was successfully deployed.



Click on that folder and you can see their your report.



This is a simple way of deploying a report in SSRS. We can do this job using only Report Manager.
I will discuss it in my next post. Thank you.