J
Jesse
I initially posted to Server thread....may be more appropriate here
I use MS Project 2003 and PS 2003. I have an enterprise custom task field
that tells me the status of each task in my project [finished, finished in
last week, late to finish, started, late to start, start in next week, not
started]. I can open multiple projects and see the status of tasks across
all the open projects. I'd like to create queries to run against the PS SQL
database to gather the same status for 1 or many projects. Can someone help
me with a query.
Here's the enterprise custom field I use:
Switch(([% Work Complete]=100 And [Finish]>[Current Date]-7),"finished last
week",[% Work Complete]=100,"finished",([% Complete]=0 And [Start]>[Current
Date]-1 And [Start]<[Current Date]+7),"start within 1 week",([% Complete]=0
And [Current Date]>[Start]),"late to start",[% Complete]=0,"not started",([%
Complete]>0 And [% Work Complete]<100 And [Current Date]>[Finish]),"late to
finish",([% Complete]>0 And [% Work Complete]<100),"started")
I use MS Project 2003 and PS 2003. I have an enterprise custom task field
that tells me the status of each task in my project [finished, finished in
last week, late to finish, started, late to start, start in next week, not
started]. I can open multiple projects and see the status of tasks across
all the open projects. I'd like to create queries to run against the PS SQL
database to gather the same status for 1 or many projects. Can someone help
me with a query.
Here's the enterprise custom field I use:
Switch(([% Work Complete]=100 And [Finish]>[Current Date]-7),"finished last
week",[% Work Complete]=100,"finished",([% Complete]=0 And [Start]>[Current
Date]-1 And [Start]<[Current Date]+7),"start within 1 week",([% Complete]=0
And [Current Date]>[Start]),"late to start",[% Complete]=0,"not started",([%
Complete]>0 And [% Work Complete]<100 And [Current Date]>[Finish]),"late to
finish",([% Complete]>0 And [% Work Complete]<100),"started")