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!

[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...