Summary Data Grouped For Each Product Content Hello, I am using XML Publisher (RTF) report, MS Word BI Publisher plugin I would like to have the output as shown in the enclosed screen shot, but I am not sure how to put for-each when I put for-each at the top, Product Number is getting repeated for all the details. Appreciate any help. Sample XML is included at the bottom PR_5000 TP_GAS_SOCKET LOC_SOUTH_US US_ 10 Sockets PI_10000 Sub_Type 10.1 Inch 10 PI_10000 Sub_Type 10.2 Size 10 PR_5000 TP_GAS_SOCKET LOC_SOUTH_US US_ 20 Socket Details PI_10000 Sub_Type 20.1 Supp 20 PI_10000 Sub_Type 20.2 Address 20 PI_10000 PR_5000 TP_GAS_SOCKET LOC_SOUTH_US US_ 30 Details PI_10000 Sub_Type 30.1 Street 30 PI_10000 Sub_Type 30.2 Phone 30 PR_6000 TP_GAS_CYLINDER LOC_NORTH_US US_ 10 GAS PI_12000 Sub_Type 10.01 Gas Chamber 10 PI_12000 Sub_Type 10.02 Gas Type 10 PI_12000 Sub_Type 10.03 No. of cylinder 10

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Data Grouped For Each Product

Jacobelia S

Summary

Data Grouped For Each Product

Content

Hello,

I am using XML Publisher (RTF) report, MS Word BI Publisher plugin

I would like to have the output as shown in the enclosed screen shot, but I am not sure how to put for-each when I put for-each at the top, Product Number is getting repeated for all the details.

Appreciate any help.

Sample XML is included at the bottom

<?xml version="1.0" encoding="UTF-8" ?> <XTEST><LIST_G_PROD_HDR><G_PROD_HDR><PROD_NUMBER>PR_5000</PROD_NUMBER> <PROD_DESCRIPTION>TP_GAS_SOCKET</PROD_DESCRIPTION> <PROD_LOCATION>LOC_SOUTH_US</PROD_LOCATION> <PROD_WAREHOUSE>US_</PROD_WAREHOUSE> <PROD_SEQ_NUM>10</PROD_SEQ_NUM> <PROD_MAST_NAME>Sockets</PROD_MAST_NAME> <MAST_SEQ_NUM /> <LIST_G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_10000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>10.1</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Inch</PROD_MAST_NAME> <MAST_SEQ_NUM>10</MAST_SEQ_NUM> </G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_10000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>10.2</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Size</PROD_MAST_NAME> <MAST_SEQ_NUM>10</MAST_SEQ_NUM> </G_PROD_DTL></LIST_G_PROD_DTL></G_PROD_HDR><G_PROD_HDR><PROD_ID /> <PROD_NUMBER>PR_5000</PROD_NUMBER> <PROD_DESCRIPTION>TP_GAS_SOCKET</PROD_DESCRIPTION> <PROD_LOCATION>LOC_SOUTH_US</PROD_LOCATION> <PROD_WAREHOUSE>US_</PROD_WAREHOUSE> <PROD_SEQ_NUM>20</PROD_SEQ_NUM> <PROD_MAST_NAME>Socket Details</PROD_MAST_NAME> <MAST_SEQ_NUM /> <LIST_G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_10000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>20.1</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Supp</PROD_MAST_NAME> <MAST_SEQ_NUM>20</MAST_SEQ_NUM> </G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_10000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>20.2</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Address</PROD_MAST_NAME> <MAST_SEQ_NUM>20</MAST_SEQ_NUM> </G_PROD_DTL></LIST_G_PROD_DTL></G_PROD_HDR><G_PROD_HDR><PROD_ID>PI_10000</PROD_ID> <PROD_NUMBER>PR_5000</PROD_NUMBER> <PROD_DESCRIPTION>TP_GAS_SOCKET</PROD_DESCRIPTION> <PROD_LOCATION>LOC_SOUTH_US</PROD_LOCATION> <PROD_WAREHOUSE>US_</PROD_WAREHOUSE> <PROD_SEQ_NUM>30</PROD_SEQ_NUM> <PROD_MAST_NAME>Details</PROD_MAST_NAME> <MAST_SEQ_NUM /> <LIST_G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_10000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>30.1</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Street</PROD_MAST_NAME> <MAST_SEQ_NUM>30</MAST_SEQ_NUM> </G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_10000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>30.2</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Phone</PROD_MAST_NAME> <MAST_SEQ_NUM>30</MAST_SEQ_NUM> </G_PROD_DTL></LIST_G_PROD_DTL></G_PROD_HDR><G_PROD_HDR><PROD_NUMBER>PR_6000</PROD_NUMBER> <PROD_DESCRIPTION>TP_GAS_CYLINDER</PROD_DESCRIPTION> <PROD_LOCATION>LOC_NORTH_US</PROD_LOCATION> <PROD_WAREHOUSE>US_</PROD_WAREHOUSE> <PROD_SEQ_NUM>10</PROD_SEQ_NUM> <PROD_MAST_NAME>GAS</PROD_MAST_NAME> <MAST_SEQ_NUM /> <LIST_G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_12000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>10.01</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Gas Chamber</PROD_MAST_NAME> <MAST_SEQ_NUM>10</MAST_SEQ_NUM> </G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_12000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>10.02</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>Gas Type</PROD_MAST_NAME> <MAST_SEQ_NUM>10</MAST_SEQ_NUM> </G_PROD_DTL><G_PROD_DTL><PROD_ID>PI_12000</PROD_ID> <PROD_TYPE>Sub_Type</PROD_TYPE> <SUBMENU_SEQ_NUM>10.03</SUBMENU_SEQ_NUM> <PROD_MAST_NAME>No. of cylinder</PROD_MAST_NAME> <MAST_SEQ_NUM>10</MAST_SEQ_NUM> </G_PROD_DTL></LIST_G_PROD_DTL></G_PROD_HDR></LIST_G_PROD_HDR></XTEST>

Find more posts tagged with

Accepted answers

All comments

Jana Vakati

Hi Chacks,

After checking the xml and output.

some changes are required in the grouping please find xml and rtf file uploaded.change groups as mentioned.

Please find sample output also.

Regards

Jana

Brajesh Shukla-95078

Hi,

You can design your rtf as below. Let me know if you face any issue

Jacobelia S

Hi,

Can you try accessing from https://www.dropbox.com/s/5kv6ewqlsmzmp1o/Files%20%281%29.zip?dl=0

Regards

Jana Vakati

please attach data template here i am not able to open it .

Jacobelia S

Excuse me for my ignorance, I am unable to find an option to attach files.

I could email you the files as an option.

Jacobelia S

Hi,

Thanks for the detailed replies with the files and the output.

I have a question regarding the generated XML, my data definition is not generating the output as you had generated and to be honest I am not sure how to change my data definition to generate the expected XML output.

I have attached my data definition XML and sample data, would you suggest what modifications I need to make in the data definition?

Files

Regards

Brajesh Shukla-95078

Once you install BI Publisher Desktop it comes with sample template where you can find out all the basic examples and also it provide User guide for more details

Brajesh Shukla-95078

I think your requirement is to group the data based on G_PROD_HDR and PROD_NUMBER, you can create dynamic group in rtf for PROD_NUMBER as below to achieve your requirement.

Jacobelia S

Brajesh,

Would you suggest good articles, tutorials and suchlike for these kinds of BI Reports (XML Publisher)?

Jacobelia S

The issue has been resolved, thanks for the help, much appreciated.