newbie0423
IS-IT--Management
I have a report that I'm using a crosstab that shows the hour that a patient leaves the recovery room. I would like to get a count of patient's stay in the recovery room by the hour. For instance, if a patient comes into the recovery room at 7:10pm I would like a count that patient in the 7:00 hour, and if he/she is still in there at 8:25 pm I still would like to count them in the 8:00 hour. I have two formulas @PACUSTART and @PACUEND. In the crosstab I'm doing a count on PACUEND.
Is this something that I should be doing in a crosstab, or should I try to come up with a formula?? I am using Crystal XI
Is this something that I should be doing in a crosstab, or should I try to come up with a formula?? I am using Crystal XI