Show Information from several SharePoint in a single Report

Hi,

You can do some custom query to SharePoint Content Database, on this way you can merge all information, only you have to find the correctly field used by your lists.

All information from these lists, you can find it over these tables, "Lists, Webs, Userdata", you have to make some relationship between tables.

Query example

SELECT       C.tp_ID AS ItemID, C.nvarchar6 AS Title, C.ntext2 AS Description, C.tp_Created AS Date, B.Title COLLATE Modern_Spanish_CI_AS AS Project
FROM            Lists AS A INNER JOIN
                         Webs AS B ON A.tp_WebId = B.Id INNER JOIN
                         UserData AS C ON A.tp_ID = C.tp_ListId
WHERE        (A.tp_Title = 'PotentialRisks')

Hope this help!

---

Raymundo Chapa, MCTS http://ift.tt/1qzt2Qw http://ift.tt/1v5dFFZ