Re: Reporting resources unavailability

Hi,

On my website there is a VBA program that turns calendar data into tasks.
If you know VBA you could modify it to turn absences into anything for
instance Excel rows, etc.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Salilu" <Salilu@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:617DACC9-6801-45C4-B0D5-B96BFE0FCFA3@xxxxxxxxxxxxxxxx
> MSP (to my knowledge) does not provide calendar report. This is something
> that I am looking forward to since long. For the calendars I have in my
> project, I want a report that lists --
>
> Weekly Work pattern for each day of the week
> Block Exceptions (exceptions for a continuous period,)
> Daily exceptions ( including vacation)
>
> For example:
>
> Calendar Name: My Projet Calendar
>
> Weekly Pattern
> Mon - Thu -- Working -- 8:00 - 12:00, 13:00- 17:00
> Fri -- Working -- 8:00 - 12:00
> Sat - Sun --- Non-working
>
> Exceptions:
> 1. 7/1/05-7/5/05 -- 8:00 - 12:00, 13:00 - 19:00
> 2. 8/1/05 - 8/15/05 -- Non-working.
>
> A report of this nature would be extremely useful, when you have many
> resources in project and would like to quickly see their work
> pattern/vacation without going through their calendars individually within
> the application.
>
>
> "Pai_da_malta" wrote:
>
> > After entering vacation calendar for all resources, I would like to be
able
> > to print them in a consolidated report. Is it possible? How?
> > Thanks,
> >
> >
> > Pai_da_malta


.

Relevant Pages

  • @@@@every burdens will be selective think leaves@@@@
    ... Estefana's silk motivates in favour of our calendar after we ... confront through it. ... I was enjoying to report you some of my ...
    (sci.crypt)
  • Re: Combine multiple records for a single date into 1 record
    ... Check out the calendar reports at ... style report that allows any number of detail records on a date. ... day's details and the textbox that returns the date number, ...
    (microsoft.public.access.queries)
  • Re: Count within intervals
    ... Each time the asset status changes, ... >I need to produce a report that counts the devices by type that were ... you need a calendar table that holds all dates this report could ... suggested query), we create a list of all dates each asset was IN. ...
    (microsoft.public.sqlserver.programming)
  • Re: Calendar Report
    ... It isn't clear if you are just drawing a calendar or if you are adding data. ... The following code draws a calendar on a report page. ... Dim lngDayHeight As Long ... The details section of my> report is split into 7 columns, and in the On Format section of my detail,> i have the following code which sets the date under the correct column ...
    (microsoft.public.access.reports)
  • Re: My calculated expression field is not being populated in the t
    ... I can get that but the problem is that I have a prompt to run the report ... which is 'Calendar Year'. ... now I have the report looking at a calendar year query and the query criteria ... > any calculation will be MUCH faster than a disk fetch); ...
    (microsoft.public.access.tablesdbdesign)