Search results for query: *

I work in a hospital and have a report that shows the medications that a patient is taking which are charted on admission. I am needing to limit the information to one or two entries and am wondering how to do that. I know this is vague. What other info do you need? Thanks.

and hour({c_medication.time_for}) = 9 and minute({c_medication.time_for}) = 0 This worked like a charm. Thanks. I'll include the other info next time, thanks for reminding me.

I am doing a report where I'm listing medications that are ordered {c_medication.time_for) and the time they were charted (c_medication.entered_at). I only want to show those that were ordered at 9:00 AM {c_medication.time_for) and want all dates. The display on the report is 9/??/2007 9:00AM...

I did try that and get "A Boolean is required here" error. Here's the statement with your suggestion added. I don't know if this helps or not. {c_str_m_parm.emtek_id} = {?Pm-r_adt_core.emtek_id} and IsNull ({c_str_m_parm.changed_date}) and {c_str_m_parm.object_name} like...

This is a question that I'm sure has been asked a lot, but I'm having trouble with this. From a medical record I need the oldest entry date out of multiple entry dates. I select from {c_str_m_parm.entered_at} I appreciate the help.

I have a surgery schedule. The way it prints right now is like this: 0700 Dr. Joe Blow Jane Doe Tonsillectomy 0800 Dr. Joe Blow John Doe Vasectomy --------------------------------------------------------- 0700 Dr. Howdy Doody Jane Doe Face Lift 0745 Dr...

I need a little help with calculating some percentages. I have, for example, 156 patients. They all have charted when they are discharged and where they go. For example, Home, Nursing Home, Home Health, etc. I need to calculate the percentage of pts. that went home, patients the went to a...

I work for a hospital writing reports from our clinical system. Here's my problem...I am gathering data on single patients that include their MD's name. The MD's are classified by their type ie., Admitting, Attending and Consulting. They may be all of these, two of these, are only one of...

Yes there will always be a decimal point. The precision is always 2.

Thank you very much, that seems to work. I did leave off the "mg" because that's in another field. However, another question: We are unsure the number of significant digits after the decimal. For example, we my have 50.50 or 50.55. When printing we are wanting to show 50.5 or 50.55. (The...

I work in healthcare and we are having a trailing zero problem. I need to remove the decimal point and the zeros from a medication dose strength (dose_str). I need 500 MG instead of 500.00 mg. But if there is a dose that's 500.25 then I need that to remain. The 500.00 is a string. Let me...

Rec Therapy Intervention: SUBJECTIVE: (TEXT)if any OBJECTIVE: (TEXT) LEVEL OF PARTICIPATION/SOCIALIZATION: (TEXT) FIM Score: (#) Pt. Transferred 4 PLAN: (TEXT)

I'm needing to start a new line after each colon that comes after the words in all caps in this group of notes. I use CR 10. Thanks. Rec Therapy Intervention: SUBJECTIVE: OBJECTIVE: Activity: Special music Lunch bunch Time: 60 min LEVEL OF PARTICIPATION/SOCIALIZATION: Appropriate Responds to...

I schedule my reports through Crystal Decisions. I put "print date" on the reports. One report prints a date of 7/30/1999. All the others are correct with today's date. Any suggestions? I can't seem to figure this one out.

Thanks for your response. I tried {c_text_parm.time_for} = maximum({c_text_parm.time_for}) and I get an error that says "This function cannot be used because it must be evaluated later" Entry time can either be c_text_parm.entered_at or c_text_parm.time for. Each chart will vary. Everyone...

This is a subreport that is showing entries in a patient's chart. I want only the last entry which is a text_parm determined by the last entry time. {c_text_parm.emtek_id} = {?Pm r_adt_core.emtek_id} and isnull ({c_text_parm.changed_date}) and {c_text_parm.object_name} like 'C_NEWGU3' and not...

I want to only show the last date an entry was made in my report. There are multiple date entrys but only the last entry needs to be on my report.

Is there a way to do a random data selection? I want to run data from a certain month but want it do search randomly for, let's say, 10 records.

I work in a hosptial setting and what I'm trying to do is calculate the number of admissions for a certain month. I also want this number to not include certain zones. Right now I am calculating the number of total admissions for the history of this facility. The main report pulls data from a...