Description: 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 important tool which is in classical, interactive & other formats. We have an option to bring a detailed page from a report screen using a column link option. But it is based on a single column clickable option, which can be done 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 a report, which will brings us a detailed page.
- Steps:
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 the report.
Report Region is Created.
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:
- href*=”17″ – is the detailed Page Number.
- Column, which has Link Property, has to be shown on the report. [ Don’t Hidden the Column ].
- Summary:
- Thus a user can able to navigate to detailed page by clicking anywhere on the report row.
Queries?
Do drop a note by writing us at contact@staging.doyensys.com or use the comment section below to ask your questions.
