O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing hierarchical reports

The following are the major learning outcomes of this section:

  • Creating hierarchical reports using drilldown links
  • Dynamic messages using substitution variables
  • Creating dynamic breadcrumbs for drill ups
  • Understanding hierarchical queries and creating reports on them
  • Creating a hierarchical report using the recursive with clause
  • Creating a tree based on hierarchical data

Hierarchical reports with drilldown

Our aim is to introduce drilldowns in APEX and to use them for hierarchical data reporting.

Check the Hierarchical reports with drilldown region on page 4 of the reference application. The EMPLOYEE_ID column of the Hierarchical Report region has a link on it. Let us now see the process of creating this link. Go to the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required