Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pretius Nested Report Plugin - How to create nested report within nested report e.g. more than 2 lev

PaulPMay 17 2018 — edited Jun 6 2018

APEX V5.1.3,

ORACLE 11.2

Chrome latest version

I've downloaded and imported the Nested Report Plugin from http://apex.pretius.com/apex/f?p=105:NESTED_REPORTS::::::

I followed the install and setup steps here: http://apex.pretius.com/apex/f?p=105:NESTED_REPORTS:::NO:::
At the bottom of the steps it mentions "...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)."

Bit short on details!...Do you create multiple DAs?... or multiple TRUE actions within the same DA? Not sure how they would all link up in a hierarchy. How do you get the expand icon to appear in level 2?

The demos show more than 2 levels but I can't see how this is done in the code.  How is it possible to do create multiple nested reports via PK to FK joins across multiple tables?

Also does anyone know if this Plugin will be supported in V18?

thanks in advance

PaulP

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 4 2018
Added on May 17 2018
4 comments
2,378 views