You are here: BI Publisher BI Publisher How to re-group XML data in RTF Template

How to re-group XML data in RTF Template

Rate this item
(2 votes)

 If we need the grouping, it is always advisable to generate the XML as per the required hierarchy. This makes the RTF design simple and perform better.  But there are situation when we do not have control over XML structure and need to work on flat XML.  Lets see how we can create multiple nested grouping in RTF template.

I am using  following simple flat XML which is generated using scott.emp and scott.dept table.

Lets first design the simple table with default group

It generates simple listing report.

 

Lest add a group based on Depno. This is achieved by adding following loop

  <?for-each-group:ROW;./DEPTNO?>  --- <?end for-each?> and iterate the detail record within the current group.

This introduce the Dept Group ..
Let’s add another nested group for Job within the department group.
Hope this will help to design those nasty nested groups based on flat XML date.
Need help on RTF template design or BI Publisher implementation, please contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it
Read 22185 times

3 comments

  • Comment Link Sheik Tuesday, 06 November 2012 09:01 posted by Sheik

    Good expalnation with example
    Thanks

    Report
  • Comment Link srk Friday, 19 October 2012 15:38 posted by srk

    How would you go about lets say... only showing a job row if it were a certain job or even better not a duplicate job using this scenario?

    Report
  • Comment Link venkat Wednesday, 19 September 2012 12:32 posted by venkat

    good explanation.....very easy to understand....more useful....

    Thanks.......

    Report

Leave a comment

Make sure you enter the (*) required information where indicated.
Basic HTML code is allowed.