RSSCategory: SSRS



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, then you would enter in the connection sting box.
Continue Reading