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

Madawc Williams Thanks for the reply regarding duplicating rows. I think I just may publish the report with the duplications. I believe you are right that there are no easy answers. But thanks..... By the way, I'm writing from Detroit right across the border from Canada where they televise...

Greetings: If I group by consultant than the patient's data would be all over the report. I want it under the patient's name or patient number so it will group all together. Below is what I am getting. For example: there are 4 consultants on this account. And there are 4 charges on this...

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

Gary: Here is my layout: GH1: Organization Short Name GH2: Patient ID, Pt Name, Medical Record No, Admit dt, Discharge Date, Length of Stay, Practioner Name GH3: Activity Code Description, Activity Total Quantity Detail: Activity Code Description GF1: Org Short Name RF: Grand Total: Number of...

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

synapsevampire: Your suggestion to use 'group by' worked. My question is according to all the documentation I read using 'select distinct' would eliminate duplicate records. Can you take a moment to explain why this did not work and what is record or row inflation?? Thanks so much. Maruja

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

Thank you, lbass. Maruja

lbass: I am trying to put the parameters in the sql expression editor. From your reply you've stated I can't do that. Is that correct?

jpdmdc: I tried both your suggestions and neither worked. I appreciate your help. Thanks. Maruja

jpdmdc: I tried it without quotes and I received the same error message. Any other thoughts?? Thank you. Maruja

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

lbass: My mistake. I didn't expand the number of decimals in my cells. Now I see the numeric data I need. Thank you so very much!!

Lbass: Your response was very good. It gave me zeroes in the inner circles because the calculation involves dividing (for example) the Home patients: 215 by the Total number of patients: 268 to give a percentage of 80.22%. I need this for each of the admission sources you see there. I also...

Ido: Thank you very much. I will give it a try. Maruja

IDO: I have several sources that I need to account for not just ER. Is there a way to accomplish that for all of them? Thanks.

Gary: I have tried your calculation also. It did not work. Visits is a data base field. The reason I said it didn't like it is because the formula never showed up in my 'available fields'. Thanks for your help.

Ido: What I need to show is % admitted by ER by hospital and other admitting sources such as rehab centers, long term care, etc. Please tell me how I get at that calculation. I greatly appreciate your help. Thanks.

Ido: I appreciate your response but I just can't believe that a formula can't be set up to do a simple division to give me a percentage? I haven't been doing Crystal for very long (about 6 months) but it appears to be a very powerful tool. Isn't there some kind of formula that can be derived...