SQL tables / fields for a report

[Suzanne]

Hi,

I'm looking at the back-end SQL tables on SQL 2000 for Project server
2003; I have crystal reporting running against it however I'm not sure
which tables are which.

I'm looking to produce a report showing which resource has booked time
to each task. The fields I am looking for at a guess are Resource,
Task Name, Enterprise Text field 7, the amount of time each person has
booked and dates.

Cheers
Suzanne

 

[James Fraser]

I'm looking to produce a report showing which resource has booked time
to each task. The fields I am looking for at a guess are Resource,
Task Name, Enterprise Text field 7, the amount of time each person has
booked and dates.

Look on the machine that you have Project Server 2003 installed. In C:
\Program Files\Microsoft Office Project Server 2003\HELP\1033 there
are files that document the database structure.

Web tables are generally related to PWA functions and published
projects and are documented in the PJSVRDB.HTM file. Others are
described in PJDB.HTM.

In the web documenatation there is an example of "Find all timephased
data for a particular resource." By the way, there is an bug in this
example script that reduces its performance: The line
and (@begin_date <= WWORK_FINISH or @end_date >= WWORK_START)
doesn't filter out anything. It should be
and (@begin_date <= WWORK_FINISH and @end_date >= WWORK_START)

More questions on this should probably go to the developer group,
microsoft.public.project.developer.


James Fraser

 

[Suzanne]

Look on the machine that you have Project Server 2003 installed. In C:

\Program Files\Microsoft Office Project Server 2003\HELP\1033 there
are files that document the database structure.

Web tables are generally related to PWA functions and published
projects and are documented in the PJSVRDB.HTM file. Others are
described in PJDB.HTM.

In the web documenatation there is an example of "Find all timephased
data for a particular resource." By the way, there is an bug in this
example script that reduces its performance: The line
and (@begin_date <= WWORK_FINISH or @end_date >= WWORK_START)
doesn't filter out anything. It should be
and (@begin_date <= WWORK_FINISH and @end_date >= WWORK_START)

More questions on this should probably go to the developer group,
microsoft.public.project.developer.

James Fraser

Thank you for the response. Unfortunatly don't have access to the
Project Server Machine as it's in a different Office location.

 

[James Fraser]

Thank you for the response. Unfortunatly don't have access to the
Project Server Machine as it's in a different Office location.

The files are also on the Project Server installation CD, in the /
Docs/ directory.


James Fraser