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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.