Search results for query: *

I wish to develop a way to identify date(s) that a surgeon used the operating room on days that were NOT his/her block time. My thought is that I might be able to do this with some compare formula or some statement that yielded a True/False if a certain condition was met. As an example, if...

I have a report that displays patient initials (Last Initial, First Initial). The report is displayed in a public area for the nurses to track patients. We use the initials for confidentiality. For female patients, a pregnancy test must be done. The nurses used to be able to determine (for...

Is there a way to "copy and paste" multiple values (from an Excel table, for example) during the Record Selection process, rather than having to manually input such values or select from the drop-down menu. Or, is there another option that might ease the time to do this task? Example: I am...

I have a formula for turnover time (TOT) which I have placed in a report. The formula works fine and is as follows: If onfirstrecord then 0 else IF {pcmORroom.orName} = PREVIOUS ({pcmORroom.orName}) THEN ({@PatientINRoom} - PREVIOUS ({@PatientOutRoom}))/60 I am presently sorting the report by...

As a workaround to duplicate detail lines of data in a report, I grouped by a field called “case number” (a number unique to each case) and then grouped by “case number”. I then copied and pasted fields from the detail row into the group header row and that seems to work fine. I am able to do...

Need help with viewing a formula(s) that seems to work most of the time. The anomaly I have noticed is that it does not work for patients born before 1930. I could be all wrong about that, but that is one thing I have noticed. For a patient born on 9/1/31, I get 75 - which is correct For a...

I have created a report that includes several columns with just header information (text labels) for the user to enter data on the day of surgery. Some of the other columns do have data that is pulled from our database. I know how to do background shading or color on a field from the database...

Several of you helped me with a formula to calculate time used in the OR only up to 7 p.m. There are instances when a case starts before 7 PM and ends after 7 PM and that calculation is accurate. However, there are a few instances each month when a case starts AFTER 7PM. As such, it seems that...

For a report pertaining to laterality, I am trying to extract “left”, “right” or “bilateral”. Left and right are indicated only in the “descriptMod” field, however, “bilateral” may be indicated in either the “descriptMod” and/or the “proceduredescription” field. Thus far I can not get “formula...

Is there a way to establish a group (not sure if that is the appropriate term) for only certain items that appear in a table, so that I may be able to use that group in my record selection criteria. I have a table with 1000 different procedure names in it. Each procedure name has a...

I am searching for the word "left" in a procedure modifier field. Procedure modifier is used to denote laterality in surgical procedures. I suspect that I need an "is like" expression to search for the word "left" because often there is more than just the word "left" or "LEFT" or "left" in the...

I have a field "pcm.surgdate"(DateTime) thatI would like to show in the report only by calendar year. For example, I want 12/18/2006 to show as 2006 and 2/15/2004 to show as 2004, etc. I am using Crystal Reports 10.0. Might someone recommend a formula that I might use.

Requesting help on a Crystal Reports formula to report on the first, second and third highest value in a column or row. In Excel, as an example, I might use the following formula for the second highest value in a row: =LARGE(A1:Z1,2) For a row with the following values, in a field I'll call...

On the recommendation of a forum member, I'm using a "running total" and then suppressing data in the detail section (X2+pencil) to limit display of instrument names and corresponding quantities to the first two cases and only the first two cases in an operating room. This is working fine. My...

I need to generate output that identifies total number of instrument trays (by instrument tray name) required for the first two cases only in all of our operating rooms. There can sometimes be as many as eight cases in an operating room each day. On some days, there may be only one case in an...

Firstly, thank you Tek-Tip community for the timely and valuable help all year. Health, peace and prosperity to all in 2007. I am seeking suggestions as to how you summarize or categorize your various Crystal Reports so that people in your organization and other functions may become aware of...

Need help with a formula that calculates total operating room time used, but only time used up to 7 p.m. I derive time used by calculating the amount of time from “room open” to “patient out of room”. And, that formula works fine. However, there are some surgical cases that continue past 7 p.m...

Any suggestions for converting a calendar date to the week/day of the month that it falls in a given month. Example: January 8, 2007 to be represented as "2nd Monday in January" January 18, 2007 to be represented as "3rd Thursday in January" etc. I know how to format January 8, 2007 so...

Rather than manually entering (medical record number) values individually into a field in my select criteria, is there a way to import those values or copy and paste those values into the select criteria box. I tried doing a copy and paste from Excel, but was unsuccessful (it only pasted one...

I am successfully counting operating rooms that start with the letter "A" and an admission status = "AMS" (see formula I am using below). There are a few sitautions where the admission status is empty and I wish to count the number of such instances. Here's the formula I am using to count AMS...