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

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:

<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/"

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.



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.