Step By Step Guide To Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT

This tutorial will provide the steps to deploy/publish SSRS reports in SharePoint Site from BIDS/SSDT.

Report deployment in SharePoint

 
Here is a sample SSRS report with the below items.
  • Data source - Pointing to SharePoint List Named as SharePoint_Source.rds
  • Share Dataset - Fetching data from SharePoint List named as Sample_Shared_Dataset
  • Report - Sample_SSRS_Report.rdl

Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT

Sample Report Preview

Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT 

There are two ways to deploy the report in SharePoint

  1. Deployment from BIDS
  2. Manual Deployment to SharePoint

Deployment from BIDS

 
This deployment method is used for bulk deployment (say n number of reports at the same time).

Select solution -> Right click -> Properties.

Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT 

Configure the below properties in the Deployment tab.

OverwriteDatasets

TRUE will overwrite the dataset if it is already present. FALSE will not overwrite (it is recommended to use TRUE because if we do some changes that will get directly updated in the SharePoint).

OverwriteDatasource

TRUE will overwrite the Data Source if it is already present. FALSE will not overwrite (it is recommended to use FALSE because usually, developers make the changes to the report pointing to UAT/Dev site. If the property is set to TRUE, it will replace the already existing source and create confusion).

TargetDatasetFolder

Set the path where Shared datasets are going to be deployed.

https://<<Sharepoint site>>/<<APP Folder Name>>/<<Folder name for dataset >>

For Example - https://my.sharepoint /teams/Sample/SSRS_Report_Folder/Shared_Datasets

TargetDataSourceFolder

Set the path where Data Source is going to be deployed.

https://<<Sharepoint site>>/<<APP Folder Name>>/<<Folder name for Data source>>

For Example - https://my.sharepoint/teams/Sample/SSRS_Report_Folder/DataSource

TargetReportFolder

Set the path where Reports are going to be deployed.

https://<<Sharepoint site>>/<<APP Folder Name>>/<<Folder name for Reports>>

For Example - https://my.sharepoint/teams/Sample/SSRS_Report_Folder/Reports

TargetReportPartFolder

Leave this as blank

TargetServerURL

Set SharePoint site

https://<<Sharepoint site>>

For Example - https://my.sharepoint/teams/Sample

TargetServerVersion

Set SQL Server version
 
Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT 

SSRS_Report_Folder in SharePoint (Before Deployment)

Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT 

Select solution -> right click ->build.

Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT 

Select solution -> right click -> Deploy.

Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT
 
Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT 

SSRS_Report_Folder in SharePoint (After Deployment)

Deploy Bulk SSRS Reports In SharePoint From BIDS Or SSDT 

Thank You!!!