🚀 go-pugleaf

--------------1E5F74E1F62C2BB683E0DA9B
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



--------------1E5F74E1F62C2BB683E0DA9B
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>

--------------1E5F74E1F62C2BB683E0DA9B--

--------------E448DCDF1906229A82E6589E
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



--------------E448DCDF1906229A82E6589E
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>

--------------E448DCDF1906229A82E6589E--

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

I have encountered a similar problem printing Driver Log information for
truck drivers, where it is important to know if the driver did not
submit a log on  particular day. Crystal is not very good at reporting
on things that are absent (it's not just Crystal, either.  Try to do it
with a TdbGrid, and you probably already know what I mean).

Here is my suggestion:

Create a separate table which does nothing but provide continuous keys.
For example, create a table comprised of nothing but dates, call it
DATES.DB?.  Populate the table with data ahead of time. Even three years
worth of dates would only be 1100 records.  Add this table to your
Crystal report, and then link your true data table to this table based
on date.  Now every date is guaranteed to show up in your report,
because it exists in DATES.DB?.  You can now use formulas to display
special messages if your actual data table does not have a matching
record.

DATES.DB? must be perpetually updated, but this could be a quick
on-startup maintenance routine, ensuring that the range of dates is
complete at the end.

What do you think?

You can also try Seagate's web page.  They have an extensive
knowledgebase, good tech support, too. There's also a Crystal newsgroup
news.cogniza.com.seagate.public.crystal-reports.general

Good luck!

DMGoncalves


Duncan Stewart wrote:

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

Y'all's problems may lie in the you doing your JOINS.  It sounds like you
need to play with LEFT or RIGHT Joins.  Just a start, but this is direction
you need to look.

Roswell Hall
David M. Goncalves wrote in message <35D2E2E4.9271C4BC@vicon.net>...
>I have encountered a similar problem printing Driver Log information for
>truck drivers, where it is important to know if the driver did not
>submit a log on  particular day. Crystal is not very good at reporting
>on things that are absent (it's not just Crystal, either.  Try to do it
>with a TdbGrid, and you probably already know what I mean).
>
>Here is my suggestion:
>
>Create a separate table which does nothing but provide continuous keys.
>For example, create a table comprised of nothing but dates, call it
>DATES.DB?.  Populate the table with data ahead of time. Even three years
>worth of dates would only be 1100 records.  Add this table to your
>Crystal report, and then link your true data table to this table based
>on date.  Now every date is guaranteed to show up in your report,
>because it exists in DATES.DB?.  You can now use formulas to display
>special messages if your actual data table does not have a matching
>record.
>
>DATES.DB? must be perpetually updated, but this could be a quick
>on-startup maintenance routine, ensuring that the range of dates is
>complete at the end.
>
>What do you think?
>
>You can also try Seagate's web page.  They have an extensive
>knowledgebase, good tech support, too. There's also a Crystal newsgroup
>news.cogniza.com.seagate.public.crystal-reports.general
>
>Good luck!
>
>DMGoncalves
>
>
>Duncan Stewart wrote:
>
>>  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
>>
>>
>
>
>

Why not just add dummy records to handle vacant dates for those rooms? 
Crystal reports will then have data to print.
-- 
Alexander Medwedew
Computer Ventures, Inc.
http://idt.net/~compvent/

Luke Bond <lukeb@ionsoftware.com.au> wrote in article
<35D10EAE.3D9C89D1@ionsoftware.com.au>...
> Please help...
> 
> contained to booked rooms). What I want is a list of each day between
> the specified dates, including the blank ones.
>