Reporting on Project Server Database from MS Access Reporting

R

RockNRoll

Greetings,

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 Reports 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. when I connect to it using
ODBC

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 (all those dbo tables). It doesn't have the tables I need
(MSP_Resources and MSP_Tasks).

Then when I follow virtually the same steps in Crystal Reports, I see all
those databases I need, like MSP_Resources and MSP_Tasks.

I have read the help files and the database htm files on the install CD
still with no luck.

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

-Dave
 
R

RockNRoll

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