Reporting on Project Server Database from MS Access

  • Thread starter Thread starter RockNRoll
  • Start date Start date
R

RockNRoll

Access Reporting Gurus,

Can somebody please explain to me how I can report off of Project Server
Database data (task name, resource name, actual work, etc) by using MS
Access reports?

I am able to do this in Crystal with no problem, but when I access the ODBC
from inside of MS Access, the list of tables I get is much different and not
the tables that contain the data I need to report on.

I need to find the MSP_Tasks and MSP_Resources tables in the Project Server
Database, but Access is showing me tables such as dbo.spt_fallback_dev,
dbo.spt_monitor, information_schema.tables, etc.

Here are the steps I am going through:
* File - Get External Data - Import (or link tables - they both
provide the same result of table names)
* Change "File of Type" to ODBC Databases()
* Select "Machine Data Source" tab
* Select my Project Server database (the one that I set up in ODBC
sources...it's the same one that I use for Crystal Reports, which works
fine)
* Then I see a list of tables that is completely different than what
I see in Crystal. It doesn't have the tables I need.

Thank you in advance for any assistance you can give me on this,

-Dave
 
I just figured it out. I needed to change the default table from "master"
to "ProjectServer0434." That got me the tables I needed.
 
Back
Top