Search results for query: *

Hello, I am using Crystal 11. I'm trying to create a report that will show how many operating rooms are running for a particular hour of the day. I am using the patient's in room time and the patient's out of room time. Using these two fields/times helps me to count the number of CASES for...

Hello When doing a running average or just average it there a way to exclude 0's that are in details.. I have a report that I am summing the number of rooms that are running. For every hour it either counts it as a 1 if there was a case for that hour or a 0 if there was not. At the group...

Using Crystal XI My report has a start time and an end time. I need to find out a grand total of how many patients are in a the recovery room at a certain hour. Paitient A can be in a bed for 1 hour at 11 while patient b can be in a bed for 2 hours at 11 and 12. The report is one row per...

Hello, Using crystal XI I have created a report that looks at the time patients enter the OR and the time they come out. I have grouped this report on the patient's out of room time. We are trying to get a count of the rooms that we have running at a particular time for staffing. From 7:00am...

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...

Hello, I'm using Crystal XI I'm writing a report that looks at the time a patient leaves the room until the time the next patient comes into the room (turnover time). Below are the formulas that I am using to get the average turnover time. @average WhilePrintingRecords; Global NumberVar...

Crystal XI I am trying to sum a field but I keep getting a message " this field cannot be summarized". The field I'm trying to total is a formula @turnover and it is written like so: if OnfirstRecord then 0 Else if Date({v_basic_case_rec_data.cr_prdate}) <>...

Hello, I'm using CR XI. I am working on a report that shows the time a procedure is scheduled,(@bookedtime) and the time the patient went into the room (@Ptintime). In my report I am finding the difference between the two times. However, there are times when the Ptintime is less then the...

I am writing a report where I would like the end users to be able to select their names if they were the nurses working in the OR. I would like each nurse (whether 1st nurse or 2nd nurse to be able to run the report using their names. 1st Nurse 2nd Releif Nurse I am using two parameters...

Hello, I have a field that needs to have two conditions met. I was wondering if this could be done. below is the formula I'm using. I am getting a message a boolean is required. How should I write this formula? I am using Crystal XI...

I am writing a report that shows the implants that were placed in several patients. If I run this report for a day there could be twenty patients with implants. The report fields consists of the following: Patient Name Implant description (there can be multiple items implanted) CR # (unique...

Hello All, I am receiving a "bad time format string" error message when i run my report. I have narrowed the reason down to a time that is displaying as 0024 in the database. Can someone please help me with a code that will eliminate this error message. I am using CR XI

I have a report that will not let me change the {v_basic_case_rec_data.cr_prdate} to the year 2013. If I try to put a current date in the report doesn't return anything. Below is what I have in the record selection. This report was written by someone who no longer works for the company. I...

Hi I have a report that shows the days that a surgeon performs cases. I would like to exclude his weekends cases. I have tried to use the below formula that I got from previous posts. However, it is only returning 1.00. Can someone please tell me what I'm missing. WhileReadingRecords; Local...

I am writing a report that shows the OR procedure performed from 7:00am to 5:00pm. Sometimes we have cases that start at 4:00pm and run past 5:00pm and I would like to incorporate those minutes as well . is there a code that could be written for this? example In room Out room total...

Hello Experts, I am using Crystal XI and am creating a report to show the number of operating rooms procedures performed on a weekly basis and the average number done per week. I've done a count on the procedures and need some help finding the average. (example) 1/27/2013 Number of cases...

Is there a way to count the number of records that are not suppressed in a crosstab? I have a report that is showing the reason a case was delayed. there could be three to four cases in a room, each having a delay reason. I have created a formula to show only the first cases of the day in a...

I have a report that shows the first cases of the day. The first case of the day is defined as cases between 7:30 and 10:30. My problem is that when I run the report, if there are two cases in the room, one at 7:30 and the next at 9:30 they both show up.(which it should) Is there a way for me...

Hello Experts, I have a report that is showing the time a nurse went into a room and the time the nurse came out of the rooom. I am using a formula to get the total minutes the nurse was actually in the room. @nursedifftime DateDiff ("n",DateTime(CDate ("November 10...

I have a problem with my report in that I have a patient who has implants on two different days of service. When I run my report it looks like the implants were implanted on the same day. How do I show the records on the next page with the next day of service Ex: page1(Page Header)Patient...