SRS from Project Server & Sharepoint Data

[uberlinn]

All,
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

 

[James Fraser]

All,
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

This might be more appropriate for the developer group,
microsoft.public.project.developer.

You left out a key piece of information that will change the answer
dramatically: Which version of Project Server are you using?
if 2003, then no, you are not missing anything, the SharePoint data is
stored in another database, something along the lines of WSS_Content.
Writing reports against this database can be tricky, but if you are
only writing reports against one SharePoint template, you'll have an
easier time.

If 2007, then I believe much of the SharePoint information is copied
to the Reporting database, but I have not written any 2007 SharePoint
reports yet.


James Fraser

 

[Gary L. Chefetz [MVP]]

I'll assume that we're talking about 2007, because 2003 did not have a
separate reporting database and the cube contained none of this data. The
only data that gets pushed from Project Workspaces into the reporting
database and cubes is statistical data for issues, risks and deliverables,
as well as for documents and tasks linked to issues, risks and deliverables.
So you're not missing anything, other than a separate Query to pull the
Announcements information from the SharePoint content database.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[uberlinn]

Thanks James, I am using Project Server 2007, querying the
ProjectServer_Reporting Database.

All I can find is the Risks, Issues, and Deliverables for the
Sharepoint data. Where are all the other custom lists.

 

[James Fraser]

Thanks James, I am using Project Server 2007, querying the
ProjectServer_Reporting Database.

All I can find is the Risks, Issues, and Deliverables for the
Sharepoint data. Where are all the other custom lists.

Sounds like you'll have to head to the content database(s). Look
towards the "AllUserData" table, which you'll have to join to lists
and sites to narrow down to what you need.

You're now in the general SharePoint world, so look for references on
SharePoint 3.0 database schema or reporting.


Good luck...
James Fraser