Report on projects, tasks and assigned resources

[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?

Thanks

 

[Rob Schneider]

Surely this can be done in Access, but it would be more time-consuming
and adds a whole lot of complexity and cost (development and support)
which is unnecessary in my view. I suggest you look at Project as the
tool to do this. See if the View: Resource Usage with adding the column
"Project" and applying the filter named "Slipping Assignments" gives you
want you want. Look at how this filter is constructed (via the edit
button on the filter) to adjust it if you wish to better define how you
detect "overdue".

Hope this is useful to you. Let us know.

rms

 

[Gavin McKay]

Hi Rob,

Thanks for the tip, but I think I may be missing something somewhere... my
client needs to view all their current projects in Project Server, then all
tasks for each project, which ones are overdue (i.e. via filter as you
suggested), and the resources assigned to each task (if any). Can MS Project
be used to show multiple projects at once, or is it limited to a single
project?

I've done a sample in Access, and the SQL for that (straight Access view I'm
afraid...) is as follows:

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;

I've added linked tables for all the Project Server tables, hence Access
adds the dbo_ prefix to all tables.

Is Access the best option here, or can Project client be used for a view
across multiple projects?

Thanks!

 

[Rob Schneider]

Oh... you are talking about Project Server (this ng is for Project).
Best to re-ask this in the microsoft.public.project.pro_and_server where
server questions like this are better discussed. Experts hang out there.

Hope this is useful to you. Let us know.

rms

 

[Gavin McKay]

Ah! Sorry that makes sense now - thanks for your help! :>

 

[Mike Glen]

Hi Gavin (& Rob),

No, that ng is closing down! Try posting on the server newsgroup. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://www.mvps.org/project/.

Mike Glen
Project MVP