SQL tables / fields for a report

Suzanne

unread,

Sep 19, 2007, 9:24:38 AM9/19/07

to

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

unread,

Sep 19, 2007, 10:29:36 AM9/19/07

to

On Sep 19, 8:24 am, Suzanne <ssl...@cmpi.biz> wrote:
>
> 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

unread,

Sep 19, 2007, 10:50:37 AM9/19/07

to

> 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

unread,

Sep 19, 2007, 5:43:48 PM9/19/07

to

On Sep 19, 9:50 am, Suzanne <ssl...@cmpi.biz> wrote:
> > 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.
>

> 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