TimeScaleData   

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

date: Fri, 20 Jun 2008 14:02:47 -0400   author:   David Chazin

Re: TimeScaleData   

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
"David Chazin"  wrote in message 
news:N8idncUZ-8KubcbVnZ2dnUVZ_qfinZ2d@comcast.com...
> 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
>
>

date: Fri, 20 Jun 2008 21:13:08 +0200   author:   Jan De Messemaeker