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?