APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


Tips & Tricks


Oracle APEX column with %

Written by Richard Weug on Tuesday, 01 May 2012 09:47. Posted in Tips and Tricks

Or,.. how to format the way an report columns looks,..

If you want to beautify your number column inside an APEX report with a percent-sign then most of you would do like this:
select column_name || '%' as column_name
from my_table


Create a custom download link

Written by Richard Weug on Monday, 07 May 2012 09:43. Posted in Tips and Tricks

The default method of downloading an Interactive Report is clicking on the Action button, then the Download button and then selecting the desired format.
For the CSV report download format:


Images in APEX interactive report

Written by Richard Weug on Tuesday, 03 April 2012 11:49. Posted in Tips and Tricks

I'm quite sure that many APEX developers have face problems when using images in interactive report. There is e.g. problem in filter and when export report you see escaped image HTML tag.


Friendlier exception message from AJAX call

Written by Richard Weug on Wednesday, 29 February 2012 10:09. Posted in Tips and Tricks

While it is very easy to create a "Form and a Report" on a single table (or view), just follow the wizard, for end users it is not always intuitive that they should navigate to the form page to remove the record. A nicer solution is the one described by Anthony Rayner in this demo page. This solution uses a number of -very simple- dynamic actions to include a little trashcan on the report page.


Interactive Reports, Handy Tips Part 1

Written by Richard Weug on Thursday, 01 March 2012 10:00. Posted in Tips and Tricks

Interactive reports are great and take no time to build however they all look the same regardless of the theme you are using: Problem 1; and when you have lazy users who prefer one mouse click than two (which makes you scream when they have a tonne of functionality at their hands and the first thing they say is not thanks but I have to click the mouse twice… arrrgghhhh) we encounter: Problem 2; Solving this is pretty simple and you can use the following tips to achieve that….