Incident Statistics Detail
to
Date Format: mm/dd/yyyy
Incident Statistics Detail
select count(es.Subject) as count from #Request.prefix_db_agency#.Event e join #Request.prefix_db_agency#.EventSubjects es on e.EventSub_ID = es.EventSub_ID join #Request.prefix_db_agency#.patient p on p.Patient_ID = e.Patient_ID where e.Event_Date between #createODBCdate(form.date)# and #createODBCdate(form.end)# and e.Agency_ID = #session.AgencyID# group by es.EventSub_ID order by es.EventSub_ID select es.EventSub_ID,es.Subject,e.Event_Date,e.Patient_ID, p.Last_Name_M0040 as LastName,p.First_Name_M0040 as FirstName, p.Middle_Initial_M0040 as MiddleName,e.Memo,e.Followup_Memo,e.Resolved from #Request.prefix_db_agency#.Event e join #Request.prefix_db_agency#.EventSubjects es on e.EventSub_ID = es.EventSub_ID join #Request.prefix_db_agency#.patient p on p.Patient_ID = e.Patient_ID where e.Event_Date between #createODBCdate(form.date)# and #createODBCdate(form.end)# and e.Agency_ID = #session.AgencyID# order by es.EventSub_ID Print Incident Statistics Detail

#Subject# No of Incidents : #count#

Date Patient Name Memo FU Memo Resolved?
#dateformat(Event_Date,"mm/dd/yyyy")# #LastName# #FirstName# #lcase(Memo)# #lcase(Followup_Memo)# #Resolved#

No Records were found , Try to different Dates

Back