Print Page | Close Window

Appointment Schedule Open Slots

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15510
Printed Date: 03 May 2024 at 3:04am


Topic: Appointment Schedule Open Slots
Posted By: PebbleCreek
Subject: Appointment Schedule Open Slots
Date Posted: 01 Feb 2012 at 10:29am
Hi - I have tried so much for the past few weeks and now I am reaching out to you!  I have a physician's office that has appointments.  I want to pull them into a CR and show the open slots. 
 
I really need to be able to do something like this:

time     type of visit  
0800                             
0815
0830
0845
0900    EPL
0915    EPL
0930
0945    DOB
1000
1015    EPL
1030    EPL


The database HAS the following:
0900  EPL
0915  EPL
0945  DOB
1015  EPL
1030  EPL
1545  NEW

I need to show the holes in the schedule.  I can pull a very nice list of everything that is scheduled and an LEFT OUTER JOIN will not work because the data does not exist in the Right.  Since the data does not exist, it is not null and there is no reference to link the missing data to the time slot table. 
 
I created a table of my time slots.  I linked it to the "actual schedule" from the database and now I trying to pull the time slots on the left BUT show which time slots are booked. 
 
I really need help with this!  Any ideas?
 


-------------
Thank You in advance for your help!


Replies:
Posted By: kostya1122
Date Posted: 01 Feb 2012 at 1:11pm
i assume you have fields like
table.time
table.day
table.week ...
so first group on day
then create a text box for each time place them in group header like
time    
0800                             
0815
0830
0845
0900   
0915  
0930
0945  
1000
1015   
1030   
then create a formula for each time like
if table.time = 0800   then   table.type of visit  else ""
if table.time = 0815   then   table.type of visit  else ""
place each formula to the appropriate text box.                       
this should work

 

Posted By: PebbleCreek
Date Posted: 01 Feb 2012 at 4:43pm
Hello -
 
I have table.time and table.date--- no week
 
So group on DATE?
 
 
Then enter create text (time box) boxes in section A for 0800, then B for 0830 etc?  
 
Divide the header into the time slots according to what I need?
 
Then create a formula and place the object next to the Time Box?
 
I can try...get back to you soon.  Thank you so much for your time!
 
 


-------------
Thank You in advance for your help!

Posted By: kostya1122
Date Posted: 01 Feb 2012 at 6:13pm
group on table.date
just expend the group header 'a' and put all the text boxes with time
 into one group header
then create a formula for each time and
place each formula next to the appropriate text box

Posted By: PebbleCreek
Date Posted: 02 Feb 2012 at 7:48am
Good Morning - I have the daily grid and formulas created.  Now the problem I have is instead of showing all of the events for the day, it is placing ONE event per page per day.  They are displaying at the correct time on the grid, but not all one one page.  How can I get all of the events to appear on the same day? 
 
 


-------------
Thank You in advance for your help!

Posted By: PebbleCreek
Date Posted: 08 Feb 2012 at 4:02am
Good Morning - Do you have any other suggestions on how to display all of the times rather than one per page?  Thank you


-------------
Thank You in advance for your help!


Print Page | Close Window