Thx a lot for your reply!
I terribly regret the long question, but I would really appreciate your help:
I am trying to create a set of reports using reporting services that
describe the total resource load in a specific time zone.
I am trying to determine the number of hours a day that the resource has to
work on a specific task:
For example:
Let's say I have a task called "planning" which is assigned to one resource
– "Dan"
• The task_start_date is Jan-01-07 and task_finish_date is Feb-01-07
• the Assn_Work is 100 hours (appears in the DB in milliseconds -
100*1000*60*60)
My report needs to calculate how much time Dan spent on the task "Planning",
for example, between 1/10/07 and 1/20/07
In order to calculate that, I need to calculate the amount of hours that Dan
needs to spend each working day on this task (assume a linear distribution),
and then to multiply it by the number of working days between those 2 dates:
• Lets say Dan has 18 working days between 1/1/07 and 2/1/07 (excluding
Sundays & Saturdays & vacations) and 6 working days between 1/10/07 and
1/20/07
• The calculation will be (100h/18 )*6
My problem is that I don’t know how to access the resource availability
data. (For example if Dan is planning a longer vacation during that time, he
will have to work more hours each working day)
I saw a table called "MSP_Availability" on the ProjectServer_Published DB,
but for some reason its empty (although we did insert resource availability
data for all of our resources)
That is why I wanted to extract the availability using the cal_info field.
Do you maybe have any idea on how I can extract this data easily, so I can
use it in a simple query in the reporting services?
Thx a lot for your time,
Lonny
