QueryEx web service consumed by SSRS

Wed, 01 Jul 2009 14:57:40 Z

I am new to web services so please forgive any naivete in my question...

I am trying to use the QueryEx method of the Sharepoint Search web service as a data source. My understanding is I can use this service to query a MOSS site with conditional arguments and return a list of links that fit the one or more cases.

I need to be able to pass several phrases that I want to search for and get back results for any of them. I went down the path of using keyword search via the sharepoint url but if all the phrases are not present nothing comes back. This does not fit my business case so here I am trying to write a custom search report in SSRS

I have used the example for creating an SSRS report using the GetListItems method of the List web service that can be found in several blogs as a starting point for using the Search web service.

My datasource is configured with the following URL

http://sharepoint/sites/MYD_30014/Wiki/_vti_bin/search.asmx

My Query in the data set is as follows

     <Query domain="QDomain">
         <SupportedFormats>
           <Format>urn:Microsoft.Search.Response.Document.Document</Format>
         </SupportedFormats>
         <Context>
           <QueryText language="en-US" type="MSSQLFT">
              SELECT Title, Path, Description, Write, Rank, Size FROM Scope () WHERE FREETEXT('Revenue')
           </QueryText>
         </Context>
     </Query>

When I run this query, I get the following message:

The 'p' start tag on line 103 does not match the end tag of 'ul'. Line 105, position 17. (System.Xml)

I also get a few columns in my dataset window. The content of these columns leads me to think that the webservice is returning the WSDL and SSRS is trying to unsuccessfully parse it. (The first column has "Microsoft Office SharePoint Server 2007 Query Web Service" in it for example)

I tried pulling out the QueryText element and using it as a parameter but SSRS would not even submit that providing this error:

Failed to execute web request for the specified URL.

Is what I am trying to do even possible?

What do I need to do to actually call the method and return the flattened xml recordset?

Any help is appreciated.

QueryEx web service consumed by SSRS

Wed, 01 Jul 2009 15:24:07 Z

SSRS questions go to Business Intelligence.

Moving this there.

WSS FAQ sites: http://wssv2faq.mindsharp.com and http://wssv3faq.mindsharp.com
Total list of WSS 3.0 / MOSS 2007 Books (including foreign language) http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/V%20Books.aspx