Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tash4206
Starting Member
7 Posts |
 Posted - 2008-04-03 : 22:35:34
|
| I am trying to filter the ListItems based on the ViewFields property.Is there a way of filtering this list data -- WHERE 'ows_ID' = 1. Only one row returning instead of many to my report dataset. What do I need to add to the <Query> below to accomplish this. Thanks!Here is what I have in my dataset: SSRS 2005 designer------------------------------------------<Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems"> <Parameters> <Parameter Name="listName"> <DefaultValue>{CB842B06-CB1E-4501-89CC-0640E394F629}</DefaultValue> </Parameter> </Parameters> </Method> <ElementPath IgnoreNamespaces="True">*</ElementPath></Query> |
|
|
|
|
|
Filter SharePoint List