Contents
Open a SharePoint 2013 Management Shell using “Run with elevated privilleges”. Open SharePoint 2013 Central Administration. Go to Application Management then under Service application click Manage Service Application. On that page click New then click SQL Server Reporting Service Application.
In SharePoint Central Administration, click Manage Services on Server in the System Settings group. Find SQL Server Reporting Services Service and click Start in the Action column. The status of the Reporting Services service will change from Stopped to Started.
What is SharePoint list connection type ( SSRs )?
SharePoint List Connection Type (SSRS) To include data from a Microsoft SharePoint list in your report, you must add or create a dataset that is based on a report data source of type Microsoft SharePoint List. This is a built-in data source type based on the Microsoft SQL Server Reporting Services SharePoint List data extension.
How to include SharePoint list in a report?
To include data from a Microsoft SharePoint list in your report, you must add or create a dataset that is based on a report data source of type Microsoft SharePoint List. This is a built-in data source type based on the Microsoft SQL Server Reporting Services SharePoint List data extension.
Make sure your SharePoint site is in the trusted sites list in IE, otherwise, it won’t launch client application installation when you Click on “Report Builder Report” for the first time! In the Report Builder, Click on “New Report”, choose the Table or Matrix Wizard. Click on New to create new data source for the report.
This is a built-in data source type based on the Microsoft SQL Server Reporting Services SharePoint List data extension. Use this data source type to connect to and retrieve list data from SharePoint 2013 and later.