Oracle APEX Blogs - Jaydip Bosamiya - Oracle APEX Consultant

apexpert.in has just published a blog about how you can build custom nested interactive report in Oracle APEX. Earlier, we have published couple of blogs about classic report as bellow. It is on the same line for Interactive Report. Nested Class Report Enhanced Nested Report Find our more and click here to read complete blog post. Hope that helps! Regards, Jaydip Bosamiya jbosamiya@gmail.com

I have been came across an interested requirement ( which is very valid ) to add scrollbars on the top of the regions! I have seen many times when you want to scroll right to see further data of first few records, you will scroll vertically to get to the horizontal scroll-bars. And then you do horizontal scroll and then vertical scroll to go top of the region. Aren't you ??? :-) So, to ease the user interaction with IR - we should have a scrolling option somewhere on the top of the region ? - For Sure So, how can we add scrollbars on top of the report for an Interactive Report ? By default IR Fix the column headers to the page. This setting gives us an opportunity to add scroll-bars just below the column header as well. Just by adding following CSS line you should get a beautiful scroll-bars just below you header and it works really great as well. #MYIR .t-fht-thead{   overflow: auto !important; } I am also trying to find a way to add same function...

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...