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.
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 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.
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
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.
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 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
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.
You can see the SSRS output window to check for deployed reports
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.
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 deployed SSRS Reports present in the project