Notifications
Clear all
Topic starter
Is there an easy way to display a field for just the last appt in one of my reports? Hopefully also for only certain providers (PCPs). We share charts so the appts are all mixed together.
Posted : April 30, 2013 10:21 pm
Last Appt? As in Last Appt which was arrived?
You could use the rptappt view, and filter for apptstatus = 2 (arrived).
Then, take the 'max' of this field for each patient.
Now, if you only want to see for a specific resource...? Have to link to book and userinfo table/view files to only use them.
Make a variable, maybe LastApptSpecial
if rptappt.apptstatus =2 and userinfo.lastname in ["Smith", "Jones"]
then rptappt.apptdate
Place that variable LastApptSpecial on your detail line, and summarize (maximum) to a group level of unique-patient (either name, MRN, combination of the two, etc...)
Posted : May 8, 2013 12:12 am
Topic starter
I was finally able to do this with your suggestions. I made a PID group like you said and moved everything to the group header and added a max rptappt date summary there. I had already added the info for the arrived status and certain book LOCs in select expert so I was all set there. Thank you very much.
Posted : May 8, 2013 2:22 am
