Deploy Reports using SSRS Report Manager

In this article, we will show you how to Deploy Reports using SSRS Report Manager. To do this First, Open your Report Manager and check whether it has any existing items or not. If you are opening for the first time, there will be no item, as shown in the below screenshot.

Deploy Reports using SSRS Report Manager

Before we start deploying the SSRS reports using report manager, we need at least one folder to hold the Shared Data SourceDatasets, and SSRS Reports. In this example, we will create three separate folders to keep them.

Deploy Reports using SSRS Report Manager 1

To create a new folder, please click on the New Folder button as shown in below screenshot

Deploy Reports using SSRS Report Manager 2

Once you click on the New Folder button, the below screenshot will be displayed. Please specify the Folder Name and valid description in the corresponding text boxes.

Deploy Reports using SSRS Report Manager 3

First, We are creating a new folder to hold the Shared Data Sources. So, we assigned Name as Data Sources

Deploy Reports using SSRS Report Manager 4

Next, we are creating another new folder to hold the Shared Datasets so, we assigned Name as DataSets

Deploy Reports using SSRS Report Manager 5

Similarly, We created another new folder to keep the SSRS Reports and assigned the Name as SSRS PROJECTS

Deploy Reports using SSRS Report Manager 6

Once we created three folders, Please refer to Create Shared Data Source in SSRS Report Manager article to understand the creation of shared data sources.

Next, Navigate to Datasets folder and then click on the Upload File button to upload files from the file system

Deploy Reports using SSRS Report Manager 7

Once you click on the Upload File button following screenshot will be displayed to upload files. Click on the browse button to select the files.

Deploy Reports using SSRS Report Manager 8

Here, we are selecting CustomerSales.rsd as the dataset

Deploy Reports using SSRS Report Manager 9

Click Ok button to finish uploading the file

Deploy Reports using SSRS Report Manager 10

From the below screenshot, you can observe the newly uploaded Dataset in the Datasets folder

Deploying Reports using SSRS Report Manager

Similarly, we are uploading Bar Chart.rdl file (SSRS Reports) under the SSRS Projects folder.

Deploying Reports using SSRS Report Manager

From the below screenshot, you can observe the newly deployed or uploaded SSRS Report in the SSRS Projects folder.

Deploying Reports using SSRS Report Manager

When you are using the Shared Data Source present in the Report Manager, we have to modify the Data Sources of Reports and datasets. To do so, click on the Report will open the context menu and select the Manage option from it.

Deploying Reports using SSRS Report Manager

Once you select the Manage option, the following screenshot will appear. If you observe the below screenshot, It is already showing the error about the shared data source. To configure, please click on the Browse button

Deploying Reports using SSRS Report Manager

Once you click on the Browse button, the following screenshot shows the available folders. Please select the required data Source from the folder. In this example, we are selecting AdventureWorksDW

Deploying Reports using SSRS Report Manager

After choosing the required shared data source, Click Ok button

Deploying Reports using SSRS Report Manager

Don’t forget to click on Apply button

Deploying Reports using SSRS Report Manager

We successfully deployed the required reports using SSRS Report Manager, and we also pointed out the shared Data Sources to reports.

Now, Double click on the report to see the preview

Deploy Reports using SSRS Report Manager 20