Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

WSS lookup field in RS 2005

  Asked By: Nichole    Date: Aug 14    Category: Sharepoint    Views: 811

I'm trying to return the Assigned To: field from a WSS tasks list in SQL
Reporting Services 2005, but I can't seem to get this field. The query I'm
using returns all of the other fields except (of course) the Assigned To: field.
I know it has something to do with it being a lookup field. the query is below:

<Query>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/"
Name="GetListItems"/>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapActio\
n>
</Query>

I know <ElementPath> can be used to specify how to extract the data from the xml
response, but I haven't been able to accomplish this.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Kalyan Pujari     Answered On: Aug 14

I am somewhat embarrassed to say that I figured out the problem. The Assigned
To: field  wasn't in the default view. The default view was grouped by Assigned
To:, but the field wasn't actually included. yeah, i know, you would think that
would've been the first thing i checked...

 
Didn't find what you were looking for? Find more on WSS lookup field in RS 2005 Or get search suggestion and latest updates.




Tagged: