making null fields print

[nomeci]

What I am trying to do is create a report that would print out like a daily calendar. With time frames going down the left hand side and then the patient information listing to the right of the time of the appt.

That is east enough to accomplish, but the person requesting this report is also wanting it to show the times that are still open. Example:

0900 ______________________________________

0920 John Smith Surgery Date Procedure

0940 ______________________________________

1000 Jane Smith Surgery Date Procedure

1020 ______________________________________

1040 ______________________________________

1100 Joe Schmoe Surgery Date Procedure

I have never had any luck getting Crystal to do anything like that and am wondering if anyone else would know a trick to get it to work.

I am using Crystal 8.5
Thanks,
Nomi

Oracle 8.1.7.4 | Crystal 8.5 | OS 2000/XP
nomi...
Life is like a jar of jalapenos... the choices you make today may burn your butt tomorrow...
----------------------------------------
Other great sites:

http://www.utteraccess.com

http://www.VBAExpress.com

 

[MrBillSC]

You don't give any information about your tables etc.

Create 2 groups: appointment date and appointment time.

In order to report a line for every appointment time I recommend you create a subsection for each (detail a, detail b, detail c, etc.) In each section place a text box with the appointment time and an blank line. Also create a detail subsection to report the data when it exists.

Next conditionally suppress each blank line subsection with a formula:

//formula to suppress blank line 0920:
{table.ApptTime} = 0920 or
{table.ApptTime} < 0920 or
({Table.ApptDate} = Previous({Table.ApptDate}) and
Previous({Table.ApptTime}) > 0920)

Create a similar conditional suppress formula for each blank line subsection.

MrBill

 

[Madawc]

Can you get new tables set up on your database? If there was a table of time or business hours in 20-minute chunks, this could be the backbone of the report. Use a left-outer to attach actual appointments.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10