Reporting Service integrated with SharePoint provides a rich reporting platform. Lets see how we can create SQL Server reporting services report from SharePoint list data:
Create a Library for Reports and add Report Content Type
To start with, Lets create a Document Library, Add Report Builder Report content type to create a new report.
- Go to Library Setting >> Advance Settings >> Select Yes for “Allow management of content types” and click on Yes.
- This Navigates to library settings again. Scroll down and Click on “Add from existing site content types” under “Content Types”
- Add “Report Builder Report” content type, and click on “OK”.
Go to Files Tab >> Click on drop down on "New Document" Ribbon button >> Choose "Report Builder Report"
How to Create and Deploy SSRS 2012 Reports to SharePoint 2013
Here is an another related article: SQL Server 2012 Reporting Services and SharePoint 2013 integration configuration
You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.