Provider Billing Report (Ontario Billing v1)

<report  title="Provider Billing Report" description="Reports billing data for a provider -(Ontario Billing v1)" active="1">
   <query>
  select demographic_no as No, demographic_name as 'Demographic Name', bd.service_code as 'Service Code', 
  bd.service_desc as 'Service Desc', bd.diagnostic_code as 'diag. Code', bd.billingunit as 'Billing Unit', 
  b.billing_date as 'Billing Date' 
  
  from billing b, billingdetail bd 
  
  where b.provider_no = {provider_no} and b.billing_no = bd.billing_no 
  and b.status <> 'D' 
  and b.billing_date >='{billing_date_start}' and b.billing_date <='{billing_date_end}'
  
  </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>
   <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>