<report title="Provider Email Report" description="Reports Patients with an email address" active="1">
<query>
select last_name,first_name,phone,phone2, email , concat(year_of_birth,'-',month_of_birth,'-',date_of_birth)
from demographic where email like '%@%' and provider_no = {provider_no} and patient_status = 'AC'
</query>
<param id="provider_no" type="list" description="Provider Number">
<param-query>select provider_no, CONCAT(last_name, ', ', first_name, ' (', provider_no, ')') from provider order by last_name;</param-query>
</param>
</report>
