Gantt report- Resource map

  • Thread starter Thread starter Bill Gates
  • Start date Start date
B

Bill Gates

Hi,

I have created a Gantt style report based on the example found at:
http://www.access.hookom.net/Samples.htm

This works fine but I would like to create a report by employee that will
show when they are free/busy. I can get it so all of the projects are on a
different row but is there anyway I can overlap all of the rows to be on one
row?

I have tried changing the grouping in sorting and grouping but this did not
seem to change anything.

Thanks,
 
Hello Bill.

Bill Gates said:
I have created a Gantt style report based on the example found at:
http://www.access.hookom.net/Samples.htm

This works fine but I would like to create a report by employee
that will show when they are free/busy. I can get it so all of the
projects are on a different row but is there anyway I can overlap
all of the rows to be on one row?
Click to expand...

Have you tried to set the MoveLayout property to false in the format
event of the section?
 
Did you look at the Crew Rotation Schedule?

You would need to have a code in the On Format event of your detail section
of:

Me.MoveLayout = False

Then make sure you have an employee group footer that is the same height as
the detail section. This should dump all of the employee's details into the
employee footer.

If you can't figure this out, come back with your sorting and grouping,
code, etc.
 
Back
Top