Let's say your BIP'ing AR Statements and so you have something like this XML (fragment):
<ARXSGPO_CPG> <LIST_G_SETUP> <G_SETUP> <COMPANY_NAME>Vision Operations (USA)</COMPANY_NAME> <COA_ID>101</COA_ID> <FUNCTIONAL_CURRENCY>USD</FUNCTIONAL_CURRENCY> <FUNCTIONAL_CURRENCY_PRECI>2</FUNCTIONAL_CURRENCY_PRECI> <LIST_G_STATEMENT> <G_STATEMENT> <SEND_CUSTOMER_NAME>My Valued Customer</SEND_CUSTOMER_NAME> <STATEMENT_DATE>25-JAN-02</STATEMENT_DATE> <BUCKET1_HEADING>Current</BUCKET1_HEADING> <BUCKET2_HEADING>1-30 Days</BUCKET2_HEADING> <BUCKET3_HEADING>31-60 Days</BUCKET3_HEADING> <BUCKET4_HEADING>61-90 Days</BUCKET4_HEADING> <BUCKET5_HEADING>Over 90 Days</BUCKET5_HEADING> <BUCKET1>379431.9</BUCKET1> <BUCKET2>267494.31</BUCKET2> <BUCKET3>0</BUCKET3> <BUCKET4>0</BUCKET4> <BUCKET5>130291.76</BUCKET5> ...And in your template you "group" and "section" the statement:
<?for-each@section:G_STATEMENT?> <?SEND_CUSTOMER_NAME?> <?end for-each?>And you want to refer to the element <?COMPANY_NAME?> in the Header section, but if you put <?COMPANY_NAME?> then it doesn't appear (is null).
Why? When you section on G_STATEMENT then that becomes the "base" level, so you need to go back up the XML tree to get to your Parameter / Company Name etc.
In this case you'd need to put
<?../../COMPANY_NAME?>in your Header section. I.e. the parent (G_SETUP) of the parent (LIST_G_STATEMENT) of the current group (G_STATEMENT).
Update:Alternatively you can use xpath from the root node, in this case you could use
<?/ARXSGPO_CPG/LIST_G_SETUP/G_SETUP/COMPANY_NAME?>in your Header section.
No comments:
Post a Comment