John
Tue Dec 11 18:17:46 PST 2007
In article <57E46936-CEA7-4B97-B642-72440A121A0D@microsoft.com>,
Nicola A. <Nicola A.@discussions.microsoft.com> wrote:
> Is there anyway that I can create a table that combines fields from task and
> resource tables? I want to be able to display task IDs, task name, various
> custom task fields, and the individual work for a specific resource if the
> task has multiple resources assigned to it? I want to create single line
> report that I can develop a filter that selects only for the specific
> resource. Similar to the example below with additional information.
>
> Task #1, Start, End, Baseline Work for Resource #1, Resource #1
Nicola,
The only way to get combined view data is either via a split window or
by using the Resource Usage or Task Usage views. However, be advised
that your custom task fields will not appear in the Resource Usage view.
See FAQ 51 - Data types: task, resource and assignment, on our MVP
website at,
http://www.mvps.org/project/faqs.htm.
You can get the exact report you want but you will have to export
Project data to another application (e.g. Excel). If you do not need
timescaled data, you can use an export map. If you do need timescaled
data (e.g. resource work over a time span), you can try the "Analyze
timescaled data in Excel" utility or for Project 2007, try the visual
reports feature. To get the exact report you want with a single custom
menu item or toolbar button, VBA is the way to go.
John
Project MVP