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?