Creating a Crystal report off a Microsoft Project File (MPP)

[Brian M]

I am currently looking for a way to run a Crystal Report off a Microsoft
Project File. I know I can use Excel and Access as datasources, but I have
not found a way to do it with an MPP file yet. Does anyone have information
about an ODBC driver, DAO method, etc. to do a straight port? I’m aware I can
also convert the file from an mpp to a database or an access file, but I
would like to avoid that, especially since 2007 has stated it won’t use ODBC
to save project files in database.

Current versions:
MS project: 2000 and 2003
Crystal Reports: XI

Thanks!

 

[Rod Gill]

Project 2003 has an oledb driver that , but again 2007 does not. Saving to a
database is the best way. With Project 2007 you either need to save as xml
for importing to Access or whatever db you use or use a utility to export
data to the db.

--

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

 

[Brian M]

I'm looking at the OLE DB function now, I see that I can see certain higher
level data (project name, author, the project manager, the calendar used) but
is there anyway to pull out things like task names? If I do something like a
drill down report, I want to show the higher level view, and then managers
can drill down through project phases. Example: If you see the implementation
phase is being delayed, you'd want to go all the way down to see that a
manager missed a critical shipment that pushed the rest of the project out.

Side Question: I understand Microsoft is trying to get away from some of the
security concerns with ODBC, but now they seem to be cutting off all external
ties that other applications can make to it (even to its own product Access).
Are there any future plans to opening up integration with other applications
again? I’m concerned if the newer product will even work with Rational and
SODA reports (which has been our current standard) to meet business needs.

 

[Rod Gill]

There is a file pjoledb.htm in one of Project's program folders that has
full details.

No idea on future plans here, but I for one am developing an add-in to save
and read to an Access or SQL Server database. Not every organisation is
suited to using Project Server. Saving to db is a great interim step for
them.

--

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