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!

How to reference an interactive report row column & value

RayWonAug 7 2018 — edited Aug 8 2018

I want to have 2 interactive reports on the same page, one after the other.

I am having trouble getting the 2nd report SQL statement to use the value of one of the columns of the currently highlighted row.

Taking DEPT & EMP tables data as example:

The first report SQL statement:

select deptno, dname from dept;

The 2nd report SQL statement:

select ename, job, mgr, sal from emp where deptno=[first report deptno];

How do I reference the 1st report, its row & column & the value there in?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 5 2018
Added on Aug 7 2018
2 comments
3,752 views