Oracle Analytics and AI

Vivek Tiwari

Summary

How we can show Upper form Fields Value in Detail tab Table for Custom Print Report

Content

In Oracle BI Custom Print report we have requirement to show one data element of Upper form against all line items in detail tab . Currently upper form field value shows blank in the table of details tab in Custom Print Report.  So How we can show Upper form Fields Value in Detail tab Table for Custom Print Report?

Regards

Vivek

Brajesh Shukla-95078

you need to use "../" (dot dot forward slash) to access one level up parent data.

e.g.

<HEADER>

  <NAME> ABC </ABC>

  <DETAIL>

       <ITEM> XXX </ITEM>

</DETAIL>

<DETAIL>

       <ITEM> YYY </ITEM>

</DETAIL>

<DETAIL>

       <ITEM> ZZZ </ITEM>

</DETAIL>

</HEADER>

Now from the above example if you are inside DETAIL and want to print NAME from the HEADER then you need to use <?../NAME?>

<?for-each:Detail?> <?../NAME?> <?ITEM?> <?end for-each?>

Similarly if you have two level  up then ../../NAME

Regards,

BS