🚀 go-pugleaf

--------------0AF64859F70E1A9808A79BEE
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I can't help Luke but I too am desperately trying to do something similar.

I have reports which use groups to display data from several areas (could be
companies in sales data, regions, whatever) and I too would like my group
headers to display even when they are empty of data.  The fact that, say,
one particular salesman has made NO sales is just as important - sometimes
even more so that tracking the actual sales.

Surely it's possible.

Can't see how though. (using version 5.0 patched to latest update).

Duncan Stewart responding to:-



Luke Bond who wrote:

> 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



--------------0AF64859F70E1A9808A79BEE
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
I can't help Luke but I too am desperately trying to do something similar.

<P>I have reports which use groups to display data from several areas (could
be companies in sales data, regions, whatever) and I too would like my
group headers to display <U>even when they are empty of data.&nbsp;</U>
The fact that, say, one particular salesman has made <B>NO</B> sales is
just as important - sometimes even more so that tracking the actual sales.

<P>Surely it's possible.

<P>Can't see how though. (using version 5.0 patched to latest update).

<P>Duncan Stewart responding to:-
<BR>&nbsp;
<BR>&nbsp;

<P>Luke Bond who wrote:
<BLOCKQUOTE TYPE=CITE>Please help...

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

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

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

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

<P>Regards,
<BR>Luke Bond.
<BR>lukeb@ionsoftware.com.au</BLOCKQUOTE>
&nbsp;</HTML>

--------------0AF64859F70E1A9808A79BEE--