Oracle Apex 19.2 - Create Radio Buttons in Classic Report

Question

Is there a good visual tutorial that takes through the various steps on how to create radio buttons in Apex 19.2? This tutorial Creating a Classic Report having radio button on each row helped me and I’m looking for a similar one..

In my case, I would like to add a radio button to each row of my classic report which when selected would add some of the informations selected by the radio button in a text field in the same page.

Any advice is much appreciated.

Thank you

Answer 1

Install Sample Reporting application on your APEX instance (preferably on apex.oracle.com as Dan suggested).

Navigate to the Classic Report page.

Change the query to the report to the following:

select rowid,
       ID,
       PROJECT,
       TASK_NAME,
       START_DATE,
       END_DATE,
       STATUS,
       ASSIGNED_TO,
       COST,
       BUDGET,
       apex_item.radiogroup(1,TASK_NAME) ACTION
from EBA_DEMO_IR_PROJECTS
where (nvl(:P3_STATUS,'0') = '0' or :P3_STATUS = status)

Note the added column "ACTION" which consists of the apex_item.radiogroup with TASK_NAME value. Let's assume that this is the value that you want to pass to another page item.

Open that column's attribute under Page Designer and disable "Escape special characters" attribute and add a CSS Class (e.g. mycolumn)

Create a Page Item (e.g. P3_NEW).

Now add the following Dynamic Action

• Event > Click
• Selection Type > jQuery Selector
• jQuery Selector > #classic_report .mycolumn input

Your true action will be of the type Set Value and the Set Type is JavaScript Expression with the following code:

this.triggeringElement.value

Your affected element is P3_NEW and disable Fire on Initialization