In this article, we will show you, 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.
Below screenshot shows you 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
Once you click on the Properties option, a new window called SSRS Projects Property Page will be opened to configure the settings. Following are the some of the properties in 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 as per your requirement.
- TargetDataSourceFolder: Please specify the folder name where you want to deploy the Shared Data Sources present in this project. By Default, Data Sources is the name but you can change as per your requirement.
- TargetReportFolder: Please specify the folder name where you want to deploy the SSRS Reports we created in this project. By Default, Project name will be assigned to this but you can change as per your requirement.
- TargetReportPartFolder: Please specify the folder name where you want to deploy the Report Parts present in this project (If any). By Default, Report parts is the name but you can change as per your requirement.
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, Report Server will overwrite the Destination dataset with current project Dataset
- And, If you set this option to FALSE (Default value), Report Server will keep the Destination Dataset
OverwriteDatasources: This property hold 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.
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.
TargetServerURL: This property is used to provide the Target URL where we want to deploy the project. For instance, If you want 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
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 below screenshot
TIP: Please Run the BIDS as Administrator, If you don’t have the privileges.
You can see the output window to check for deployed reports
Next, Open the Report Manager in Internet Explorer to check the project.
TIP: Please Run the Browser as Administrator, If you don’t have the privileges.
Double click on the Data Source folder to check the shared data sources in the project
Double click on the Dataset folder to check the shared datasets in the project
Next, Double click on the SSRS Projects folder to check the SSRS Reports present in the project
Thank You for Visiting Our Blog
