Deploying Reports in SSRS

In this article, we will show you the steps involved in deploying reports in SSRS using BIDS. Or, how to Deploy SSRS Projects in SQL Server Reporting Services Data Tools to Report Manager with an example.

The below screenshot shows the Shared Datasets, Shared Data Sources, and SSRS Report present in this project.

Deploying Reports in SSRS

Before we start deploying reports in SSRS Project, we have to configure the Reporting Server properties. So, Right-click on the project name (here, SSRS Projects) and select Properties as shown below.

Select Project Properties 2

Once you click on the Properties option, a new window called SSRS Projects Property Page will open to configure the settings. The following are some of the properties in the SSRS Report Deployment section:

  • TargetDatasetFolder: Please specify the folder name where you want to deploy the Shared Datasets present in this project. By Default, Datasets is the name, but you can change it as per your requirement.
  • TargetDataSourceFolder: Please specify the folder name where you want to deploy the Shared Data Sourcespresent in this project. By Default, Data Sources is the name, but changes as needed.
  • TargetReportFolder: Please specify the folder name where you want to deploy the SSRS Reports we created in this project. By default, the Project name will assign to this. You can alter it as per your requirement.
  • TargetReportPartFolder: Please provide the folder name where you want to deploy the Report Parts present in this project (If any). By default, Report parts are the name.
Project Properties Window 3

OverwriteDatasets: This property holds two options, TRUE and FALSE. If the current project and Reporting Server has the same Shared Dataset name, then:

  • If you set this option to TRUE, the Report Server will overwrite the Destination dataset with the current project Dataset
  • And, If you set this option to FALSE, Report Server will keep the Destination Dataset. This is the default value
Set Override the Destination to True or False 4

OverwriteDatasources: This property holds two options, TRUE and FALSE. If the current project and Reporting Server has the same Shared Data Source name, then:

  • If you set this option to TRUE, Report Server will overwrite the Destination data source with the current project data source
  • And, If you set this option to FALSE (Default value), the Report Server will keep the Destination data source.
Set Override data source to true or False 5

TargetServerVersion: Please specify the Version of the Report Server you are using. This property has three options: SQL Server 2008, SQL Server 2008 R2 or later, and Detect Version. We are using SQL Server 2014, so we selected the SQL Server 2008 R2 or later option.

Choose Target Server Version 6

TargetServerURL: This property is used to provide the Target URL where we want to deploy the SSRS project. For instance, If you’re going to deploy to a report server installed in share point, then provide the site URL.

In this example, we are deploying to the default web server of a report server native mode so, we are placing the URL of that web server

Target Report Server URL 7

Click on the Apply button to finish modifying the project properties. Next, go to solution explorer and right-click on the project name to open the context menu. From the context menu, please select the Deploy option, as shown in the below screenshot.

TIP: Please Run the BIDS as Administrator, If you don’t have the privileges.

Deploying SSRS Reports 8

You can see the SSRS output window to check for deployed reports

Output 9

Next, open the Report Manager in Internet Explorer to view the deployed project.

TIP: Please Run the Browser as Administrator, If you don’t have the privileges.

Open the Report Manager 10

Double click on the Data Source folder to check the shared data sources in the project

Deploying Reports in SSRS 11

Double click on the Dataset folder to check the shared datasets in the project

Deploying Reports in SSRS 12

Next, Double click on the SSRS Projects folder to check the deployed SSRS Reports present in the project

Deploying Reports in SSRS 13

Comments are closed.