crmrto wrote on Thursday, April 12, 2012:
Good Morning all!!!
Does anyone know how to print a list of all current clients???
thank for the input guys!
tmccormi wrote on Thursday, April 12, 2012:
There is no report for that specifically. Currently patient lists are tied to visits and other activities. If you have admin access you can use a phpMyAdmin browse and create a export or PDF report of the desired fields.
A query like this can be done by using the Search tab, and selecting just the fields you want from the top left. It will produce and SQL statement like:
SELECT `fname` , `lname` , `mname` , `DOB` , `street` , `postal_code` , `city` , `state` , `phone_home` , `phone_biz` , `sex` , `pubpid` , `pid`
FROM `patient_data`
And display and nice table, then you can select ‘Print View’ to get a pretty nice report.
The better the SQL the better the report …
-Tony
crmrto wrote on Thursday, April 12, 2012:
perfect just what i needed thank you!