I am trying to create a calendar of sorts from our scheduling software. I am using CR 10.
Basically, I have data that looks like this:
Procedure Room Start Time Duration
Procedure 1 1 7am 3 hrs
Procedure 2 2 6am 3 hrs
Procedure 3 3 7am 4 hrs
Procedure 4 4 6am 3 hrs
Procedure 5 3 12am 3 hrs
Procedure 6 2 10am 2 hrs
I'd like to have a cross tab report that lists out the hours of the day at the top, have the room times down the left side, and have an X or O (or a 'Booked' and 'Open' would be preferable, if possible) in each square, depending if that room is booked.
So, for room 1, the first line would show an x in every hour - 6, 7, 8 (since the duration of the procedure is 3 hours) It would have a O for the rest of the hours in the day.
For Room 2, the first line would show an x in every hour - 6, 7, 8 (since the duration of the procedure is 4 1/2 hours) It would have a O for in the box for 9, and an x for 10,11,12, then O for the rest of the hours.
Hopefully this makes sense! I can't quite figure out how to write a formula for the cross tab that will let me accomplish this. Any help is greatly appreciated!
CJ
Basically, I have data that looks like this:
Procedure Room Start Time Duration
Procedure 1 1 7am 3 hrs
Procedure 2 2 6am 3 hrs
Procedure 3 3 7am 4 hrs
Procedure 4 4 6am 3 hrs
Procedure 5 3 12am 3 hrs
Procedure 6 2 10am 2 hrs
I'd like to have a cross tab report that lists out the hours of the day at the top, have the room times down the left side, and have an X or O (or a 'Booked' and 'Open' would be preferable, if possible) in each square, depending if that room is booked.
So, for room 1, the first line would show an x in every hour - 6, 7, 8 (since the duration of the procedure is 3 hours) It would have a O for the rest of the hours in the day.
For Room 2, the first line would show an x in every hour - 6, 7, 8 (since the duration of the procedure is 4 1/2 hours) It would have a O for in the box for 9, and an x for 10,11,12, then O for the rest of the hours.
Hopefully this makes sense! I can't quite figure out how to write a formula for the cross tab that will let me accomplish this. Any help is greatly appreciated!
CJ