Search results for query: *

thank you, both worked.

I am working with Crystal 10. I have a report that list all patient accounts with self Pay status. I have it Alphabetically sorted. Is there a way to group it by alphabet? In otherwards, put all patient names that start with "A" in a group, "B" in a group, etc.. I'd like to subtotal each...

Thanks MCuthill, but I think there might be something else wrong in the report. I was thinking it wa the above formula. Let me explain. Along with the Anes Min formula we have a Surgery Min formula. These two formula results should not be the same, the Anesthesia min's should always be less...

I'm using Crystal 8.0.1 for this report. Information is being pulled from an Access surgery log. With the following formula we are trying to sum the total minutes for Anesthesia without showing Local, None, or IV sedation anes mins. Not sure who wrote this formula but it does not eliminate the...

I used this and it worked. right(picture(totext({V_ABSTRACT_CONCISE.PATIENT_MRUN},"0000000"),"xxx-xx-xx"),2) in "50" to "99" Thank you so much. You make my job a less stressful!

I am using Crystal 10.0. I am working with a number field (Patient MRUN). I only need records for patients that the last two digits of the Patient's MRUN is from 50 - 99. Example: Field is formatted like this 67,610.00 I use the following formula to have it format correctly...

I'm using Crystal 10. below is a summary of what I need to do: patients come to the ER with Arrive Date/Time and assigned to a Nurse. Then when they leave they have the disposition date/time. My ED Nurse Manager would like a report with a chart to show all patients in a day to show their...

That worked. But I think I need to rethink the entire report. Each charge code has a price increase once a year. Not always the same date. So I want the max effective date of the price. Which I got. But when I go to calculate the precentage of professional fee of the related charge code, I...

I’m using Crystal 10. I’ve been working on a report that pulls information from our charge master. I use the following fields. {CHARGE.CODE} {CHARGE.BILLING_DESCRIPTION} {CHARGE_PRICE.PRICE} {CHARGE_PRICE.EFFECTIVE_DATE} What the Controller wants is all of the Xray dept’s charges with the...

I have installed Crystal Viewer 11-2 on 3 users computers and gave them access to a report that I built in our Information System. One of the users can run the report easily. The other two users get Internet Explorer Script Errors when they are prompted for the Date parameters. When the...

That worked!! I'm fairly new at Crystal Reports and never understood the joins. I will be researching more and finding out how that relates to my reports. Thanks Ibass. You're the best.

I tried your suggestion but the report came back blank when there were over 380+ records with one Foreign Country patient. This is the formula I wrote: if {V_PATIENT_CONCISE.PERMANENT_STATE_CODE}="FC" then {@Foreign address} else {@Address} {@Foreign address}formula is...

Hi, I'm using Crystal 10. I have a report that lists the patient's address in the Page Header. A patient can have addresses in {PATIENT.PERMANENT_ADDRESS}&{PATIENT.PERMANENT_ADDRESS_2}and we needed them both if available, so I wrote this formula that worked perfectly until I had a patient with...

The first formula suggested worked perfectly. Thank you very much. It makes my job much easier today!!!

I am using Crystal Reports 10.0 I have a field that contains the Patient Insurance ID. INSURANCE.PATIENT_HEALTHCARE_COVERAGE_ID The field should look similar to these: 897451234D5 145891177Y3 6549812677Y I only need to pull the records with a "Y" in the last two digits. I have no idea how...

Thank you, that worked perfectly.

I am using Crystal Reports 10.0. I'm pulling the tables from a SQL Connect datebase. The patient is in Observation and need to calculate the amount of hours from start date and time thru end date and time. {OBSERVATION.OBV_START_DATE} {OBSERVATION.OBV_START_TIME} {OBSERVATION.OBV_END_DATE}...

AdventurGurl that worked perfectly. I am very new at using Crystal and I was amazed how that worked! I would have never thought of the group footer. I'll remember that for the next time. Thanks so much

lbass is correct. I did want the whole number into a 7-digit display. the formula you provided worked like a charm. picture(totext({table.number},"0000000"),"xxx-xx-xx") I am very new at using Crystal, this is the first time I've seen picture in front of the formula. What does that do? What...

I have a report with patients that have been in the hospital within a date range. The report contains the following tables: VISIT.ADMIT_ARRIVE_DATE VISIT.DISCHARGE_DISPOSITION_DATE PATIENT.NAME REG_DATED_ROOM.CODE VISIT.PATIENT_ACCOUNT_NUMBER The report works great with the exception of: If...