Summary
Get horizontal total and vertical totals of Matrix Report in XML Publisher
Content
I need to print horizontal total and vertical totals. Could you please let me know how to print the report in the above format. My XML data is in below format; My output format is something like this;
ITEM | DATE | TOTAL |
ITEM_CODE | QTY | HORIZONTAL_TOTAL |
TOTAL | VERTICAL_TOTAL | |
<XXSLC_LAUND_DEL_DETL>
<LIST_G_SHIP_DATE1>
<G_SHIP_DATE1>
<MONTH_DATE>01-MAR-17</MONTH_DATE>
<ITEM_DESCRIPTION>Bath mat</ITEM_DESCRIPTION>
<ITEM>LL0004</ITEM>
<QTY>387</QTY>
</G_SHIP_DATE1>
<G_SHIP_DATE1>
<MONTH_DATE>01-MAR-17</MONTH_DATE>
<ITEM_DESCRIPTION>Bath robe</ITEM_DESCRIPTION>
<ITEM>LL0006</ITEM>
<QTY>37</QTY>
</G_SHIP_DATE1>
<G_SHIP_DATE1>
<MONTH_DATE>01-MAR-17</MONTH_DATE>
<ITEM_DESCRIPTION>Bath towel</ITEM_DESCRIPTION>
<ITEM>LL0008</ITEM>
<QTY>618</QTY>
</G_SHIP_DATE1>
</LIST_G_SHIP_DATE1>
</XXSLC_LAUND_DEL_DETL>
Regards,
dcr
