Recent content by JonathanNYC

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