Best way to get tasks from the Project Server Database

[docchang]

What is the best way to get tasks from the Project Server Database?

In VBA code
a. Loop through all task (Is it even possible?)
b. Make the connection to the server and do a SQL Statement
c. Have the desire Store Procedures previously built and call th
store procedure with the desire parameter(s) from a form given by th
user

 

[Rod Gill]

If this is a regular occurrence, then create a View or SP in AQL server and
call it directly. Microsoft will say preferred method is to use PDS, but PDS
is a pain, requires professional programmers and is not supported in 2007 so
your solution has a limited life span. In 2007 there is a new reporting
database and modifying the View to get data from it will be easy.

So, b or c.

--

Rod Gill
Project MVP

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