Customising Interactive Reports through CSS and jQuery
When creating APEX Interactive Reports I regularly use CSS combined with jQuery to change the layout and display. Quite often these may be something simple like for instance disabling a particular filter so that that user cannot remove it.
Time and time again I revisit my older applications to ‘borrow’ functionality from these for my newer applications. I thought it would be quite handy to share these with the community and update this list when something new is discovered
So here is my collection of code snippets I use with Interactive Reports in no particular order.
For the CSS you can place the code snippets in various locations including the Theme Roller.
Initcap all the Column Names
One for the lazy; useful for those select * queries
You can also use uppercase instead of capitalize if you wish
Change the width of the edit link
This example creates a really wide edit link column, but you can change it to as small as possible if you wish to maximise space for the other columns.
Centralise the Edit Link Icon
Type the following in to Link Attributes (found within the Interactive Report Attributes) to place the edit link icon in the middle of the column instead of the default left position.
Showing the Link Column label
You can also add an optional .text(“Edit”) to the end of that string to change the Label from ‘Link’ to ‘Edit’.
Hide Default Report Option
Or how about hide the Default Report button, so that only the charts and Pivot Reports are visible.
Here is an Interactive Report before above changes have been applied.
And here is the same Interactive Report after many of the above changes have been applied.
Matt is an experienced APEX solution designer having designed numerous complex systems using a broad range of Oracle Technologies. Building on his previous experience of Oracle Forms & PL/SQL, he is entirely focused on providing functionally rich APEX solutions. Matt promotes APEX as a software platform and openly shares best practises, techniques & approaches. Matt has a passion for excellence and enjoys producing high quality software solutions which provide a real business benefit.