Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Implement a new XML web service, in the web service, use the SharePoint API to merge or join two or more list. Then, in SSRS, retrieve data from the XML web service using XML data source type.

Well I think I'm totally lost with the XML-thing..

Basically I want to join multiple SP lists to use em as a data source in Report Builder 3.0. I'm using SharePoint 2010.

I know how to build the join query in LINQ/CAML. I've done it before using the SharePoint object-model API. So it wouldn't be a problem to do the same using the web services API.

But what about creating a new XML web service? Could someone guide me through this? Any good tutorials/examples from the very basics would be greatly appreciated.

share|improve this question
    
Could you elaborate on what it is you are attempting to do? Also, what version of SharePoint are you using? –  Dave Wise Apr 8 '13 at 15:10
    
Let me apologize, I rephrased. –  LePhleg Apr 9 '13 at 7:26

1 Answer 1

up vote 0 down vote accepted

This article is a good start on creating Web Services that interact with the SharePoint object model. This provides the framework but you would obviously have to put in your code that does the union and returns the results as XML

share|improve this answer
    
Wow.. This really makes it look like an easy process.. I'll give it a try right away. Thanks Dave! –  LePhleg Apr 10 '13 at 14:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.