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 below screenshot.
Before we start deploying the reports, we need at least one folder to hold the Data Source,Datasets and Reports. In this example, we will create three separate folders to hold them.
To create new folder, Please click on the New Folder button as shown in below screenshot
Once you click on the New Folder button, below screenshot will be displayed. Please specify the Folder Name and valid description in the corresponding text boxes.
First, We are creating new folder to hold the Shared Data Sources so, we assigned Name as Data Sources
Next, We are creating another new folder to hold the Shared Datasets so, we assigned Name as DataSets
Similarly, We created another new folder to hold the SSRS Reports and assigned the Name as SSRS PROJECTS
Once we created three folders, Please refer 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
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.
Here, we are selecting CustomerSales.rsd as the dataset
Click Ok button to finish uploading the file
From the below screenshot, you can observe the newly uploaded Dataset in the Datsets folder
Similarly we are uploading Bar Chart.rdl file (SSRS Reports) under the SSRS Projects folder.
From the below screenshot, you can observe the newly uploaded SSRS Report in the SSRS Projects folder.
When you are using the Shared Data Source present in the Report Manager, we have to modify the Data Sources of a Reports and datasets. To do so, Click on the Report will open the context menu and select the Manage option from it.
Once you select the Manage option, following screenshot will be appeared. 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
Once you click on the Browse button, following screenshot will be displayed with the available folders. Please select the required data Source from the folder. In this example, we are selecting AdventureWorksDW
After selecting the required shared data source, Click Ok button
Dont forget to click on Apply button
We successfully deployed the required reports using Report Manger and we also pointed the shared Data Sources to reports.
Now, Double click on the report to see the preview
Thank You for Visiting Our Blog
