Adding a checkbox to rows in classic report

by

How to easily work with checkboxes in a classic report.

When working with classic reports, sometimes its helpful to include a checkbox on the row so that you can offer some ‘bulk’ options. Adding the checkbox is as easy as adding a new column to the query and using apex_item.checkbox(<nn>,<columnValue);

If you want to include a ‘check all’ checkbox in the column header then simply edit the column and set the header to something like (we’ll use the class to find these checkboxes with jQuery:-

<input class="checkAll" type="checkbox">

There are various ways of triggering the change to the checkboxes in the report when the one in the header is selected. Here are a couple

  1. In the ‘Execute when page loads’ part of the page, add the following which will use jQuery to attach the click action to the checkbox.
$('.checkAll').click(function() {
  $(this).closest('table').find('input:checkbox').prop('checked',this.checked);
});

Alternatively, if you have more than one report on the page with checkboxes, you can accomplish the same using a function:-

function checkboxSetAll (item,checked) {
 $("#"+item+" input[type=checkbox]").attr('checked',checked);
}

and then calling the function using an ‘onClick’ event on the checkbox in the header.