Billing Report by Service Codes (Ontario Billing v1)

<report  title="Billing Report by Service Codes" description="Billing Report by Service Codes (Ontario Billing v1)" active="1">
   <query>select b.billing_date as 'Billing Date', d.last_name as 'Last Name', d.first_name as 'First Name', service_code as 'Service Code', 
   service_desc as 'Service Desc', billingunit as 'Billing Unit', diagnostic_code as 'Diag Code', b.status as 'Status', bd.status as 'Detail Status' 
   from billingdetail bd, billing b, demographic d 
   where b.status != 'D' and bd.status != 'D' 
   and service_code in ('{service_code}') 
   and b.billing_no = bd.billing_no 
   and b.billing_date >='{billing_date_start}' and b.billing_date <='{billing_date_end}' 
   and b.demographic_no = d.demographic_no 
   order by d.last_name, billing_date;</query>
   <param id="service_code" type="textlist" description="A list of service codes">
   </param>
   <param id="billing_date_start" type="date" description="Billing date start">
   </param>
   <param id="billing_date_end" type="date" description="Billing date end">
   </param>
</report>