Hi All,

Right i need to make a report that enables our Sales department to see 'at a glance' bookings for certain rooms over the next 12 months, is this something that could be achieved by modifying the functionality of a gantt chart?

The report is currently made manually in Excell and looks something like this:

January

              M T W T F S S    M T W T F S S(weeks go further onto the end of the month).
Room 1   X  X X X   X X     X X     X X X X
Room 2       X X X             X X X  X X X X
Room 3   X X X X X X X    X X X X X   X X

So it just lets them know where there is free space where they could try and find a client to fill.

Is this something that can be done via a Gantt or other chart? or is there a simpler/ better solution?

Regards

Andrew

At first glance I would go with a crosstab.

I was hoping you had one row per day. Would have made it easier and a crosstab would have been a simple solution