Drug Use Report

<report  title="Drug Report" description="Reports patients by prescribed drug name and rx_date" active="1">
   <query>
   	select dr.demographic_no, dr.BN, de.last_name, de.first_name, de.provider_no 
   	from drugs dr, demographic de 
   	where dr.demographic_no = de.demographic_no and ( BN like '%{drugname}%') and rx_date > {rx_date} order by provider_no, last_name;
   </query>
   <param id="drugname" type="text" description="Drugname keyword">
   </param>
   <param id="rx_date" type="date" description="Rx Date (From date)">
   </param>
</report>