Re: Report on projects, tasks and assigned resources

From: Gavin McKay (GavinMcKay_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 16:11:03 -0700

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" wrote:

> 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 wrote:
> > 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
> >
> >
>