The sql includes the statements:
left join entities loc on loc.entity_id = el.target_id
join entity_details d1 on d1.entity_id = p.entity_id and d1.name = "dateOfBirth"
join entity_details d2 on d2.entity_id = p.entity_id and d2.name = "deceasedDate"
join entity_details d3 on d3.entity_id = p.entity_id and d3.name = "deceased"
The second line above should be a left join rather than a join.
the attached jrxml is the A4 format one and included the fix in OVPMS-1952 Resolved