<p>Hi,</p><p> </p><p>I am new to Birt and looking to create a xml hierarchy based report for patients</p><p>Want the report to look like this:</p><p> </p><p>Full Name</p><p>Last Name</p><p>First Name</p><p>DOB</p><p>Gender</p><p> </p><p><All related tests as table entries></p><p> </p><p>This should repeat multiple times depending on how many patient records are in xml.</p><p>Below is sample xml and xsd related to my project. (also attached the same)</p><p> </p><p>My XSD:</p><p> </p><p><?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSPY v5 rel. 4 U (<a data-ipb='nomediaparse' href='
http://www.xmlspy.com'>http://www.xmlspy.com</a>) by Barak Katzir (ItemField) -->
<xs:schema xmlns:xs="<a data-ipb='nomediaparse' href='
http://www.w3.org/2001/XMLSchema'>http://www.w3.org/2001/XMLSchema</a>" elementFormDefault="unqualified" attributeFormDefault="unqualified">
<xs:element name="Patient_Record">
<xs:complexType>
<xs:sequence>
<xs:element name="Full_Name" minOccurs="0"/>
<xs:element name="LastName" type="xs:string"/>
<xs:element name="FirstName" type="xs:string"/>
<xs:element name="DOB" minOccurs="0"/>
<xs:element name="Gender" minOccurs="0"/>
<xs:element name="Test" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="Result" type="xs:string"/>
<xs:element name="Status" type="xs:string"/>
</xs:sequence>
<xs:attribute name="name" type="xs:string"/>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
</p><p>Sample XML:</p><p> </p><p><?xml version="1.0" encoding="windows-1252"?>
<Patient_Record>
<LastName>Jones</LastName>
<FirstName>William</FirstName>
<DOB>19610613</DOB>
<Gender>M</Gender>
<Test name="Na">
<Result>150</Result>
<Status><LS>MSH</LS>
</Status>
</Test>
<Test name="K+">
<Result>4.5</Result>
<Status><LS>^~&amp;</LS>
</Status>
</Test>
<Test name="Cl">
<Result>102</Result>
<Status><LS>PID</LS>
</Status>
</Test>
<Test name="CO2">
<Result>27</Result>
<Status><LS>CDB</LS>
</Status>
</Test>
</Patient_Record>
<Patient_Record>
<LastName>Jone</LastName>
<FirstName>liam</FirstName>
<DOB>19990613</DOB>
<Gender>M</Gender>
<Test name="Na">
<Result>150</Result>
<Status><LS>MSH</LS>
</Status>
</Test>
<Test name="dd">
<Result>4.5</Result>
<Status><LS>^~&amp;</LS>
</Status>
</Test>
<Test name="Cc">
<Result>102</Result>
<Status><LS>PID</LS>
</Status>
</Test>
<Test name="Cgg">
<Result>27</Result>
<Status><LS>CDB</LS>
</Status>
</Test>
</Patient_Record></p><p> </p>
