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
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 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 change as need.
- 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 as per your requirement.
- TargetReportPartFolder: Please provide the folder name where you want to deploy the Report Parts present in this SSRS 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 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 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, and 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 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 SSRS 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
