Re-use your Interactive Report query using APEX_IR.GET_REPORT
Oracle APEX Interactive Report (IR) has rich APIs to tweak, customize or control the user interactions. One of the API package I have recently used is APEX_IR . Purpose of this blog is to show you how you can re-use your IR run-time query and filters to build all custom reports. So, let's define a requirement - You have two regions in a page - First region with summary of Department wise salary total. Second region with all list of employees. Now, when I apply any filters to detail region (which will be IR) then, the data of summary region should also change. Create region 1 - summary region (classic report) with following query select d.deptno, d.dname, sum(e.sal) from dept d, emp e where d.deptno = e.deptno and e.empno in(select c001 from apex_collections where collection_name = 'P16_EMP') group by d.deptno, d.dname order by d.deptno Create region 2 - employee list region (IR) with f...
