Creating Occupancy Dates / Data

[former_member1258928]

Hey everyone, this is my first post, so be gentle! lol

I've been in the Hospitality Industry for over 20 years and I've been exposed to R&R Report writer for most of that, but have been really getting into Crystal 2020 and I LOVE IT!! With that said, I created a pretty complex Occupancy report that saved to a .DBF (old school), utilizing separate date database, when ran, could take hours to complete, as each record had to run thru years of dates... and doing that for hundreds of thousands of records, well, you can do the math...

To build this Occupancy data, for example, if you have a 5 night stay at a hotel, that would be one record in the Property Management system. This set of reports would read that one record and explode it out into 5 individual records, each new record with an Occupancy Date. This makes reporting on Occupancy a million times easier.

I would like to know if, instead of creating the same type of report sets as I did before, if Crystal can do this just within the same report?

Any help on this via formulas would be awesome!! thank you!

[former_member1258928]

Hey Don,

Thanks for the reply.!!

I actually got help on this. First, we created a standard "Date" table that just contains dates from 2012 thru like 2050. I used that table to relate (Link) to my Reservation table and I setup 2 links, one to the Arrival Date and another to the Depart date. In the Link Options to the Arrival Date, I made the Link Type >= and for the Link to the Depart Date, the Link Type is < (less than). see below...

I then in the report design, I grouped by Reservation Number and i'm Sorting by Reservation number, by a Formula field I call OccNowDate (which is just the Date from the Date table I created. Then my result is this:

As you can see, it's showing the Occupancy Dates perfectly for each reservation.

Thanks again for posting Don.

[DonWilliams]

Not sure what field you are using but try this...

Insert a Group and base it on the field that shows 5 nights.

For details you can show the 5 individual nights or you can suppress them to speed things up.

Or you can hide details by right clicking on the section.

PS yes that DB is old school and you should upgrade to a real SQL Database...