Report Patients with an email address

<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>