Search results for query: *

Greetings: I have been asked to write a report showing all Cancer pts who either had a consult or did not. This is accomplished by inserting a Group. The Group consists of an indicator: ind_consult_ind: inpatients that have at least one consult provided by a physician count as 1 otherwise 0...

Greetings: I am a user from a medical facility. I have been asked to write a report (Crystal 10) showing all physicians who consulted on cases where the DRG was 82. (DRG's enable specific forms of reimbursement to hospitals.) Also specific charges or 'activity codes' were included in the...

Greetings: I am writing a report for the Cancer Center in a Medical Facility. They have asked to see days stay for patients and at the end of the report they want me to average those days. I have 4 patients. Their days stay are as follows: 1.0 9.0 8.0 6.0 This totals 24 divided by 4 should...

Greetings: I am writing a report for a cancer department. Basically, they want to see a patient list for DRG 82. This is a diagnosis related group (DRG) which is used in reimubursement and is based on several factors; one being the final diagnosis. There are 4 hospital involved. They also...

Greetings: I work at a medical facility. I have established 2 parameters. One for start date, the other for end date. This is being used on quarterly reports. I am trying to insert this is an SQL query. Here is the logic: (Select sum(A."visits") from SMSDSS.c_cmb_vst_v_20050303 A where...

I work at a medical facility. I am on Crystal 8.5. I have two cross tabs. One that counts visits which has worked fine. The other takes those visits and turns them into percentages. For example: Row: admission source: Emergency Room. Column: Hospital Name. Summarized field: Should reflect...

Greetings: I work at a medical facility. I have two cross tabs. One that counts visits which has worked fine. The other takes those visits and turns them into percentages. For example: Row: admission source: Emergency Room. Column: Hospital Name. Summarized field: Should reflect 80.22%...

Greetings: I am writing a report where I am doing a running total of cases for patient visits by quarter. That has worked out fine. I have summed the visits, evaluated for each record and reset on change of group which is quarter. However, I am trying to get an overall total that will carry...

Greetings: I am fairly new to Crystal reporting. (5 months) I am an analyst in a medical facility. I have been asked to write a report showing all patients discharged 'alive' from a facility from january 2004 thru july 2005. I decided to do a cross tab. Unfortunately babies are in one table...

I am an analyst in a medical facility trying to get stats on physicians. I am trying to sum readmissions by quarter. The indicator is a numeric field yet when I try to summarize it will not allow me. I can count,average, max,etc but no sum.. I am trying to get the top 5 docs by volume. Any...