Reports on MS Projects Lists

J

Jik

Hi,

I am using Projectserver/SharePoint service implemenation for an EPM
solution. In my project I have some shared spread sheets that is have linked
List in Project workspace. User can update either spread sheet (on shared or
local copy) or the List.
Synchronize in excel or Refresh in List does the data synchornization. Then
I need to generate reports on the values added. My idea was to take values
from SQL tables where List saves the values. I have found the SharePoint
server creates another database "STS_..." to keep custom data. I found that
list values are in "UserData" table. But I found it difficult to find the
relationship between tables, say, Web Project Name - List Name - List
Values. As there are many tables involved, it would be helpful if I could get
relationship between tables so that I can generate reports on List for a
project. IS there anyother easy way for report genetaion on list in MS
Project ? Please help

Thanks

Jik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub projects added as read only in Master file which are saved on sharepoint 1
how do you tie Project Workspace Lists to Projects or ProjectUID? 0
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
List reports from ReportingServices in a SharPoint list in Access 0
Project Server 2007 and SSRS 2005 integration: issue withauthentication when running to the reports 3
MS Project Integration - How to set ActualStart/Finish/Work? 3
emp CP tables in report builder 6
Exporting a Project Task created in Sharepoint to MS Project 5

Top