Notifications
Clear all
Topic starter
I'm trying to pull a report from CPS 12 with a list of patients who do now have a picture loaded under registration through Crystal Reports. There's a "picture" field under the vPatientProfile table, but when I run the report nothing is returned to indicate whether the field is blank or has a picture stored there.
Any suggestions would be greatly appreciated!
Thanks,
Natalie
Posted : June 28, 2016 7:52 am
The base table is PatientProfile. Write a query where PatientProfile.Picture value is Not Is Null.
SELECT PatientProfile.Last, PatientProfile.First, PatientProfile.PatientId, PatientProfile.Picture
FROM PatientProfile
WHERE Not PatientProfile.Picture Is Null
ORDER BY PatientProfile.Last, PatientProfile.First;
Posted : June 28, 2016 8:19 am
Topic starter
Thank you! I was able to pull the list with your query! Much appreciated!
Posted : June 28, 2016 9:53 am
