Logo 
Search:

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: 1102

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?

Share: 

 

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.

<Query>
<SoapAction>schemas.microsoft.com/.../SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>{4C98DDEC-D0B2-4528-AA54-2C7074E38A40}</DefaultValue>
</Parameter>
<Parameter Name="viewName">
<DefaultValue>{B4CEA9AB-A81B-4333-B397-76C62890E568}</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="true">GetListItemsResponse/GetListItemsResult/listitems/data/row
{@ows_Title,@ows_Modified,@ows_PercentComplete,@ows_Status_x0020_No}</ElementPath>
</Query>

 
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.




Tagged: