Forum Discussion
Generating scheduling reports for individuals
Hi all, Every monday morning we have a planning-meeting for this department, and want to show people neatly what tasks they'll be working on for the upcoming 4 weeks. They might be working on severa...
Hi John,
It is indeed the idea to have a more isolated view and I'd be very much interested in such a macro, especially if it could be setup as easy that my boss would have to take a minimal amount of steps to generate the report. Bonus point if we can set it up by default to be pleasing to the eyes and neatly printable.
Something like:
>Activate macro/report
>Select resource>[Resourcename A]
>Enter week range (for example:) Week 40-44
>generate report
>Badabing, badaboom.
>ctrl-p to print
If this is possible I'd sure be glad to have it. Can I contact you privately anywhere for further discussion?
With kind regards,
Siebe
Yeah a macro can do everything you want except for one thing. The Project object model does not support the badabing and badaboom properties of the resource object. I've been meaning to submit a request for that functionality to the Project developers for a while but just haven't gotten around to it. Do you happen to have a round to it, all my to it's are square.
Had enough? Okay, down to the nuts and bolts (no washers). I've written a lot of macros that export Project data to Excel and create custom reporting. I probably have something close enough to what you want ,(except for the above of course), that can be tweaked to produce a "boss friendly" report. You can contact me at the address below. I will ask some questions.
And yeah, if you want to work with me you are gonna have to put up with more of the above. It's just the way I roll.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies)