Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Two many items coming from Sharepoint List

  Asked By: Jesse    Date: Aug 11    Category: Sharepoint    Views: 1085

I have just setup a report to access a Sharepoint List using the report server project. I have managed to access the SP List but it contains lots of unwanted data and does not even contain the items I have uploaded to the list.

In the SP list I have a couple of work documents uploaded with 3 columns and even this does not show in the dataset.

Will it show custom colunms in the dataset?



1 Answer Found

Answer #1    Answered By: Akshay Gupta     Answered On: Aug 11

I have created a Report Server Project in SQL Server Business Intelligence Development Studio.

My data  Source is connected to a sharepoint  List and with the query below I can now access  the columns  I need.

<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameter Name="listName">
<Parameter Name="viewName">
<ElementPath IgnoreNamespaces="true">GetListItemsResponse/GetListItemsResult/listitems/data/row

Didn't find what you were looking for? Find more on Two many items coming from Sharepoint List Or get search suggestion and latest updates.