Working with APEX_ITEM.Radiogroup, pass value in item through report using RadioButton.

Hi,

Working with apex_item API is always a complex and the most important part. This a quick post on how to work around with apex_item.radiogroup. 

Report Query:

1. SELECT apex_item.radiogroup(

              p_idx            => 1

            , p_value          => EMP_ID

            , p_selected_value => :P_EMP_ID

            , p_display        => NULL

            , p_attributes     => 'onclick= "javascript:$x(''P_EMP_ID'').value='||EMP_ID|| '"')   radio_select,

emp_name,dep_name,sal from emp.

2. Create a item on the page or the region P_SEQUENCE_NUMBER

3. Make the radio_select column in the report attributes standard.

The result of above will be that when you select the radio button in a report, its corresponding emp_id will be reflected in P_EMP_ID which you further can use to pass the value in any process or dynamic action.

Thank You!