I am looking beyond child reports (mostly drill-down). This is because, from my main report, I need the ability to take user to different table row based on values in different columns in each row (if possible).
SQL Developer offers Drill Down Reports. You can right click on a row and then you get the option to start another report with these values:
Thanks, Yes I am aware of drill-down but what I would like to (ideally) is to make that value as a clickable URL using builtin SQLDEV link functionality (see http://www.thatjeffsmith.com/archive/2012/03/sql-developer-query-grid-tricks/#comment-74930)
Hence the question, drill-down, child reports are already available in my report but a clickable link makes it more user intutive as drill-down reports are hidden until intentional user interaction (you have to right-click)