Thursday, October 11, 2012

Grouping visually in Interactive Report using jQuery

There will be sometimes a need arises to group the Interactive Report using the background color to visual identify the group of records.

So using jQuery in Interactive Report is one of the simplest solution.

Step 1: Create a Interactive Report
Step 2: Identify the Group Column
Step 3. Write a Dynamic Action which fires on refresh of the Interactive Report region. The Following code will do the job

var gcolor = '#dddddd';
var gprev_city = '';
var gcity ;

$("table.apexir_WORKSHEET_DATA > tbody > tr > td[headers='CITY']").each(function(){
    gcity = $(this).text();
        if (gprev_city != gcity) {
    if (gcolor == '#dddddd' )
        gcolor = '#6092D0';
        gcolor = '#dddddd';
        gprev_city = gcity ;

The Sample Application to demonstrate this feature is at

Wednesday, September 5, 2012 is now running on Apex 4.2

The great news for Apex Developers is is upgraded to unreleased Apex 4.2 version which now supports building mobile apps for IOS devices and more mobile platforms.

Tuesday, February 21, 2012

Apex 4.1.1 is Released

Wednesday, February 8, 2012

Refreshing a Partial Page Refresh / Ajax based calendar Manually

Sometimes using Javascript code if you want to refresh just the Calendar region you ca use the javascript apex.widget.calendar.ajax_calendar('S','same') this will refresh the Calendar region, provided the Calendar is of type "Partial Page Refresh"/Ajax based.