TimeScaleData

[David Chazin]

Hi,

Am trying to create a weekly report, listing the Tasks on which a particular
Resource worked, with the hours worked each day in the week on each task,
that looks something like this:

Resource: John Smith
Task ID Task Name Sun Mon Tue Wed Thu Fri Sat
24 Testing 0 8 3 1 0 0
0

I can't seem to relate the TimeScaleValues with their corresponding Resource
and Task at the same time.

The following code gives the TimeScaleValues for a particular RESOURCE for
the desired week:

Set tsvs = r.TimeScaleData(#6/15/2008#, #6/21/2008#,
pjResourceTimescaledActualWork, pjTimescaleDays, 1)
For Each tsv in tsvs
[in here I need to be able to do something like:
Debug.Print tsv.Task.ID
except there does not seem to be a property of tsv that represents the
Task associated with the TimeScaleValue]
Next tsv

Similarly, the following code gives the TimeScaleValues for a particular
TASK for the desired week:

Set tsvs = t.TimeScaleData(#6/15/2008#, #6/21/2008#,
pjTaskTimescaledActualWork, pjTimescaleDays, 1)
For Each tsv in tsvs
[in here I need to be able to do something like:
Debug.Print tsv.Resource.Name
except there does not seem to be a property of tsv that represents the
Resource associated with the TimeScaleValue]
Next tsv

Any ideas?

Thanks in advance,
--David Chazin

 

[Jan De Messemaeker]

Hi,

You are looking for the timescaledvalues of the ASSIGNMENTS

So when the resource is called Areso:

For each Ass in areso.assignments
.... here you can use ass.timescaledata
and look for things like ass.taskname

The help on the assigment object will show you all you need.
In summary: a resoruce daies not "have" tasks, it has assignme,ts.
The lines in italic on the resoruce usage view represent assignments, not
tasks.
Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf