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 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.

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.

5 set credentials for datasource

Verify the connection properties by click on “Test Connection” button

6 test connection

Choose the SharePoint lists you want to present as a Report.

7 select list

Pick the Fields to display.

sharepoint reporting services examples

Set Grouping, Sub-total, Grand Total options

9 ssrs 2012 report builder 3 choose subtotals

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.

13 save report

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

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

One thought on “Create SSRS Report from SharePoint 2013 List using Report Builder 3.0

  • December 19, 2018 at 9:34 AM

    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

    Thanks,

    Reply

Leave a Reply