Search results for query: *

Thanks TurkBear, I am almost there, this iw what I ahve: if {pcxPatient.sex} = "M" then chr(?) else chr (?) I get an error message "the ) is missing" Where does the ) go?

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

Thanks again LBass, works perfectly - a huge performance boost to me. My sincere thanks and appreciation to you.

I get the following message "a string is required here" when I do the following: {pcmProcedure.procedureNumber} = 1 and {@SurgDate} = {?DateRange} and isnull({pcmprocedure.deletedon}) and {pcxResources.resourceType} = "Implants" and {pcxPatient.medicalRecordNumber} in [111111 , 123456 , 223344...

LB to the rescue and thanks satinsilhouette. My sincere thanks.

Wonderful suggestion, that completely escaped me. Help me please a step further, so I would create a parameter named, say "MedRecNumber" and then do I need to creat a formula, "MedRecNumber" and then simply paste the values into the formula. Then, in my select criteria I indicate...

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

Thank you for validating that, LB. Much appreciated.

I have placed the subreport in my report footer and all the data is there. I can't find a way, yet, to sort on the "TOT field (other than exporting it to Excel) perhaps because it is a formula? How do I sort the subreport in TOT ascending or descending manner so that I may report on number...

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

Thank you dgillz, perfect. Most appreciated!

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

Noted. Thanks as always for your answers, feedback.

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

Thanks for the formatting help robbie and synapsevamire. That solves it.

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

Works perfectly. I had created a wholly new formula and name based on your recommendation and had placed it in another column of the report. I went back and revised and used the original formula you had given me. It now displays the data exactly as I wanted it Thanks again, much appreciated...

Thank you LB, I am close, but with your revised formula all my results are yielding 0, not just for the cases with a "startsetup time" of greater than or equal to MaxTime. Do you suspect I am missing some syntax in my formula or need to verify my fields to make sure they are number fields or...

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