is it dynamic structure xml or for one Account_Header_S8 you have exactly two Print_Report_2_S6 and Account_Totals_S7 ?
for static structure you can try to use position like "Account_Header_S8"
for dynamic structure IMHO it's not possible or i may be wrong
another way you can try is to transform xml structure
- in program which generate xml
- by xslt
I just verified XML file after seeing your question of number of Print_Report sections.
The XML file begins with Account_Header_s8 and then 8 Print_Report, then 8 Account_Totals again Account_Header like this till the end of file. The number of Print_Report can vary some times 4 or 1, but the Account_Totals sections will be same number as Print_Report. Hope I explained it better now. The XML file is generated from JDE Report dynamically. Below is the example.
The XML file is generated from JDE Report dynamically.
can you change logic of forming xml?
you can try xslt http://docs.oracle.com/cd/E23549_01/bi.1111/e13881/T527073T558978.htm
- change parent tag Account_Header_S8, Print_Report_2_S6, Account_Totals_S7 to be the same as "parentnode"
- change all child nodes as nodes1, nodes2, nodes3
then you can use for-each as is
and it print sequentially as in xml with xslt
yes - We can change the JDE report to form the required XML structure. But this will become habit to change the JDE report every time. Idea is to get the required output as I mentioned with existing xml structure.