For new projects implemented with Oracle Application Express we are happily using Apex 5. One of the first questions was “how to create checkbox column in report?”

After reading Oracle Apex documentation we came up with this select statement:

Is it enough (unfortunately no)?

checkbox_fail

 

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:

  1. While using Page Designer change the Column Type to “Percent Graph”
    page_designer_column_type
  2. We can switch Oracle Apex view to that what we used to in older versions.

    apex_5_0_component_view

    Now we can simply switch column type to “Standard Report Column”
    apex_5_0_standard_report_column
    Next back to “Page Designer” view.
    apex_5_0_page_designer
  3. We can leave the Column Type as “Plain Text” and change setting called “Escape special characters” to “No”
    Escape_special_char

Now we can enjoy report with checkboxes.

checkbox_success

P.S. We would like to thank Jason Lyle for comments which helped in creating this article.

Share