SharePoint By Gaurav Goyal

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

I wanted to create a report in which I have created a Parameter called "User Name" , Which shows all users from SharePoint list. Now I marked this parameter as Multi value selector. But I am not able to use values of this parameter in SSRS report because this report uses CAML Query not SQL query. When I select 1 or more users and click on 'View Report' button. It gives me an error : Cannot add multi value query parameter 'Users' for dataset 'TSADataSet' because it is not supported by the data extension. (rsErrorAddingMultiValueQueryParameter) So I used this parameter in filter option of Data Set. Now it is working fine. I just followed these steps : Create multi-value parameter as you want. Right click to “ your dataset ” then click on “ Dataset Properties ”. In Dataset property form, Click on “Filters” and add expression (Field) then select Operator (Select “In” operator in case of multivalue parameter) then select value (Click on form...