SRS from Project Server & Sharepoint Data

[uberlinn]

All,
Using MS Project Server 2007, I am looking to develop a report which
shows (for each project) the
associated custom enterprise fields, project level risks, issues, and
the announcements on the sharepoint site. I have no trouble with
getting to all the data but the announcements from the Reporting
Database in SQL Server.

Am I missing something in the database where the rest of the
Sharepoint data is contained?


Thanks in advance for the advice.


Andy

 

[Jonathan Sofer]

Much of the SharePoint data will not be available in the reporting database
and you will need to create a cross database query to get to it.

Jonathan