Need Table Information

[Ashish kanoongo]

Hello

I am using project server 2007 with MOSS 2007. I like to create a sql
query/report in following format for selected date

Employee1 Employee2
Employee3 .........
Week 1 - July 2 - 6
Project1
Project2
Project 3 # of Hours Worked

Week 1 - July 2 - 6
Project1
Project2
Project 3

Can any one let me know from which tables I can get this information?

Ashish

 

[Ashish kanoongo]

I also want to indiacte that which project which project billable and which
are not non-billable?

 

[Rod Gill]

Read the reporting database schema in Project's SDK (download free from
msdn.microsoft.com). Best to use Views ending with _userview as these
automatically have all relevant custom fields appended as well.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx