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
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!!!