🚀 go-pugleaf

Please help...

I'm using Crystal 6.0 and I'm trying to write a particular report, but I
can't seem to get the formula to do what I want. Say, for example, I
wanted to write an 'Occupancy Report' for a hotel that lists each day
(between two date parameters) and indicates how many rooms are
booked/available and their status (enquiry, confirmed, etc.). This is
fine, but on days that have no rooms booked, then it skips these days
because crystal selected no data (based on the idea that these days
contained to booked rooms). What I want is a list of each day between
the specified dates, including the blank ones.

I thought that I could put a formula in the report header that
initializes a date variable according to the parameter field FROMDATE,
and then increment this day by one until it matched the next record that
crystal selected (ie the next day with rooms booked), and print that
line, but in the meantime print a line that indicated this day has no
bookings.

The problem is that there is no formula command like 'loop', 'while' or
'repeat' that will loop through the blank ones, and I can't link this
date variable to a group.

PLEASE, if anyone can help then I would greatly appreciate it. It is for
a very important program.

Regards,
Luke Bond.
lukeb@ionsoftware.com.au