group and subgroup----Seeking Help
Hi, I have an XML doc and I have written a stylesheet to render it to pdf using fop. The stylesheets sums the total before the end of the page but the GROUPING is not achieved. I am
Here's my xml :
<ResultSet>
<row>
<LOB_NM><![CDATA[Commercial]]></LOB_NM>
<PIPELINE_NAME>GCI Profit Rpt</PIPELINE_NAME>
<ID><![CDATA[45]]></ID>
<PID><![CDATA[11]]></PID>
</row>
<row>
<LOB_NM>CIB</LOB_NM>
<PIPELINE_NAME>Marketing</PIPELINE_NAME>
<PID><![CDATA[10]]></PID>
</row>
<row>
<LOB_NM>CIB</LOB_NM>
<PIPELINE_NAME>golf</PIPELINE_NAME>
<ID><![CDATA[12]]></ID>
<PID><![CDATA[23]]></PID>
</row>
<row>
<LOB_NM>CIB</LOB_NM>
<PIPELINE_NAME>ss1</PIPELINE_NAME>
<ID><![CDATA[12]]></ID>
<PID><![CDATA[12]]></PID>
</row>
<row>
<LOB_NM>Commercial</LOB_NM>
<PIPELINE_NAME>Industry Focus</PIPELINE_NAME>
<ID><![CDATA[10]]></ID>
<PID><![CDATA[25]]></PID>
</row>
</ResultSet>
This is the way I want my final output to appear :
CIB Marketing Contact 10
CIB golf 12 23
CIB ss1 12 12
____________________________________________
CIB Totals 24 45
--Page Break
Commercial GCI Profit Rpt 45 11
Commercial Industry Focus 10 25
____________________________________________
Commecial Totals 55 36
--Page Break
Any help would be appreciated....Any link or example to do the same newbie style would be appreciated.
Thanks
Shon
|