After reading Oracle Apex documentation we came up with this select statement:
1 2 3 4 | SELECT APEX_ITEM.CHECKBOX2(1,empno) “Select”, ename, job FROM emp ORDER BY 1 |
Is it enough (unfortunately no)?
We used to deal with that in previous version by changing column to “Standard Report Column” in Report Attributes > Column Attributes. The point is, it’s not possible in main view of Oracle Apex 5.0 . So what now?
There are at least three solutions:
Now we can enjoy report with checkboxes.
P.S. We would like to thank Jason Lyle for comments which helped in creating this article.