Daily Schedule in 10 minute increments

[risman]

Hello,
I am using an SQL Db with CR 8.5. I have what is probably a very elementary question, but I just can't figure it out:
I am trying to design a report that shows scheduled exam times and open times that can filled for various departments for the current date and the following day. I would like to show the schedule in 10 minute increments starting at 7:00 a.m. thru 9:00 p.m. Exams are scheduled usually starting at 7:00 a.m. Depending on the exam, they will have different duration times of 10, 15, 25, 30, and 45 minutes. The next exam can only be scheduled for after the previously scheduled exam plus the duration time of that exam. For example:
7:00 a.m. Closed for Exam 1 CT Head - Duration 20 minutes
7:10 a.m. Closed
7:20 a.m. Open
7:30 a.m. Open
7:40 a.m. Open
7:50 a.m. Open
8:00 a.m. Closed for Exam 2 CT Abd -Duration 45 minutes
8:10 a.m. Closed
8:20 a.m. Closed.....
You get the idea.
My question is how do I set up the time increments starting at 7:00 a.m.(even if there are no scheduled exams)? I've worked out the formulas to show if there are times available between exams. As I said, it's probably very simple and I'm just overlooking a basic concept. Any help would be greatly appreciated.
Thank you!

 

[MJRBIM]

Create another table that contains all your timeslots - and to link it in your report.

Show the time slots from your new table and the bookings from your existing table.

 

[Madawc]

If you can't add a table, you'll be stuck with creating a 'Mock Crosstab'. Crosstabs are fine if you don't mind the absence of rows or columns with no data, but you said you wanted empty slots to show.

A 'Mock Crosstab' is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then.
Crystal should have included an example along with the Crosstabs. You can save a little time by doing a paste to a dummy report, changing the name and then pasting back.
Each running total will count the record if it was within the criteria

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