Step By Step Guide To Create SSRS Reports App In SharePoint

Reading this tutorial, you will learn how to create an SSRS Reports App In SharePoint.

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

    Step By Step Guide To Create SSRS Reports App In SharePoint

User Report access view

 
Step By Step Guide To Create SSRS Reports App In SharePoint 

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.

Step By Step Guide To Create SSRS Reports App In SharePoint 

Note
A user should have the necessary permissions to perform this action. I prefer Site Collection Admin Rights.

Click "Add an app".

Step By Step Guide To Create SSRS Reports App In SharePoint 

Search for Report Library and click on the relevant option from the results.

Step By Step Guide To Create SSRS Reports App In SharePoint 

Enter the name for this app and click "Create".

Step By Step Guide To Create SSRS Reports App In SharePoint 

Once the app is created, it will be available on the Site Content page.

Step By Step Guide To Create SSRS Reports App In SharePoint 

Go to App Settings by clicking three dots ( … ) at the right-top corner of your app.

Step By Step Guide To Create SSRS Reports App In SharePoint 

 Click "Add from existing site content types" on the App Settings page.

Step By Step Guide To Create SSRS Reports App In SharePoint 

Select the SQL Server Reporting Service content type from the Content-type combo box.

Step By Step Guide To Create SSRS Reports App In SharePoint
Add the Report content type using the "Add" button and click OK.
 
Step By Step Guide To Create SSRS Reports App In SharePoint
Next, it will show the list of content types added to that app.
 
Step By Step Guide To Create SSRS Reports App In SharePoint 

Go to the newly created Report App and note the app path for future use.

https://my.sharepoint/teams/<ProjectName>/SSRS_Report_Folder/

Step By Step Guide To Create SSRS Reports App In SharePoint 

It is always suggested to separate the subfolders for each report part, like below.

Step By Step Guide To Create SSRS Reports App In SharePoint
Thank you!