How to deploy or publish reports from a reporting project in Visual studio(SSDT) to Report Server URL?

Problem: How to deploy or publish reports from a reporting project in Visual studio(SSDT) to Report Server URL?

Solution: Publishing Reports to a Report Server

As we created reports using SSRS Designer and they are ready to be used by the users. We need to publish/ deploy reports to a report server as the end users won’t be using designer for running reports.

To know more about what’s a report server. Please go through this article Report Server

The process of pushing the reports from a project to Report server is called as deployment. You can deploy the reports

SQL Server Data Tools (SSDT) provides project configurations for managing report publication. The configuration specifies the location of the report server, the version of SQL Server Reporting Services installed on the report server, whether the data sources published to the report server are overwritten and so forth. For example, the "Debug" configuration can publish to a different server than the "release" configuration. In addition to using the configurations that SQL Server Data Tools (SSDT) provides, you can create additional configurations.

You can either Deploy a single report from the project or deploy all the reports in the project to the report server.

Example:

In this article, I am going to show we can deploy all the reports on to the report server.

Step 0: Open SSDT and run as administrator by right clicking on the Visual Studio.

Step 1: go to the reporting project, build the solution to the debug folder and this will update the bin folder of the project with the latest changes that were made.

After building check the bin folder to see the latest timestamp.

Step 2: right click on the project to get properties of the target deployment server and url settings in the target window.

this will open a dialog to set the target url, platform.

Step 3: Now right click on the report project to deploy the report project.

Step 4: go to the report server URL to verify whether all the reports are deployed on to the server.

Results:

------ Deploy started: Project: Report Project, Configuration: Debug ------

Deploying to http://troppltmsambu/ReportServer_MSSQLSERVER2014

Deploying data source '/Data Sources/DS_Local'.

Deploying data set '/Datasets/DS_DemoReport'.

Deploying report '/Report Project/Cascading Parameters Report'.

Deploying report '/Report Project/Charts'.

Deploying report '/Report Project/Demo report 1 '.

Deploying report '/Report Project/Drill Down'.

Deploying report '/Report Project/DrillThrough'.

Deploying report '/Report Project/Groupings'.

Deploying report '/Report Project/InvoiceDetails'.

Deploying report '/Report Project/Sparklines'.

Deploy complete -- 0 errors, 0 warnings

========== Deploy: 1 succeeded, 0 failed, 0 skipped ==========