4 Replies Latest reply on Jun 11, 2012 9:33 AM by GuyStevens

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

    alexandreriva

      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