AnsweredAssumed Answered

Hello, I'm trying to create a dynamic report for occupied rooms in a hotel. Currently, we have...

Question asked by alexandreriva on Jun 10, 2012
Latest reply on Jun 11, 2012 by GuyStevens

Post

Hello,

I'm trying to create a dynamic report for occupied rooms in a hotel.

Currently, we have a table named ROOM SALES, in which several information is stored, including:

- Arrival Date

- Departure Date

- Room #

I want to create a report for any given month like the atteched picture. I know I could create a report based on ROOM SALES to show all the room sales for a given month, but I want the report to be based on the ROOM TYPE instead of room sales. I want to include all the rooms availble in this report, and show if it is occupied or not. Any ideas about how can I do it?

Thank you!

ROOM-LIST.jpg

Outcomes