Using Apex 4.2.1
Actually I have a Apex (IR) report and want to create a javascript function where user can see message if two report columns date are not matched. for example, in report I have column date1 and date2 so date1 can not be less than date2. so I have create a link and when click on link then popop window should comeup (javascript) message box where function compare those two dates. so i m struggling how to get report column values in javascript function.
Thx.
Instead of click-popup solution you could use the Highlight and Compute features of IR:
Actions->Format->Compute, use DECODE or CASE expressions to return 1 when date1 is lesser than date2.Actions->Format->Highlight, select a condition and a color.Actions->Select Columns.Actions->Save Report->Save As Default Report Settings.If you steel want to check column values by JS, use Dynamic Action for report region on After Refresh event. For example, next code goes through rows of IR based on DEPT table and alerts DNAME and LOC columns:
var $dnames = $( 'td[headers=DNAME]', this.triggeringElement );
$( 'td[headers=LOC]', this.triggeringElement ).each( function( indx, El ) {
alert( $( El ).html() + " - " + $dnames.eq( indx ).html( ) );
} )
As you can see, I use report column aliases to filter cells.
