Oracle Apex 4: How do I add text in between search bar and report


On the interactive report page, what's the best way to add text and/or checkboxes in between search bar and report?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Try this.,
Hoping in the Region Source of Interactive Report  include the text or checkbox in the select statement.

Then, this will come in between search bar and the report.

For a check box you can create it by using

htmldb_item.checkbox or apex_item.checkbox

For ex:
SELECT APEX_ITEM.CHECKBOX(1,deptno,NULL,'10:20',':') " ",
FROM   emp

See, the below link for creation of checkbox or writing text in it.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
maheflin25Author Commented:
gopisera - thanks for the tips.

I'm trying to create two checkboxes that will (un)sort the interactive report.
Without modifying the template, you can't add anything between the report's search bar and the report data.

If all you need to do is the ability to sort the data, the IR already includes that capability (in the Actions dropdown menu).

Another alternative would be to position a separate region above the IR, where you include your checkboxes, then modify the query to do an "order by" based on the checkbox status.
maheflin25Author Commented:
Since no one cannot find a solution to my question, I'll need to close it.

maheflin25Author Commented:
No one haven't provide a better solution to my question. Please go ahead and close this.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.