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!

  • Congratulations bkrike 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: *

  • Users: v45
  • Content: Threads
  • Order by date
  1. v45

    Supress Using Next(), Last Row Missing

    Using Crystal Reports XI. A report without groups, using the Suppress (No Drill-Down) formula of: {Patient_Clin_Tran.clinical_transaction_no} = NEXT({Patient_Clin_Tran.clinical_transaction_no}) In the Section Expert box, when the suppress checkbox is checked, the last detail row is...
  2. v45

    Selecting Off-Hours System Access

    In Crystal 8.5, I'm trying to select records for off-hours system access. The tables have a login date/time field. The report needs to run from the current date, usually Monday, and include the previous week's access for after 5:00 p.m. until 8:00 a.m. Monday thru Friday and all weekend. I'm...
  3. v45

    User Selected Columns

    I'm trying to do a report that will allow the user to select the columns they want to see in the report. For example, out of 20 fields in the table, the user can select 6 to be listed. I've created parameters for each of the fields, but can seem to find a way to get them to display after the...
  4. v45

    Select based on Missing Field Value

    I need to develop a report where patients are listed that do not have a treatment plan developed. I have put together a report that lists patients based on intake date with columns for Patient ID, Episode ID, Name and Completed Documents. Episode is usually the number of times the patient has...
  5. v45

    Users that do not log in

    I have two tables, one that has the user id and other staff info, the second has login info for the user, datetime, workstation, etc. I would like to find out who did not log in last month. Can this be done?

Part and Inventory Search

Back
Top