Hi all,
XML file snippet
<ROOT>
<item>
<CAHReportID>140</CAHRepor
tID>
<ParentCAHReportID>100</Pa
rentCAHRep
ortID>
<ReportCaptionEN>Key Statistics</ReportCaptionE
N>
<ReportYearID>2008</Report
YearID>
<ReportValueText>--</Repor
tValueText
>
</item>
<item>
<CAHReportID>140</CAHRepor
tID>
<ParentCAHReportID>100</Pa
rentCAHRep
ortID>
<ReportCaptionEN>Key Statistics</ReportCaptionE
N>
<ReportYearID>2007</Report
YearID>
<ReportValueText>--</Repor
tValueText
>
</item>
<item>
<CAHReportID>140</CAHRepor
tID>
<ParentCAHReportID>100</Pa
rentCAHRep
ortID>
<ReportCaptionEN>Key Statistics</ReportCaptionE
N>
<ReportYearID>2006</Report
YearID>
<ReportValueText>--</Repor
tValueText
>
</item>
'
'
'
' X number of items
</ROOT>
I want to generate following html:
<tr>
<td>ReportYearID(2008) ReportCaptionEN : ReportValueText</td>
<td>ReportYearID(2007) ReportCaptionEN : ReportValueText</td>
<td>ReportYearID(2006) ReportCaptionEN : ReportValueText</td>
</tr>
where ParentCAHReportID = 100
Thanks,
Start Free Trial