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>

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

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

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

Jana Vakati

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

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.