Gantt report- Resource map

[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,

 

[Wolfgang Kais]

Hello Bill.

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?

Have you tried to set the MoveLayout property to false in the format
event of the section?

 

[Duane Hookom]

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.