Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Oracle EBS: XML Publisher Master Detail (Drill Down) Reports

Can you create a PDF document that shows a summary on the first page and provides links to more detailed sections further down in the document?

Oracle BI Publisher reports





1) TopLink


Just think of it as an anchor to the top of the page called doctop

Back to Top



Back to Top
Just a live link 'Back to Top' it takes the user to the doc top location i.e. to the top of the page.

DeptLink


Just like the TopLink above, this just creates an anchor in the document. The neat thing here is that we dynamically name it the actual value of the DEPARTMENT_NAME. Note that this link is inside the for-each:G_DEPT loop so the {DEPARTMENT_NAME} is evaluated each time the loop iterates. The curly braces force the engine to fetch the DEPARTMENT_NAME value before creating the anchor.

DEPARTMENT_NAME



This is the link for the user to be able to navigate to the detail for particular dept 

You can add a dynamic link on to anything in the summary section. You just need to remember to keep link 'names' as unique as needed for source and destination. You can combine multiple data values into the link name using the concact function.



This post first appeared on EBiz Integration Technics, please read the originial post: here

Share the post

Oracle EBS: XML Publisher Master Detail (Drill Down) Reports

×

Subscribe to Ebiz Integration Technics

Get updates delivered right to your inbox!

Thank you for your subscription

×