i have interactive report
i added 2 buttons
Approve Reject inside it
"P_req_no primary key"
For Approve button
Type: Link
link text: <span class="t-Button t-Button--success" aria-hidden="true">Approve</span>
Link Attribute: data-id=#REQUEST_NO#
For Reject button
Type: Link
link text: <span class="t-Button t-Button--danger" aria-hidden="true">Reject</span>
Link Attribute: data-id=#REQUEST_NO#
I want to make dynamic action for both button
When i press on Approve
'Update mm set status='Approved' where req_no=:P_req_no;
then refresh region
when i press on Reject
'Update mm set status='Rejcted' where req_no=:P_req_no;
Then refresh region