2 Replies Latest reply on Jun 6, 2017 8:42 PM by Venkat Thota - BIP

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

    Dhanuka Chamal

      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