0 Replies Latest reply on Dec 5, 2016 2:09 PM by unleashed

    SQL Developer Report child report with variable dblink

    unleashed

      Just a question if this is possible.

       

      I want to build a parent - child report in SQL Developer.  The data in the parent is a rollup of data from several remote databases, accessible via a dblink.  I would like to be able to click on the parent row, then have the child report run a query that would get additional data from the remote db.  I know how to deal with binds for the child normally, but can this be done where the remote table is build dynamically?

       

      I'm running on a 12.1.0.2 db.

       

      Thanks in advance.