Provider billing amount - total (BC)
Billing total over a period of time by provider
Billing total over period of time by provider.txt
—
Plain Text,
0Kb
File contents
<report title="Provider billing amount - total" description="Billing total over a period of time by provider" active="1">
<query>
select p.provider_no, p.last_name,p.first_name, round(SUM(bm.bill_amount),2) as 'Amount Billed' from billing b, billingmaster bm , provider p where b.provider_no = p.provider_no and b.billing_no = bm.billing_no and b.billing_date >= '{start}' and b.billing_date <= '{finish}' GROUP BY b.provider_no ;
</query>
<param id="start" type="date" description="Start date"> </param>
<param id="finish" type="date" description="Finish date"> </param>
</report>
