How to create nested reports in Oracle APEX 18.2 dynamic action plugin v2.0

This example usage guide requires EMP and DEPT tables. Example shows simplest implementation of the plugin in Classic Report.

0.  Execute your schema two files: in downloaded plugins
PRETIUS_APEX_NESTED_REPORTS.plb  PRETIUS_APEX_NESTED_REPORTS.sql 
1.   Install the plugin

2.   Create Classic report e.g. select * from DEPT

3.   Create derivied column

1.   Change derivied column Type to Link

2.   Set Target to URL and set javascript:void(0)

3.   Set Link Text to <span class="fa fa-search"></span><span class="DEPTNO" style="display:none">#DEPTNO#</span>

4.   Set Link Attributes to class="showEmployees"

4.   Create dynamic action "My first nested report on DEPT table"

1.   set Event to Click

2.   set Selection Type to jQuery Selector

3.   set jQuery Selector to .showEmployees

4.   set Event Scope to Dynamic

5.   set Static Container (jQuery Selector) to body

5.   Create true action Pretius APEX Nested reports [Plug-In]

1.   Set Details query to select * from emp where deptno = '#DEPTNO#'

2.   Set Affected Elements > Selection Type to Report

3.   Set Affected Elements > Region to Classic report created in step #2 "Create Classic..."

4.   Configure the plugin settings

6.   Save and run page

If you want to create nested report within nested report remember that every dynamic action have to reference first parent report by Affected element (Classic report, Interactive report or Static HTML table).

Download plugins

http://apex.pretius.com/apex/f?p=105:NESTED_REPORTS::::::

Credited for Bartosz Ostrowski