Step By Step Guide To Deploy Bulk SSRS Reports In SharePoint From BIDS Or 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

There are two ways to deploy the report in SharePoint

Deployment from BIDS
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.

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

SSRS_Report_Folder in SharePoint (Before Deployment)

Select solution -> right click ->build.

Select solution -> right click -> Deploy.

SSRS_Report_Folder in SharePoint (After Deployment)

Thank You!!!