Measurement values (yes/no)
Report on measurement values with (yes/no) values
<report title="Measurement values (yes/no)" description="Measurement values (yes/no)" active="1">
<query>
select last_name,first_name,concat(date_of_birth,'-',month_of_birth,'-',year_of_birth) as DOB, dataField from measurements,demographic where measurements.demographicNo = demographic.demographic_no and type = '{type}' and dataField like '{keyvals}%';
</query>
<param id="type" type="list" description="Measurement Type">
<param-query>select distinct type,typeDisplayName from measurementType where validation =7;</param-query>
</param>
<param id="keyvals" type="list" description="Key Value">
<choice id="y">Yes</choice>
<choice id="n">No</choice>
<choice id="%">Nonset</choice>
</param>
</report>