Oracle APEX Tutorial 3 – Drilldown Report Part 2- Video Training

kevin.landonTechnical Tips2 Comments


This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a Drilldown Report. It is recommended that you review our APEX Tutorial Preparation and OEHR Sample Data Installation article if you do not have the OEHR sample data installed to your APEX installation. This section picks up after the first section ends.

Part 2 – Creating Order Items Report. Linking the reports together.


High Level Steps

1) Create and Test Order Item Report (0:38)
2) Create Item (2:58)
3) Link the Reports together (4:11)
4) Test Application (8:41)

Times in parenthesis are approximate start times for that step.

Notes and Resources.

Order of Creation

In this tutorial, and it’s second part, there are times when the order we create things may seem a bit contradictory to the end desired result. This is because in order for many of the automation and wizard-ed functions to work properly, it is necessary to create all the basic building blocks first, then re-arrange them and alter them to fit as originally desired.

Date / Number Formats

This tutorial employs altering the displayed format of some columns into more human readable form. This is for end human readability. For dates the format is fairly straightforward, however for some number types, the system employs a series of predefined mask and identifier characters to define to the application and the Oracle internals the desired format, which may not be easily understood when you see it in the format selector (In this case, the column to display order total).

Link explained

What we did is fairly simple. In the Order Items report, we designated that the data retrieved will be linked to a hidden item (P2_ORDER_ID). This hidden item is by it’s nature unseen by the user. We then setup the Orders report so that every displayed Order ID is a clickable link, and when clicked, will set the value of the hidden P2_ORDER_ID item to the value of the order ID, and call the Order Items report.

2 Comments on “Oracle APEX Tutorial 3 – Drilldown Report Part 2- Video Training”

  1. Hello,

    Thanks for the tutorial, but I’ve noticed that the link isn’t setup right, there’s something missing, when you click on any order number, it will give you the same results whatever the order number is, or whatever the order total is, and it is also very clear in your video, when you clicked on $309 order, it given you a details with much more value than the $309.


  2. @Mohammed

    You need to keep the join for the order items report between product and order, in addition to the join from order to item.

Leave a Reply

Your email address will not be published. Required fields are marked *