Skip to main content

Posts

Showing posts with the label SSRS in SharePoint 2010

Use Lists Web Server to get data in the SSRS 2008 R2 Reports

Step 1: Ensure that you have a SharePoint List. In this demo, we will report against SharePoint Products List. Step 2: Understand the SharePoint List Web Service Interface. SharePoint has a lists.asmx web service which provides interface to download the SharePoint lists data in the non-SharePoint systems. You can access the SharePoint list web service using the http://siteurl/_vti_bin/lists.asmx. You can use the GetListItems method which returns dataset to download all the list items for the specific list. Step 3: Create new Shared Data Source and Report Server Project Create a new Report Server Project in the Business Intelligence Development Studio (BIDS). First step of configuring the SSRS report is creating the new shared data source. Select the SharePoint List as a data source type and specify the SharePoint Site URL hosting the lists for the connection string. On the credentials tab, specify either windows authentication or no authentication if anonymous authentication is en…