Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lindagoodwin

    Group by Alpha Split

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

    Do not count the Anes Minutes criteria

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

    Only pull records last two digits are 50 - 99 of a 7 digit number

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

    help with Gantt chart

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

    Grouping on similar codes

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

    Internet Explorer Script Error

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

    Conditional Formula

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

    Formula to select records if the field contains a "Y"

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

    Datediff with separate fields for date and time

    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}...
  10. lindagoodwin

    suppress duplicate records

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

    Converting a number field to print in specified order

    I'm using Crystal 10. I have a number field in the{VISIT.MRUN_VISIT} that prints like this: 35062.00 I need it to print like this 003-50-62 I know it's a formula but I am a beginner in working with Crystal and can not figure it out. Thanks

Part and Inventory Search

Back
Top