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.