Reports can be deployed either individually, or as part of complete project deployment. In this tutorial, you will deploy the complete project to your local development machine.
Before deploying a project, you will need to set the target for deployment. On your local machine, as long as everything was set up using the default settings, the target will be HTTP://LOCALHOST/REPORTSERVER
Users will view and run reports from a similar URL: HTTP://LOCALHOST/REPORTS. It is worth checking that Reporting Services is running by visiting these two URLs in Internet Explorer now, to avoid problems later.
If you would like to become SSRS (SQL Server Reporting Services) certified professional, then visit Mindmajix - A Global online training platform: "SSRS Online Training and Certification". This course will help you to achieve excellence in this domain.
There is also sometimes a security issue that you might encounter. To avoid this, run Internet Explorer as an Administrator by right-clicking on the icon and selecting ‘Run as Administrator’.
If neither of the URLs works, you should open Reporting Services Configuration Manager and check that Reporting Services is running (this catches people out more than you might think!) and also check the URLs that were set up under Web Service URL and Report Manager URL.
All being well, the steps in this section should deploy your project to your local report server. Unfortunately, if you are deploying to a non-default location, you might encounter some issues. If this is the case, ask the person who manages the Report server for any specific settings you might need to supply.
(Related Page: How To Publish Report To A Report Server In SSRS)
Try it
1. In Solution Explorer, right-click on the project and select Properties.
2. In the window that opens, find the TargetServerURL property and set it to the Report Manager URL. The default is:
HTTP://LOCALHOST/REPORTSERVER
3. Click OK.
4. Right-click on the project name again and choose Deploy.
5. Open the Web Service URL HTTP://LOCALHOST/REPORTS to view your reports.
Frequently Asked SSRS Interview Questions & Answers
SSIS | Power BI |
SSAS | SQL Server |
SCCM | SQL Server DBA |
SharePoint | BizTalk Server |
Team Foundation Server | BizTalk Server Administrator |
Name | Dates | |
---|---|---|
SSRS Training | Sep 14 to Sep 29 | View Details |
SSRS Training | Sep 17 to Oct 02 | View Details |
SSRS Training | Sep 21 to Oct 06 | View Details |
SSRS Training | Sep 24 to Oct 09 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.