SSRS Sharepoint mode introduction
In SharePoint mode, a Report Server runs within a SharePoint Server Farm. The Report Server processing, rendering, and management features are represented by a SharePoint Application Server running the Reporting Services.
- SharePoint site provides the front-end access to the Report Server content and operations.
- Reports, data sources, and other items are stored in the SharePoint content databases
- SharePoint site Permission levels determine access to the report's content and operations
User Report access view
Report App creation in SharePoint
To deploy the SSRS report in SharePoint, users must create one app on the SharePoint site to hold the report items (Data source, Datasets, Report rdl files).
To create it, go to the SharePoint site. Then go to Site contents by clicking on the Settings symbol.
Note
A user should have the necessary permissions to perform this action. I prefer Site Collection Admin Rights.
Click "Add an app".
Search for Report Library and click on the relevant option from the results.
Enter the name for this app and click "Create".
Once the app is created, it will be available on the Site Content page.
Go to App Settings by clicking three dots ( … ) at the right-top corner of your app.
Click "Add from existing site content types" on the App Settings page.
Select the SQL Server Reporting Service content type from the Content-type combo box.
Add the Report content type using the "Add" button and click OK.
Next, it will show the list of content types added to that app.
Go to the newly created Report App and note the app path for future use.
https://my.sharepoint/teams/<ProjectName>/SSRS_Report_Folder/
It is always suggested to separate the subfolders for each report part, like below.
Thank you!