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

    Limiting # of entries returned

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

    Selecting Time

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

    Selecting Time

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

    Oldest Record

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

    Oldest Record

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

    Formula

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

    Percentage

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

    Easy Grouping Question

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

    Trailing Zeros

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

    Trailing Zeros

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

    Trailing Zeros

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

    New Line

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

    New Line

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

    Wrong Date

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

    Showing only the last entry

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

    Showing only the last entry

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

    Selecting Last Date

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

    Random Data Selection

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

    Calculating a Total within a Time Frame

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

Part and Inventory Search

Back
Top