Custom Reports / Enterprise management

[Delali Dzirasa]

I have recently taken on two tasks, using MS Project 2000:



1) Learning how to access the project data to be able to general very
custom reports (I have looked the project help files and understand the
model). From the research I have done on this newsgroup it appears that I
can do this

a. Using VBA directly within the project application, or

b. Using the oledb provider to access the project data from vb (or any
..NET language),

i. Will
the oledb provider interface with Crystal Reports fairly easily?

c. Storing the Project data into an access DB or SQL Server DB then
connecting to that db via any application of choice.





Is this correct? Also any recommendations on an approach?



2) I am learning how to incorporate more enterprise functionality into
our organization, so that upper level management can view all current
projects on more of a global view.

a. Can this be done via Project 2000?

b. Must I upgrade to a newer version of Project?

i. If is
there a steep learning curve between project 2000 and 2003?





Thanks for you help, and direction that you can provide would be great!





Regards,



Delali Dzirasa

 

[JackD]

Project 2000 will reach end of general support in June or July of next year.
If you really want what you are looking for in question 2 then I suggest
looking at project server.
It provides the functionality that you are looking for and would be easier
than developing something from scratch.

-Jack

 

[Delali Dzirasa]

Project 2000 will reach end of general support in June or July of next year.
If you really want what you are looking for in question 2 then I suggest
looking at project server.
It provides the functionality that you are looking for and would be easier
than developing something from scratch.

-Jack

Thanks!

That answers my second question, however what about #1?


Delali

 

[JackD]

The answer to one is Yes.
The recommendation will change if hyou are using project server.
Project server stores the files in database format and there are methods to
work with it as well as OLAP tools.

-Jack