Skip to Content
0
Former Member
Dec 19, 2011 at 06:37 PM

Crystal Report Stacked Bar Chart by Time

282 Views

Does anybody know how to do the following:

Each input record represents an operation scheduled for tomorrow - each record contains following fields.

Operating Room Number,

Operation Case Number,

Scheduled Start time of Operation,

Scheduled End time of operation.

Sample data would look like this:

OR Room , Case, Start Time, End Time

1, A, 7:30 AM, 10:30 AM

1, D, 11:00 AM,1:00 PM

1, G, 1:30 PM, 5:00PM

2, Z, 8:00 AM, 10:00AM

2, X, 11:00 AM, 2:30 PM

Chart should show time of day on y axis, and operating room on x axis.

Each operating room on x axis should have a stacked bar representing the start/end time of each operation.

example or first column follows (ignore the dots)

07:00......__

07:30......|...|

08:00......|...|

08:30......|...|

09:00......|...|

09:30......|A.|

010:00....|__|

10:30..... __

11:00......|...|

11:30......|...|

12:00......|D.|

12:30......|__|

01:00...... __

01:30......|...|

02:00......|...|

02:30......|...|

03:00......|...|

03:30......|...|

04:00......|G.|

04:30......|__|

05:00

.............OR1........OR2