How to create checkbox in report in Oracle Apex 5.0 – quick tip

Default author image
Łukasz Wiśnicki

Oracle APEX & PL/SQL Developer

  • December 3, 2015

Contents

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.

Looking for a software development company?

Work with a team that already helped dozens of market leaders. Book a discovery call to see:

  • How our products work
  • How you can save time & costs
  • How we’re different from another solutions

footer-contact-steps

We keep your data safe: ISO certified

We operate in accordance with the ISO 27001 standard, ensuring the highest level of security for your data.
certified dekra 27001
© 2025 Pretius. All right reserved.