Create SSRS Report from SharePoint 2013 List using Report Builder 3.0

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.
  1. Go to Library Setting >> Advance Settings >> Select Yes for “Allow management of content types” and click on Yes.
  2. This Navigates to library settings again. Scroll down and Click on “Add from existing site content types” under “Content Types”
  3. Add “Report Builder Report” content type, and click on “OK”.
Create SSRS Report from SharePoint 2013 List using Report Builder 3.0
Create Report using Report Builder Tool
Go to Files Tab >> Click on drop down on "New Document" Ribbon button >> Choose "Report Builder Report"
sharepoint reporting services
This launches “Report Builder Client 3.0” installation for the first time. Wait for the ClickOnce installation to complete. 
sharepoint reporting services configuration
Make sure your SharePoint site is in 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.
sharepoint reporting services tutorial
Choose "Create a Dataset" option and click on "Next" button
sharepoint reporting services integration
Click on New to create new data source for the report.
sharepoint list reporting services data source
Give a Name to Data source and choose connection type as "Microsoft SharePoint List" and enter the connection string as the URL of your SharePoint site. Click on Credentials Tab
sharepoint reporting services list
Specify the relevant credential settings.
Verify the connection properties by click on "Test Connection" button
Choose the SharePoint lists you want to present as a Report.
Pick the Fields to display.
sharepoint reporting services examples
Set Grouping, Sub-total, Grand Total options
Select the style for your report
 sharepoint 2010 reporting services list
 And finally, we will save our report in the document library we have created in the early step.
That's all. Add Reporting Services Web part to desired locations and point to the report we've created. Here is the SharePoint reporting services from list:
sharepoint reporting services list
Now these reports can be export to Excel, PDF, Word, etc. BTW, Its also possible to build the same report using Visual Studio. Refer: 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

1 comment:

  1. Hi Salaudeen,

    Do you have any powershell script to get SSRS inventory report with last modified date (Find SSRS used sites/library). Could you please help me on this.

    SP Version : SharePoint 2010



Please Login and comment to get your questions answered!

Powered by Blogger.