Resource holidays/days-off > Overview report generation > Help!!! 1

[Inopro]

Hello All,

I am a fairly new user of MS Project 2003 and I am in need of help with resource holidays/days off - overview report generation.

I would like to generate a report which gives an overview of individual resource holidays booked into the project file in any one of the following form:

1) Calendar View (month > days view e.g. 01.01.2011 to 31.01.2011)

OR

2) Simple report listing all resources with all their holidays/days off date ranges.

I would be grateful if some one could help me on this topic.

Thanks a lot in advance.....

 

[PDQBach]

That's such a reasonable request (yet it's one I've never seen here before). And I can't show you how to do it because it doesn't seem to be directly "do-able".

If, however, you are comfortable using VBA, then this code snippet will point you in the right direction


dim res as Resource

for each res in activeproject.resources
for yr = 2010 to 2012
for mn = 1 to 12
' some code to set up dylast so that it's
' 30 for Sep, Apr, Jun, Nov
' 31 for other months except Feb
' 28/29 for Feb
for dy = 1 to dylast
if res.calendar.years(yr).months(mn).days(dy).Working then
' Working day
else
' holiday, weekend, vacation, etc.
end if
next
next
next
next


If your project calendar has, for example, Jan 1 as a non-working day but your resource has it as a non-standard working day then it will appear as a working day in the logic above (this is probably what you want, but I thought I'd mention it).

This should be enough to get you on your way.

 

[JulieInMaine]

You may create a custom Resource Report and select "Calendar" on the Details tab of the Report definition. The report will list each resource and their calendar definition as well as exceptions.

Post back if you need more detailed information on creating the custom resource report.

 

[PDQBach]

@Julie: *Excellent* ... I can only give you one star, I'd have given you two or three if it had been possible.

 

[JulieInMaine]

Thank you. I appreciate the feedback.
Julie