APEX – Report Rows Clickable to detailed page

Introduction

 This document describes how to make an Apex Reports clickable to a detailed page with an option of entire row selection.

In Apex, Report is an essential tool which is in classical, interactive & other formats. We have an option to bring a detailed page from a report screen using column link option. But it is based on a single column clickable option, which can be achieved by applying column link option in report attributes.

Here we are going to a detailed page not based on a single column. It will be based on the entire row clickable option using Jquery Properties.

 

Benefits

Ø We can click anywhere on the entire row of an report, which will brings us an detailed page.

 Steps to follow

 Step1:

Create a new page.

Step 2: 

Create a region -> report -> Interactive report ->Name for

the  report ->SQL query.

 

Step 3:

Apply Column Link Option to any one of the columns from

report.

 

Report Region is Created.

Step 4:

Go to Edit Page.

Choose Execute when Page Loads.

 

Apply the following code

 

$(‘a[href*=”17″]’).each(function(index) {

lnk = $(this).attr(‘href’);

$(this).parent()

.parent(‘tr’)

.attr(‘data-href’, lnk)

.click(function(){

window.location=$(this).attr(‘data-href’);

})

.mouseover(function(){

$(this).css(‘cursor’, ‘pointer’);

})

.mouseleave(function(){

$(this).css(‘cursor’, ‘default’);

})

});

Note: 

  1. href*=”17″ – is the detailed Page Number.
  2. Column, which has Link Property, has to be shown on the report.

[On Changing the link column as hidden, the above functionality will

not work].

 

Call To Action: 

For Oracle apex development and customization please do visit our company website  https://doyensys.com/

Conclusion:

Thus a user can able to navigate to detailed page by clicking anywhere on the report row.

Recent Posts