Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Appointment Schedule Open Slots Post Reply Post New Topic
Author Message
PebbleCreek
Newbie
Newbie
Avatar

Joined: 01 Feb 2012
Location: United States
Online Status: Offline
Posts: 4
Quote PebbleCreek Replybullet Topic: Appointment Schedule Open Slots
    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!
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet 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

 

Edited by kostya1122 - 01 Feb 2012 at 1:12pm
IP IP Logged
PebbleCreek
Newbie
Newbie
Avatar

Joined: 01 Feb 2012
Location: United States
Online Status: Offline
Posts: 4
Quote PebbleCreek Replybullet 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!
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet 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




Edited by kostya1122 - 02 Feb 2012 at 5:32am
IP IP Logged
PebbleCreek
Newbie
Newbie
Avatar

Joined: 01 Feb 2012
Location: United States
Online Status: Offline
Posts: 4
Quote PebbleCreek Replybullet 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!
IP IP Logged
PebbleCreek
Newbie
Newbie
Avatar

Joined: 01 Feb 2012
Location: United States
Online Status: Offline
Posts: 4
Quote PebbleCreek Replybullet 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!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.015 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.