I'm not sure this is possible, but... I was asked to write a SQL Reporting Services Report that reports on a SQL table that is joined to a Sharepoint Table. In trying to look up how to do this, I'm not finding any how-to posts. Is this possible and if so, could you point me in the direction of a step-by-step how -to white paper?
Thanks,
Jennifer
WSS exposes its feature set as a web service. I think the one that returns the data in a list is called Lists.asmx. From there, you can use the XML data provider in SSRS 2005 to connect to the service and consume the data in XML. This post should help you to get started with the SSRS XML data provider. If you need to create a report that joins data from two lists on the report, you could try a third-party provider such as Enesys or build your own custom data extension.
As a side note, a native provider that reports from WSS is on top of the wish list for a next release as discussed in Brian Welcker's blog.
sql
No comments:
Post a Comment