Reporting directly from SQL/Access for Project Server

[Gavin McKay]

Hi there,

My client wants a report they can run that shows the tasks that are overdue,
the project they belong to, and what resources have been assigned to the
task. Can anyone suggest some SQL or a solution that can present this
info?
So far I've though about using Microsoft Access and either connecting
directly to the db tables, or the db views.

I can get Projects and their Tasks, its finding out what resources are
assigned that's got me... can someone tell me what tables/fields I should be
linking?

This is my current (Access) query using linked tables from SQL:

SELECT dbo_MSP_PROJECTS.PROJ_NAME, dbo_MSP_TASKS.TASK_FINISH_DATE,
dbo_MSP_TASKS.TASK_NAME
FROM dbo_MSP_PROJECTS INNER JOIN dbo_MSP_TASKS ON dbo_MSP_PROJECTS.PROJ_ID =
dbo_MSP_TASKS.PROJ_ID
WHERE (((dbo_MSP_TASKS.TASK_FINISH_DATE)<Now()))
ORDER BY dbo_MSP_PROJECTS.PROJ_NAME, dbo_MSP_TASKS.TASK_FINISH_DATE,
dbo_MSP_TASKS.TASK_NAME;


Thanks