FishKiller
IS-IT--Management
I need help with distinct counting or something like it. I have a sql2000 view pulling data into crystal report 9 latest sp. The data is a list of examdate,examid,patientid,resourceid
I currently have it grouped by examdate > resource > patientid then the details is the exam id.
I need to perform a total "special exam" count.
EX: Date=10/11/2005
Resource=R1
PatientID=1
details= 78813
78816CTW
PatientID=2
details= 78813
PatientID=3
details= 78816CT
78813
All three have 78813 in the result this should be labeled and counted as "1- PET"
the first one listed is "78813 and "78816CTW" which should be labeled as "1- PETCTW"
Patientid-3 is showing "78816CT and "78813" which should be labeled as "1- PETCT"
The total returned would look like this
PET PETCT PETCTW
1 1 1
Please help
I currently have it grouped by examdate > resource > patientid then the details is the exam id.
I need to perform a total "special exam" count.
EX: Date=10/11/2005
Resource=R1
PatientID=1
details= 78813
78816CTW
PatientID=2
details= 78813
PatientID=3
details= 78816CT
78813
All three have 78813 in the result this should be labeled and counted as "1- PET"
the first one listed is "78813 and "78816CTW" which should be labeled as "1- PETCTW"
Patientid-3 is showing "78816CT and "78813" which should be labeled as "1- PETCT"
The total returned would look like this
PET PETCT PETCTW
1 1 1
Please help