Billings (amounts) over a period of time by provider (BC billing)
Report by Template. Select the dates, the provider and this report gives you the amounts between the dates (by date). Export to spreadsheet and you can easily get totals.
<report title="Provider billing amounts" description="Billings (amounts) over a period of time by provider " active="1">
<query>
select b.provider_no, b.billing_date, b.demographic_name,bm.billing_code,bm.bill_amount
from billing b, billingmaster bm where b.provider_no = '{provider}' and
b.billing_no = bm.billing_no and b.billing_date >= '{start}' and
b.billing_date <= '{finish}' order by b.billing_date
</query>
<param id="start" type="date" description="Start date"> </param>
<param id="finish" type="date" description="Finish date"> </param>
<param id="provider" 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>
