Home » Fusion Middleware & Colab Suite » Business Intelligence » XML Publisher, unable to display from outergroup (5.6)
XML Publisher, unable to display from outergroup [message #533918] Thu, 01 December 2011 12:59 Go to next message
guruindian24
Messages: 4
Registered: December 2011
Junior Member
I am unable to display from outergroup.

<?xml version="1.0" encoding="UTF-8"?>
<!-- Generated by Oracle Reports version 10.1.2.3.0 -->
<XXKKSAMPLE>
<LIST_OUTER1>
<LIST_OUTER2>
<OUTER1>15434257.1</OUTER1>
<OUTER2></OUTER2>
<OUTER3>Jacob</OUTER3>
<OUTER4>XYZ OU </OUTER4>
<OUTER5></OUTER5>
<OUTER6>CAT</OUTER6>
<OUTER7>Cathy</OUTER7>
<OUTER8>XYZ Corp</OUTER8>
<OUTER9>Middleware </OUTER9>
<OUTER10>13823308</OUTER10>
<OUTER11>10000.00</OUTER11>
<OUTER12>JIS</OUTER12>
<OUTER13>04-FEB-2010</OUTER13>
<OUTER14>662</OUTER14>
<OUTER15>21440963//</OUTER15>
<LIST_OUTER3>
<LIST_INNER1>
<INNER1>1</INNER1>
<INNER2>3325</INNER2>
<INNER3>1578</INNER3>
<INNER4>589048</INNER4>
<INNER5>xyz1234</INNER5>
<INNER6>XYZ Inc</INNER6>
<INNER7>10210920</INNER7>
<INNER8>3823308</INNER8>
<INNER9>2</INNER9>
<INNER10>3325</INNER10>
</LIST_INNER1>
<LIST_INNER1>
<INNER1>1</INNER1>
<INNER2>8350</INNER2>
<INNER3>1578</INNER3>
<INNER4>596050</INNER4>
<INNER5>XNMMX6788</INNER5>
<INNER6>abc</INNER6>
<INNER7>I260110-007</INNER7>
<INNER8>3823308</INNER8>
<INNER9>1</INNER9>
<INNER10>8350</INNER10>
</LIST_INNER1>
</LIST_OUTER3>
<CF_X1>GHGD</CF_X1>
<CF_X2></CF_X2>
<CF_X3></CF_X3>
<CF_X4></CF_X4>
<CF_X5>28-MAY-2010</CF_X5>
<CF_X6>3456</CF_X6>
<CF_X7>xvgdtymmsss</CF_X7>
<CF_X8></CF_X8>
<CF_X9></CF_X9>
</LIST_OUTER2>
</LIST_OUTER1>
<CS_ORDER>2</CS_ORDER>
</XXKKSAMPLE>

Output will be in Excel, and should be as below;

Outer7 Outer8 Inner5 Inner6
----------------------------------------------
Cathy XYZ Corp xyz1234 XYZ Inc
Cathy XYZ Corp XNMMX6788 abc

I am using repeating group "LIST_INNER1" and was able to display inner5 and inner6, how can i display outer7, outer8 ????

At Present;

Outer7 Outer8 Inner5 Inner6
----------------------------------------------
xyz1234 XYZ Inc
XNMMX6788 abc

Your help is much appreciated
Re: XML Publisher, unable to display from outergroup [message #534368 is a reply to message #533918] Mon, 05 December 2011 10:23 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
At present how you are displaying?
Try to use the xpath from the beginning.
Like
/XXKKSAMPLE/LIST_OUTER1/LIST_OUTER2/OUTER7

By
Vamsi
Re: XML Publisher, unable to display from outergroup [message #534496 is a reply to message #534368] Tue, 06 December 2011 12:30 Go to previous messageGo to next message
guruindian24
Messages: 4
Registered: December 2011
Junior Member
I am using the same xpath you mentioned, but its displaying the same header information of first order for all the other orders.

[Updated on: Tue, 06 December 2011 12:32]

Report message to a moderator

Re: XML Publisher, unable to display from outergroup [message #534499 is a reply to message #534496] Tue, 06 December 2011 13:21 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I don't have application to test it.
Can you try something like
../XXXXXXXXX
I think [../] should go to outer tag.

By
Vamsi
Previous Topic: Opening XML Report in EXCEL 2007 IN EBS 11i
Next Topic: Import Metadata
Goto Forum:
  


Current Time: Fri Mar 29 08:37:11 CDT 2024