8 Replies Latest reply: Jun 16, 2014 10:06 AM by KP1 RSS

    RTF Template with nested groups in PDF

    user11972592

      Hi All,

      I am trying to build a layout template in MS Word for a PDF output. Below is the Data layout XML and expected report output.

       

      Data XML:

      <l_org>

        <org>

        <orgname>org1</orgname>

        <l_dep>

        <dep>

        <dname>dep1</dname>

        <l_item>

        <item>

        <iname>item1</iname>

        <quantity>1</quantity>

        </item>

        </l_item>

        </dep>

        <dep>

        <dname>dep2</dname>

        <l_item>

        <item>

        <iname>item2</iname>

        <quantity>1</quantity>

        </item>

        <item>

        <iname>item2</iname>

        <quantity>1</quantity>

        </item>

        </l_item>

        </dep>

        </l_dep>

        </org>

      </l_org>

       

      Expected Output:

      Org     Dep     Item     Quantity

      ----------------------------------------------

      Org1    Dep1    Item1       1

      Org1    Dep2    Item2       2

       

      So as you can see from the above output, I am trying to Group By three levels: Org, Dep and Item. The last column should show the total quantity in that particular row (org/dep/item)

       

      I have tried to use for-each-group at three levels but I am unable to get a single table output. Can someone help me with the layout template.