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 – …

Oracle APEX 5 introduced a new feature called “Warn on Unsaved Changes” at page, item and button level. This is a great feature by enabling any unsaved changes to ask for user confirmation before leaving the page. Purpose of this blog is, if we have custom form element such as APEX_ITEM on a classic report …

This blog is about how you can control the tab selection using jQuery for Tabs Container region. I have seen, there are many other-ways to achieve same – but I have tried to following APEX’s way and manage the selection by APEX’s JavaScript code. $(‘#<tabs_container_region_id> ul.t-Tabs:first’).aTabs(‘getTabs’)[‘#SR_<sub_tab_region_id>’].makeActive(); Working Demo Hope this helps. Regards,Jaydip Bosamiyajbosamiya@gmail.com

APEX Office Print (AOP) is a great document printing library for Oracle APEX. While using AOP to print IR or Chart regions into document, you may like to use “aop-region-as” attribute to inform AOP printing engine to print output in different formats. Following are the attribute values, you may set: client_svg: This will create SVG object …

Oracle JET Charts is a beautiful chart library which has out-of-box support in Oracle APEX version 5 on-wards. Purpose of this blog is to introduce with a small tweak in Series Bar Chart. Problem When you use Series Bar Chart and if you have some series with NULL or ZERO value, the bar will not appear …