Thursday 22 October 2015

Select all Checkboxes in IR - APEX 5

If <input type="checkbox" onclick="$f_CheckFirstColumn(this)"> doesn't work for you in APEX 5 Interactive Reports then you will need to disable Fixed Headings (standard). Fixed headings splits the report into two tables and the function won't work.

5 comments:

Alejandro Ortiz Vivas said...

it´s work fine for me

Jozef SVK said...

Hi Denes,

some improvements it this bug ?

I would like to use fixed headers stuff but i need to have some checkbox in IR too.

reagrds

J

Anonymous said...

Hi,

You have to define "percent graphic" as type in the dedicated column properties.

Jens Gauger said...

Hi,

another approach, even works with fixed headers:

<input type="checkbox" onclick="javascript:$f_CheckAll(this, this.checked, $('[name=f01]'));">

In my case, i'm using this with checkbox columns generated with APEX_ITEM.CHECKBOX2. You have to replace the f01 with the correct sequence of your checkbox column. APEX_ITEM.CHECKBOX2(1, null) => f01, APEX_ITEM.CHECKBOX2(10, null) => f10.

Regards,
Jens

Wouter de Waard said...

In addition to Jens' answer, I also needed a all-on/all-off checkbox header on a IR report with fixed headers.

Jens' is actually nicer than mine... but nevertheless, here is my solution:


I change the heading of checkbox column in the IR report to:

input id="select-all" type="checkbox" onclick="
$('#select-all').click(function(event){
var chkst;
chkst=this.checked;
$(':checkbox').each(
function(){
this.checked=chkst;
}
)
}
)"



Regards
Wouter