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

    How to identify first time and last time for same surgeon by date?

    I originally began with Minimum({v_CRA_Billing_01.time_pat_in_room}).. I did not realize one could.. enter a "," to relate it to the surgeon description.. Thank you.. it worked.. You are my Hero! for the day! Rose
  2. arhawley

    How to identify first time and last time for same surgeon by date?

    Joins are good.. This is how I have it currently built.. The report is grouped by surgeon{v_basic_case_rec_data2.surg_descr} and In "GH1" I surgeon showing.. I have under Record Sort Order I have {v_basic_case_rec_data2.cr_prdate} I have this showing under "Da" and here I am displaying the...
  3. arhawley

    How to identify first time and last time for same surgeon by date?

    I am placing min/max in the Group header.. currently I have details also visible with the correct case record in room and out room time for each surgeon visible.. just to be able to validate this formula.. I just cked.. irregardless of where I place the Min/Max.. it shows the same.. Maybe it has...
  4. arhawley

    How to identify first time and last time for same surgeon by date?

    fisheromacse I am using Crystal 9.2.2.634 Standard.. I am unable to use the SQL but thank you
  5. arhawley

    How to identify first time and last time for same surgeon by date?

    DJWW the time pulls as a text field.. I have the work around for the times and calculating the difference.. I have the rpt grouped by Surgeon.. Sorry should have mentioned this.. however when I pull the min and max in.. however it does not filter for just that particular surgeon.. it pulls...
  6. arhawley

    How to identify first time and last time for same surgeon by date?

    I am attempting to write a report which requires the ability to identify a surgeon's {v_basic_case_rec_data2.surg_descr} first in room time {v_CRA_Billing_01.time_pat_in_room} and last room out time {v_CRA_Billing_01.time_pat_out_of_room}.. A surgeon can have multiple pat in room times and out...

Part and Inventory Search

Back
Top