Get horizontal total and vertical totals of Matrix Report in XML Publisher

Dhanuka Chamal

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

Srikkanthmani

Hi,

Hope you are working with cross tab matrix report, if correct only three columns should be in your query. Then only you can able to get the expected result.

Here with  I have attached the sample report for your reference.

Thanks & Regards

Srikkanth M

Venkat Thota - BIP

Reference Never name it.: Cross tab Summation in RTF