Report deployment in SharePoint
Here is a sample SSRS report with 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
Manual Deployment to SharePoint
This deployment is used when a developer is deploying a single report or dataset to the SharePoint.
For example, consider an SSRS project solution with 20 reports which Is already deployed in SharePoint. Now, a developer has done some changes in one report to update those changes in SharePoint. They can use this method to upload that single report to SharePoint.
We have a report named as Sample_2.rld with one shared dataset.
As a first step navigate to the report folder in SSRS_Report_Folder APP in SharePoint -> click New Document
Browse and select the sample_2.rdl from the file system and click OK.
Click "Save" to deploy the report.
If a user deploys the report in SharePoint manually, then the user must map the data source and Shared data for that report manually.
Click "Manage Data Sources".
Click "SharePoint_source".
Map the data source in the report with a shared data source which is already deployed in SharePoint.
If that report is pointing to any shared dataset, this means the user must map that dataset too.
Go to Manage Shared Datasets".
Shared dataset shows warning because no dataset is mapped to that. So, the users have to map a dataset to that.
Click "Sample_Shared_dataset".
Finally, our report is deployed successfully.