Custom Reporting in Project 2002

B

Brian Gibson

Is it best practice to report directly from the SQL tables? We are having
trouble producing a report within Project using View | Reports.We are trying
to develop a report that looks at a specific week (current week?) and
categorizes the hours work on a task based on Enterprise fields values
(Expense/Capital Expense) for that task by resourse.

The report looks like this:

Resource Name
Project Name

Expense | Capital | Total
Sun
Mon
Tues
Wed
Thur
Fri
Sat

If it is proper to report against the SQL tables, what table(s) should we
use?
 
K

Kevin Flanagan

We are using ASP pages developed straight out of SQL.
For some things it works great, but for others it can get
confusing. You will just need to experiment to find out
what works for you. Can also use a reporting tool such
as Crystal, etc. to get the same data for reporting.

Kevin
 
B

Brian Gibson

Would you provide a little more specifics, if possible? Specifically we are
looking to get daily actual hours worked by resource. How do you do that? At
a minimum would you provide a estimate on the level of effort based on your
experience? Thanks.
 
Top