Posts

Showing posts from September, 2013

PDF Download not working in Interactive Report : Oracle APEX: SOLVED Finally

This was one of my biggest concerns while using Oracle APEX. I will often enable PDF download from Interactive Report setup in a page, but the download was generating only a corrupt file. My google searches also did not yield any result. Then came the news that I have to install BI Publisher in order to use the feature. This message was floating in OTN forums related to this topic. I got disheartened learning this. Why would Oracle provide such a tool if it can't support PDF download by default. Then came the SOLUTION for the problem. In one of documentation available in Oracle's website I found the news I have been searching for a long time. The APEX download (4.2.2) had been shipped with a war file fop.war. This file is available in the folder  apex_4.2.2\apex\utilities\fop The installation instructions mentioned that I need to deploy this war file in OC4J but which requires  Oracle Containers for J2EE (10.1.3.2 or above) [I don't have a clue what this is]. ...

Oracle Apex - Position IR Control Panel items in one line

Image
This mini tip is to help those who does not know CSS much and those who know CSS but do not know where to apply code in Oracle Apex. In Interactive reports by default the control panel items (filters/report titles) etc will be displayed one line below the other. If you have ten filters applied on an IR/Interactive Report then the panel when expanded occupies 10 lines in the report just like the one below: This mini tip will enable you to change this like the one below: If you have a Page 0/Global Page created within your application do not follow step 1. Step 1: Create a Global Page/Page 0 in your application. Step 2: Create a HTML region with template "No template" in this page. Step 3: Add the following CSS inside this region source and save. <style>   table#apexir_CONTROL_PANEL_COMPLETE tr{float:left;padding-right:15px;} </style> This is all you have to do to change Interactive report's control panels visibility option in your entire a...