RSSCategory: SSRS

Sep

9

Use a SharePoint List as a Data Source in a SSRS Report

Posted by 5 Comments

In this example we will use a SharePoint list as a data source in a SSRS report using SQL Server 2012 Report Builder.

Begin by adding a new data source to your report. Select Microsoft SharePoint List under the connection type dropdown. For the connection string you will want to enter the root URL for your site/subsite. For example, if the URL for our list is http://technicaloverload.com/My-Test-List/, then you would enter http://technicaloverload.com/ in the connection sting box.
Continue Reading