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(url_start)# and
#createODBCdate(url_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(url_start)# and
#createODBCdate(url_end)# and e.Agency_ID = #session.AgencyID# order by es.EventSub_ID
Incident statistics detail
Incident Statistics Detail
From : #Dateformat(url_start,'mm/dd/yyyy')# To : #Dateformat(url_end,'mm/dd/yyyy')#
#Subject# No of Incidents :
#count#
Date
Patient Name
Resolved?
#dateformat(Event_Date,"mm/dd/yyyy")#
#LastName# #FirstName#
#Resolved#
Page : #cfdocument.currentpagenumber# of #cfdocument.totalpagecount#